Flat File Database Sorted By '.$header.'

To sort the columns click on the headers.

View the database or the PHP code used.
 

'; $fp = fopen('flat-file-data2.txt','r'); if (!$fp) {echo 'ERROR: Unable to open file.
First Name Surname City Points Car Colour Age
'; exit;} $row = 0; while (!feof($fp)) { $row++; $line = fgets($fp,1024); //use 2048 if very long lines $field[$row] = explode('|', $line); if ($sortby == 'firstname') {$sortkey = strtolower($field[$row][0]);} //firstname if ($sortby == 'surname') {$sortkey = strtolower($field[$row][1]);} //surname if ($sortby == 'city') {$sortkey = strtolower($field[$row][2]);} //city if ($sortby == 'points') {$sortkey = $field[$row][3];} //points if ($sortby == 'car') {$sortkey = strtolower($field[$row][4]);} //car if ($sortby == 'colour') {$sortkey = strtolower($field[$row][5]);} //colour if ($sortby == 'age') {$sortkey = $field[$row][6];} //age array_unshift($field[$row], $sortkey); //add sortkey to start of array } fclose($fp); sort($field); reset($field); $arrays = count($field) - 1; $loop = -1; while ($loop < $arrays) { $loop++; echo ' '.$field[$loop][1].' '.$field[$loop][2].' '.$field[$loop][3].' '.$field[$loop][4].' '.$field[$loop][5].' '.$field[$loop][6].' '.$field[$loop][7].' '; } echo '

1 December 2004 · Last updated: '.date('j F Y', getlastmod()); ?> · A Design Detector production · About The Demo · Comments