Posted by G0ng on 11/10/05 10:03
Frank [GOD] wrote:
> Save the data you want imported as CSV... then use mysqlimport from the
> command line or in your PHP code!!
> Another problem solved by GOD...
>
> Frank
>
I'm using this in my website with no problem. I think it's the best (or
only?) solution cause you can also manipulate the data....
e.g $fp is the csv file
$tmp=fgets($fp);
while(!feof($fp)) {
$tmp=fgets($fp);
$t=explode(";",$tmp);
$val=str_replace("\"","",$t);
$val=str_replace("\\","",$val);
insert into....
[Back to original message]
|