chia4

So i have this <?php $url = "https://docs.google.com/spreadsheets/d/1gn8ZBepUSKbS9JlP7nRdL2StARH6d88QbA89EJgYRCQ/pub?gid=968704782&single=true&output=csv"; $row=0; if (($handle = fopen($url, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); echo "<p> $num fields in line $row: <br /></p>\n"; $row++; for ($c=0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; } } fclose($handle); } However i need it to search Column B using the "Search Function" so basically someone inputs their name that is in column b. And return column D & E in that row only

Basically I have some info such as a person's name, a ID#, and a time. All this info is going to be in a google spreadsheet i plan to have it connect with php and it reads it as a csv file. I want someone to put there ID# in a search form and it return the time matching there ID# any1 have any help for this? i know how to strictly make a search form, but never one reading off csv data. Thanks any help is appreciated. If any1 knows any other way to achieve what im asking for, keeping in mind it must originate from a google sheet, that would help aswell. Thanks!