Sorting after file size

chrisdee

Hello.

I'v got a bunch of wav files in a directory (ubuntu 9.10 server) wich I am listing out the name and size of. The script is below. I manage to sort by filename, but how do I sort the output after the file size ?

<?php

print "<table border=1>";
print "<tr><td bgcolor=lightgrey>Filename</td><td bgcolor=lightgrey>Size</td></tr>";

$files = glob("*.wav");

foreach ($files as $file) {
 echo "<tr><td><a href=$file>$file</a></td><td>" . substr(round(((filesize($file))/1024)/1024,2),0,3) . " MB</td></tr>";
}
print "</table>";
?>

halojoy

if you have one record for each wav in one database table 'wavtable'
you can let the db do the sorting in SQL query
Very easy!

// smallest filesize first
$sql = "SELECT filename FROM wavtable ORDER BY filesize ASC";

// largets filesize first
$sql = "SELECT filename FROM wavtable ORDER BY filesize DESC";

And the filenames will come out one by one ordered by size

laserlight

You could try something along these lines:

// Associate the file names with their corresponding sizes.
$file_info = array();
foreach (glob("*.wav") as $filename) {
    $file_info[$filename] = filesize($filename);
}

asort($file_info); // Sort by file size.

foreach ($file_info as $name => $size) {
    // Print the file's name and corresponding size.
    // ...
}

chrisdee

laserlight;10943631 wrote:

You could try something along these lines:

// Associate the file names with their corresponding sizes.
$file_info = array();
foreach (glob("*.wav") as $filename) {
    $file_info[$filename] = filesize($filename);
}

asort($file_info); // Sort by file size.

foreach ($file_info as $name => $size) {
    // Print the file's name and corresponding size.
    // ...
}

That worked great. Thank you, thank you, thank you🙂

<?php
print "<table border=1>";
print "<tr><td bgcolor=lightgrey>Filename</td><td bgcolor=lightgrey>Size</td></tr>";

// Associate the file names with their corresponding sizes.
$file_info = array();
foreach (glob("*.wav") as $filename) {
    $file_info[$filename] = filesize($filename);
}

asort($file_info); // Sort by file size.

foreach ($file_info as $name => $size) {
 print "<tr><td><a href=$name>$name</a></td><td>".substr(round((($size)/1024)/1024,2),0,3)." MB</td></tr>";
}
print "</table>";
?>

chrisdee

halojoy;10943628 wrote:
if you have one record for each wav in one database table 'wavtable'
you can let the db do the sorting in SQL query
Very easy!
// smallest filesize first
$sql = "SELECT filename FROM wavtable ORDER BY filesize ASC";

// largets filesize first
$sql = "SELECT filename FROM wavtable ORDER BY filesize DESC";
And the filenames will come out one by one ordered by size

Thanks. I'll try that also🙂

halojoy

Hi!
🙂
Here you have *.wav files sorted in a list.
I have written comments in my script

<?php

//open small database file in current directory
$db = sqlite_open('database.sqlite');
//create a table 'my_files' with columns: name, size
sqlite_exec($db, "CREATE TABLE my_files (name TEXT, size INTEGER)");

//insert into my_files wav files found
$filenames = glob("*.wav");
foreach($filenames as $file){
	$size = filesize($file);
	sqlite_exec($db, "INSERT INTO my_files VALUES ('$file',$size)");
}

//display all files ordered by size, largest first
$list = sqlite_array_query($db, "SELECT * FROM my_files ORDER BY size DESC");
foreach($list AS $file)
	echo $file['name'].' - '.$file['size'].' bytes<br />';

//delete database file
sqlite_close($db);
unlink('database.sqlite');

?>

laserlight

halojoy wrote:
open small database file in current directory

You might as well open :memory:, i.e., an in-memory database. But given that this can be accomplished as in my example, I see no point unless it can be shown that this is a performance bottle neck and that this alternative solution is measurably faster. If you do want it to be faster, you probably should wrap the inserts in a transaction and reuse a prepared statement, e.g.,

<?php

try {
    $db = new PDO('sqlite::memory:'); // Create an in-memory database.

// Create the table and insert the filenames and corresponding sizes.
$db->beginTransaction();
$db->exec('CREATE TABLE Files ("name" TEXT, "size" INTEGER)');
$stmt = $db->prepare('INSERT INTO Files VALUES (:name, :size)');
foreach (glob('*.wav') as $filename) {
    $stmt->bindValue(':name', $filename, PDO::PARAM_STR);
    $stmt->bindValue(':size', filesize($filename), PDO::PARAM_INT);
    $stmt->execute();
}
$db->commit();

// Retrieve the filenames and sizes sorted in ascending order by size.
$stmt = $db->query('SELECT "name", "size" FROM Files ORDER BY "size"');
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // Print $row['name'] and $row['size']
    // ...
}

$db = NULL; // Close the database connection.
} catch (PDOException $e) {
    die('Error: Could not create in-memory database.');
}

It is quite clear that this is more complicated than just using two loops, an associative array, and asort().

chrisdee

halojoy;10943646 wrote:

Hi!
🙂
Here you have *.wav files sorted in a list.
I have written comments in my script

<?php

//open small database file in current directory
$db = sqlite_open('database.sqlite');
//create a table 'my_files' with columns: name, size
sqlite_exec($db, "CREATE TABLE my_files (name TEXT, size INTEGER)");

//insert into my_files wav files found
$filenames = glob("*.wav");
foreach($filenames as $file){
	$size = filesize($file);
	sqlite_exec($db, "INSERT INTO my_files VALUES ('$file',$size)");
}

//display all files ordered by size, largest first
$list = sqlite_array_query($db, "SELECT * FROM my_files ORDER BY size DESC");
foreach($list AS $file)
	echo $file['name'].' - '.$file['size'].' bytes<br />';

//delete database file
sqlite_close($db);
unlink('database.sqlite');

?>

Thank you so much. I'v got more than I asked for. What a great site and nice people.🙂🙂

chrisdee

laserlight;10943648 wrote:
You might as well open :memory:, i.e., an in-memory database. But given that this can be accomplished as in my example, I see no point unless it can be shown that this is a performance bottle neck and that this alternative solution is measurably faster. If you do want it to be faster, you probably should wrap the inserts in a transaction and reuse a prepared statement, e.g.,
<?php

try {
    $db = new PDO('sqlite::memory:'); // Create an in-memory database.

// Create the table and insert the filenames and corresponding sizes.
$db->beginTransaction();
$db->exec('CREATE TABLE Files ("name" TEXT, "size" INTEGER)');
$stmt = $db->prepare('INSERT INTO Files VALUES (:name, :size)');
foreach (glob('*.wav') as $filename) {
    $stmt->bindValue(':name', $filename, PDO::PARAM_STR);
    $stmt->bindValue(':size', filesize($filename), PDO::PARAM_INT);
    $stmt->execute();
}
$db->commit();

// Retrieve the filenames and sizes sorted in ascending order by size.
$stmt = $db->query('SELECT "name", "size" FROM Files ORDER BY "size"');
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // Print $row['name'] and $row['size']
    // ...
}

$db = NULL; // Close the database connection.
} catch (PDOException $e) {
    die('Error: Could not create in-memory database.');
}
It is quite clear that this is more complicated than just using two loops, an associative array, and asort().

Again, thank you.🙂 I'm not familiare with all the code above, but it looks very tidy and structured.🙂 I'll look it up on php.net