Jump to content

CSV sorting by field and view only selected rows


omdawe

Recommended Posts

Hello!

 

I been trying to figure how first read a Google docs CSV (live) to be shown as a custom HTML.

 

The CSV have 50 lines and each line have 15 cells.

 

With a bit searching i figure out to this :

 


<?PHP

$file_handle = fopen("https://docs.google.com/spreadsheet/pub?key=0Aus5xZRHSuhydGpmcXBRN0Z2WXM5Sks3TlgydF92R1E&single=true&gid=3&output=csv", "r");

while (!feof($file_handle) ) {

$line_of_text = fgetcsv($file_handle, 1024);

print "<custom code>" . $line_of_text[0] . $line_of_text[1]. $line_of_text[2] . $line_of_text[3] . $line_of_text[4] . $line_of_text[5] . $line_of_text[6] . $line_of_text[7] . $line_of_text[8] . $line_of_text[9] .$line_of_text[10] . $line_of_text[11] . $line_of_text[12] . $line_of_text[13] . $line_of_text[14] . $line_of_text[15] . "<br>";
}

fclose($file_handle);

?>

 

But what i would need is to view only the row that have the value "(T01S)" in the first cell "A2" or first "$line_of_text[0]" and the header (first line).

 

I was thinking about just to show a "desired_line" would not help me as if i add a line in the middle many pages would show the wrong line.

 

Also is it any easy way to show one full line except the first cell? So i can have a custom code on that field? And also so i do not need every pages code if i add more fields?

 

After many hours of searching i would be very happy for any kind of help!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.