Re: Array within array
| From: | Ben Litton | Date: | Fri, 30 Sep 2005 13:34:03 +0000 |
| Subject: | Re: Array within array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223467@lists.php.net to get a copy of this message | ||
I would do something like
$fp = fopen($file_location, 'r');
while (!$fp) {
$csv_line = fgetcsv($fp);
//insert line into database here after appropriate validation and cleaning
}
On Fri, 30 Sep 2005 06:29:11 -0400, Chris <chris@pixcel.co.za> wrote:
Greetings PHP community, I have a CSV text file which I need to use to update existing DB records. So I have the following : $array_file = file("path/to/file"); file() creates an array comprising each line of the file, but if each line contains 20 or so CS values, how do I go about reading each line and updating the db. Pseudo code : ===== $array_file = file("path/to/file"); while (explode(',',$file_array)) { do update on db for each line of array } ===== Any pointers ? -- Chris Blake Cell: 082 775 1492 Work: +27 11 880 2825 Fax : +27 11 782 0841 Mail: chris@pixcel.co.za Immortality -- a fate worse than death. -- Edgar A. Shoaff-- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/