Uploading a file into a database....ideas please.
| From: | Sam | Date: | Wed, 20 Jun 2001 09:05:58 +0000 |
| Subject: | Uploading a file into a database....ideas please. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54487@lists.php.net to get a copy of this message | ||
Hi all,
I have several text files that need to be uploaded each week to a mySQL db.
At the moment I'm deleting the tables via telnet then exporting them via
ODBC.
I have tried uploading in the following ways.
1. Using the copy command, but there are insufficient privileges on the
server (security reasons).
2. FTPing the text files in the php script but the version of PHP doesn't
allow this. (Updating it not an option).
3. Opening the file remotely (but the file is on my local pc).
I'm stuck myself,
please help.
Thanks in advance.
Sam Rose
(Also could you reply to my email address as I don't seem to get anymore
emails from the list come through)