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;} while (!feof($fp)) { $line = fgets($fp,1024); //use 2048 if very long lines $row++; list ($firstname, $surname, $city, $points, $car, $colour, $age) = split ('\|', $line); if ($sortby == 'firstname') $sortkey = strtolower($firstname); if ($sortby == 'surname') $sortkey = strtolower($surname); if ($sortby == 'city') $sortkey = strtolower($city); if ($sortby == 'points') $sortkey = $points; if ($sortby == 'car') $sortkey = strtolower($car); if ($sortby == 'colour') $sortkey = strtolower($colour); if ($sortby == 'age') $sortkey = $age; $col[$row] = array($sortkey, $firstname, $surname, $city, $points, $car, $colour, $age); } fclose($fp); sort($col); reset ($col); $arrays = count($col) - 1; $loop = -1; while ($loop < $arrays) { $loop++; echo ' '.$col[$loop][1].' '.$col[$loop][2].' '.$col[$loop][3].' '.$col[$loop][4].' '.$col[$loop][5].' '.$col[$loop][6].' '.$col[$loop][7].' '; } echo '

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