Click here to get back home

How to read CSV and update Mysql
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.php    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
How to read CSV and update Mysql Steve 07-18-2008
Get Chitika Premium
Posted by Steve on July 18, 2008, 12:04 pm
Please log in for more thread options
 I have a csv file - That I get nightly.

Can someone point me to an example of a script that reads the CSV and
updates a Mysql db.

I have to grab the CSV at runtime by following a static URL.


Thanks
Steve

Posted by macca on July 18, 2008, 12:52 pm
Please log in for more thread options
 There are loads of examples on php.net here:

http://uk2.php.net/manual/en/function.fgetcsv.php


And there is a ready made class here:

http://a4.users.phpclasses.org/browse/package/2917.html

Posted by Paul Lautman on July 18, 2008, 3:23 pm
Please log in for more thread options
Steve wrote:
>I have a csv file - That I get nightly.
>
> Can someone point me to an example of a script that reads the CSV and
> updates a Mysql db.
>
> I have to grab the CSV at runtime by following a static URL.
>
>
> Thanks
> Steve

http://dev.mysql.com/doc/refman/5.0/en/load-data.html



Similar ThreadsPosted
using UPDATE in MySQL April 22, 2006, 1:59 pm
PHP MySql Update November 20, 2006, 8:47 pm
Mysql update? help required. March 27, 2005, 6:21 am
mysql update and checkboxes June 24, 2006, 9:12 pm
PHP/MySQL UPDATE problem February 16, 2007, 11:33 pm
Form Will Not Update MySQL DB August 11, 2007, 8:09 pm
mysql update/replace syntax August 29, 2004, 5:48 am
Mysql Multiple Update in a PHP Web Page May 6, 2005, 10:56 am
The prefered way to update a database, (MySQL) June 9, 2005, 6:11 pm
HTML table Update row PHP/MySQL January 24, 2007, 11:56 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap