fopen reverse/limit order

[rayzun]

hello
any help would useful

I have a log which is CSV file
to display it Im using the script below, which works fine

how would it be possible to reverse the order.. or start with the last line being first. plus limit the results to the last 10 lines only ?

$row = 1;
$handle = fopen("/58.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);

echo "<tr><td>call $row</td>";
$row++;

echo "<td>" . $data[1] . "</td><td>" . $data[3] . "</td><td>" . $data[7] . "</td><td>" . $data[8] . "</td><td>" . $data[9] . "</td><td>" . $data[10] . "</td><td>" . $data[11] . "</td><td>" . $data[12] . "</td><td>" . $data[13] . "</td><td>" . $data[14] . " ";

}
fclose($handle);

[toplay]

Try something like this:

$max_recs = 10;  // Number of rows to display
$recs = array();
$handle = fopen("/58.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

$cnt = array_push($recs, $data); // Add one to end of array

if ($cnt > $max_recs) // More than the max?
    array_shift($recs); // remove first entry in array

}
fclose($handle);

$recs = array_reverse($recs);  // Reverse the order of array
echo '<table>';
for ($i=0, $num = count($recs); $i < $num; $i++) {

echo '<tr><td>call ', $i + 1, '</td>';

echo '<td>', implode('</td><td>', $recs[$i]), '</td></tr>';

}
echo '</table>';

[rayzun]

wow thanks 'toplay'

except your version scraps all that is accomplished in my initial script...

  the ability to format the results to exclude certain fields

do you have a work around for this??

[toplay]

Well, it's easy. Just don't use this:

echo '<td>', implode('</td><td>', $recs[$i]), '</td></tr>';

and use your echo:

$data = $recs[$i]; // Just add this before your echo

echo "<td>" . $data[1] . "</td><td>" . $data[3] . "</td><td>" . $data[7] . "</td><td>" . $data[8] . "</td><td>" . $data[9] . "</td><td>" . $data[10] . "</td><td>" . $data[11] . "</td><td>" . $data[12] . "</td><td>" . $data[13] . "</td><td>" . $data[14] . "</td></tr>";

🙂

[rayzun]

thanks man, awesome work

#########

For some reason this script will not work any longer, Im always getting a timeout error.
Ive tried three seperate servers, all which are running
LINUX
Apache version 1.3.33 (Unix)

This script was working, up to a couple weeks ago makes me think of possibly a server update, OS update or similair hase to be the cause.

Maybe " fopen " can be re-written ????

///

$max_recs = 14; // Number of rows to display
$recs = array();
$handle = fopen("/98.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

$cnt = array_push($recs, $data); // Add one to end of array 

if ($cnt > $max_recs) // More than the max? 
    array_shift($recs); // remove first entry in array

}
fclose($handle);

$recs = array_reverse($recs); // Reverse the order of array

for ($i=0, $num = count($recs); $i < $num; $i++) {

echo '<tr><td>call ', $i + 1, '</td>'; 

$data = $recs[$i]; // Just add this before your echo

echo "<td>" . $data[1] . "</td></tr>";
}