Menu
Community /Pin to ProfileBookmark
@NogDogAug 01.2017 — #I'll have some thoughts tonight (if I remember), but no time now to post them. (It's not a quick, simple, "just change X.") @NogDogAug 02.2017 — #Well, I ended up having some fun(?) with this. There's no defensive coding, and you could possibly enhance it to ignore '.' and '..', and perhaps any file name starting with a dot? I'll just throw it out here, let you digest it, then ask questions about anything you don't understand (after you look up the function first on php.net ? ).
Dir.php:
Sample usage:
@NogDogAug 02.2017 — #I just concentrated on the PHP directory object. I figured how it's actually implemented in HTML/JavaScript is a separate issue for those who like writing client-side code. ?@NogDogAug 02.2017 — #No, it could just be HTML/PHP, where each column header would be a link with some query params to tell PHP how you want to sort the table -- so you'd need some PHP logic to figure out if it should be an ascending or descending parameter. A JavaScript solution would probably be more responsive, as it could just sort it locally in the browser and would not have to send a new page request to the web server -- and there's probably a JQuery method you could use to add column-based sorting quite easily, I suspect. For that matter, there's probably a PHP-based class/function/package out there that could help implement what you're describing. If you roll your own in HTML/PHP, then you need to add <a> tags with the necessary links to each table header (or maybe to a couple down and up arrow icons?) with the necessary info, something like
Then in ypur PHP code, you'd look for $_GET['column'] and $_GET['direction'] (or whatever you prefer to call them), and based on those values, decide which sort method to call in the Dir class and whether or not the ascending flag is true or false.@NogDogAug 02.2017 — #I might do something like this (untested):
[RESOLVED] PHP Sortable table ASC AND DESC (NOT javascrript AND NO (My)SQL)
Somebody recommended me to ask it at NoggDog … but of course any good solution of somebody else is fine
I’m making a directory listing of an homepage with 3 columns : file name – time – size
Now I want to make the columns sortable – ascending AND descending – in PHP (NOT javascript!!)
But I don’t get it to work (only one way works)
But I want it to work from ASC to DESC and visa versa.
Can you help me out please and make changes to the code below so it works (td header click asc and td header click desc for all three columns )??
Code so far
[code=php]<?php
error_reporting(0);
@ini_set(‘display_errors’, 0);
$dir = “*”;
$read_dir = glob($dir);
function sort_name($a,$b) {
return glob($a) < glob($b);
}
function sort_size($a,$b) {
return filesize($a) < filesize($b);
}
function sort_time($a,$b) {
return filemtime($a) < filemtime($b);
}
if($_GET[‘sort’]==’size’) {
usort($read_dir, “sort_size”);
}
elseif($_GET[‘sort’]==’time’) {
usort($read_dir, “sort_time”);
}
else {
sort($read_dir, “sort_name”);
}
echo “<table border=’1′>”;
echo “<tr>”;
echo “<td><a href=?sort=name>Name</a></td>”;
echo “<td><a href=?sort=size>Size</a></td>”;
echo “<td><a href=?sort=time>Time</a></td>”;
echo “</tr>”;
foreach ($read_dir as $files) {
echo “<tr>”;
echo “<td style=’width:300px;’>” . $files . “</td>”;
echo “<td style=’width:170px;text-align:center;’>” . date(“d.m.Y H:i:s”, filemtime($files)) . “</td>”;
echo “<td style=’width:80px;text-align:right;’>” .filesize($files) . ” B</td>”;
echo “</tr>”;
}
echo “</table>”;
?>
Kind regards
Sign in
to post a comment21 Comments(s) ↴
0
@NogDogAug 01.2017 — #0
@NogDogAug 02.2017 — #Well, I ended up having some fun(?) with this. There's no defensive coding, and you could possibly enhance it to ignore '.' and '..', and perhaps any file name starting with a dot? I'll just throw it out here, let you digest it, then ask questions about anything you don't understand (after you look up the function first on php.net ? ).Dir.php:
[code=php]
<?php
class Dir
{
private $data = array();
private $sortField = 'name';
private $direction = 1;
public function __construct($path)
{
$handle = opendir($path);
while($data = readdir($handle)) {
$this->data[]['name'] = $data;
}
foreach($this->data as $ix => $data) {
$this->data[$ix]['size'] = filesize($data['name']);
$this->data[$ix]['timestamp'] = date(
'Y-m-d H:i:s',
filemtime($data['name']
));
}
}
public function sortByName($asc = true)
{
$this->sortBy('name', $asc);
}
public function sortByTime($asc=true)
{
$this->sortBy('timestamp', $asc);
}
public function sortBySize($asc=true)
{
$this->sortBy('size', $asc);
}
private function sortBy($field, $asc=true)
{
$this->sortField = $field;
$this->direction = $asc ? 1 : -1;
usort($this->data, array($this, 'sort'));
}
private function sort($a, $b) {
return strnatcasecmp(
$a[$this->sortField],
$b[$this->sortField]
) * $this->direction;
}
public function data()
{
return $this->data;
}
}
[/code]Sample usage:
[code=php]
<?php
require_once 'Dir.php';
date_default_timezone_set('America/New_York'); // if not set in your PHP config, set to what you want
$dir = new Dir('/users/creace/Projects'); // set to desired actual directory path
$dir->sortByTime(false); // descending
$data = $dir->data();
echo "<table>n<tr><th>Name</th><th>Size</th><th>Date</th></tr>n";
foreach($data as $row) {
echo "<tr><td>{$row['name']}</td><td>{$row['size']}</td><td>{$row['timestamp']}</td></tr>n";
}
echo "</table>n";
[/code]0
@NogDogAug 02.2017 — #I just concentrated on the PHP directory object. I figured how it's actually implemented in HTML/JavaScript is a separate issue for those who like writing client-side code. ?0
@NogDogAug 02.2017 — #No, it could just be HTML/PHP, where each column header would be a link with some query params to tell PHP how you want to sort the table -- so you'd need some PHP logic to figure out if it should be an ascending or descending parameter. A JavaScript solution would probably be more responsive, as it could just sort it locally in the browser and would not have to send a new page request to the web server -- and there's probably a JQuery method you could use to add column-based sorting quite easily, I suspect. For that matter, there's probably a PHP-based class/function/package out there that could help implement what you're describing. If you roll your own in HTML/PHP, then you need to add <a> tags with the necessary links to each table header (or maybe to a couple down and up arrow icons?) with the necessary info, something like[code=html]
<th>Name <a href='?column=name&direction=asc><img src='/img/uparrow.png'></a> <a href='?column=name&direction=desc><img src='/img/downarrow.png'></a><th>
[/code]Then in ypur PHP code, you'd look for $_GET['column'] and $_GET['direction'] (or whatever you prefer to call them), and based on those values, decide which sort method to call in the Dir class and whether or not the ascending flag is true or false.
0
@NogDogAug 02.2017 — #I might do something like this (untested):[code=php]
$dir = new Dir('/directory/to/sort');
$column = !empty($_GET['column']) ? $_GET['column'] : 'name';
$direction = (!empty($_GET['direction']) and $_GET['direction'] == 'desc') ? false : true;
switch($column) {
case 'size':
$dir->sortBySize($direction);
break;
case 'time':
$dir->sortByTime($direction);
break;
default:
$dir->sortByName($direction);
}
$data = $dir->data();
// now echo out the data in your table...
[/code]