Generalised script for loading tab file into MySQL table?

[AndyatIES]

I need a generalised script to refresh MySQL tables from a PHP page, ie:

1) Delete all records from a named MySQL table
2) Read in records from a named tab-separated file
3) Confirm Table update OK
(and presumably be repeatable to update a series of tables in one go, from a series of tab files.)

Anyone have one? You'd make my day!

 

[Valcor]

1)

  $sql = mysql_query(&quot;delete from <table name>&quot;);

You may want to check feedback on that to make sure that worked, ie that $sql isn't null.

2)

  $sql = mysql_query(&quot;load data local infile \&quot;<file>\&quot; into \&quot;<table>\&quot;&quot;);

This reads a tab delimited file, and reads line-feeds as new records. Again, you may want to check the feedback, and make sure that it worked.

3) Rinse, repeat as necessary. As with checking the values, I think you can probably do a check to make sure they're not empty, if they are not empty, count the number of rows.

--
Jon