loading data into mysql from txt file from php
| From: | Clif Wieden | Date: | Tue, 03 Jul 2001 21:02:45 +0000 |
| Subject: | loading data into mysql from txt file from php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-56061@lists.php.net to get a copy of this message | ||
I have a project where the admin uploads a new data file and it needs to
be loaded into a mysql database. What's the best way to do this? The
data file is tab-delimted but could be reformatted.
Right now the file is uploaded and after copy($new_file, $file_loc)
would like to refresh the db.
unix box running php4 and mysql 3.22 and of course apache
Thanks in advance,
clif