Pipe delimited text file

[rowan_trimmer]

This is not a one off data import. I am trying to read into a mysql database a pipe delimited text file that contains 20 fields. This needs to take place in the early hours of each morning. I am very new to PHP. Does anyone have a php script to do this or maybe point me in the right direction ?

Many thanks in advance.

[raymie]

Do you have phpmyadmin installed, if so just do the task in there the first time and it normally then provides you with the command for later use.

The command you need is similar to

LOAD DATA LOCAL INFILE '/tmp/php4sZc30' REPLACE INTO TABLE table_name 
FIELDS TERMINATED BY '|'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n' 

[raymie]

reply to private message

Hello Ramie,

Thanks veruy much for that. What I am trying to do is import a pipe delimited file into MYSQL as an automatic procudure in the early hours of each day.

The actual syntax that you have supplied I assume I should be able to embed into a php script and run that against the database ?

The text file would have 20 fields in it.

I assume what I could do in the php script is empty the table to start with then run the sql statement from within the php script ?

Thanks again

Yes you just add it into a script and yes you can empty the table first if you want a complete replacement otherwise the example will add into the table replacing duplicate keys when they exist.

the important thing is that is the update is unattended that the data is totally valid or else you could find a problem waiting for you when you check it that morning.

PS. The example is not showing up correctly with PHP highhtlighting the rn part should have slashes before the r and the n

[michael]

Crontab.