a script that can search a csv file

im having trouble writing a script that where u can fill in a search box to search a .csv file .. a customer can enter their customer number and based on that number they find their delivery time which has already been uploaded to the database.. any ideas?

[Join us @ facebook]

Load the csv file in an array, and use the in_array() function

so i should open file then use in array on the file and then close file? im slightly confused

[Join us @ facebook]

First load the file ( file_get_contents() )

Then create an array using the file ( explode() )

Then search the array for the customer number ( in_array )

ok so i would use something like this on the actual page where they use the search box, or in a separate script file?

Code:

<?php file_get_contents('db.csv');
explode('db.csv');
in_array;
?>

lol im sure that wont work cuz i dono what im doin with php unless im editing it lol

[Join us @ facebook]

I think that you should check some tutorials on php....

Then you can check those :

http://www.phpclasses.org/browse/package/1358.html
http://www.phpclasses.org/browse/package/2124.html

ok i have search.php file and heres code i have so far

Code:

<?php
echo file_get_contents('db.csv');
echo explode('db.csv');
echo in_array;

?>

then i have the search form with action as search.php and i get this error when i execute it


Warning: Wrong parameter count for explode() in /hsphere/local/home/meth0d42/meth0d.justinlove.net/search.php on line 3
in_array

[Join us @ facebook]

Read a little about those functions in the php manual before implementing this.

http://php.net/file_get_contents

http://php.net/explode

http://php.net/in_array

heres what i got now

Code:

<?php
$data = file_get_contents('db.csv');
$results = explode($data);
$array = array("Customer #","Delivery Time");
if (in_array('customer_#', $array)) {
   echo $results;
}
if (in_array('time', $array)) {
   echo $results;
}

?>

Warning: Wrong parameter count for explode() in /hsphere/local/home/meth0d42/meth0d.justinlove.net/search.php on line 3

[Join us @ facebook]

explode ( string separator, string string )

That means that you have to provide explode with a string that will split the file

hmm im not sure what you mean exactly

[Join us @ facebook]

Look man propably you should buy a book for PhP and start over with the basic stuff.

I don't want to dissapoint you, but it is very difficult to learn a scripting language (especially one like php or perl) through a forum.

[Guest]

[37.988]

Googlebot, Yahoo crawler, Msnbot, Baidu Spider