RE: [PHP-DB] CSV/TXT file imported via PHP into MySQL
| From: | Beau Lebens | Date: | Tue, 11 Jun 2002 01:05:47 +0000 |
| Subject: | RE: [PHP-DB] CSV/TXT file imported via PHP into MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19726@lists.php.net to get a copy of this message | ||
Keiran,
in your second page, you refer to $textfile as the thing that you want to
load into the database; this file doesn't exist on the server, so it is
inserting nothing I would imagine.
You need to use something like $_FILES['tmp_name'] to refer to the actual
file, once it has been successfully uploaded to your server
(http://www.php.net/manual/en/features.file-upload.php#features.file-upload.
post-method)
HTH
Beau
// -----Original Message-----
// From: Keiran Wynyard [mailto:keiran@wynyard.net]
// Sent: Tuesday, 11 June 2002 12:38 AM
// To: php-db@lists.php.net
// Subject: [PHP-DB] CSV/TXT file imported via PHP into MySQL
//
//
// I have a form on a PHP page with which I wish to load a tab
// delimited text file into a
// UNIX based MySQL database
//
// By using PHPMyAdmin I have tested whether I can upload the
// file, using MyAdmin to help me
// construct the Query and to date in MyAdmin it works fine.
// Taking the query and splitting
// it across two pages (one for receiving the file, and to
// action the query) seems to stop it
// from working.
//
// I have detailed the pertinent aspects below.
// My question is really to do with whether there is a file
// permissions setting or
// requirement that I have to be aware of, or if there is
// merely something else I can do.
//
// Form code:
// echo "<form method=\"post\" action=\"$PHP_SELF?command=create\"
// enctype=\"multipart/form-data\">";
// echo "\n<table width=\"300\"><tr><td><input
type=\"file\"
// name=\"textfile\"></td>";
// echo "\n\n<td width=\"50\"><input type=\"submit\"
// name=\"submit\" value=\"Load
// File\"></td></tr></table></form>";
//
// Query section:
// switch ($command)
// {
// case 'create':
// echo "<br>$textfile"; \\merely existing to run checks
// $query = "LOAD DATA LOCAL INFILE '" . $textfile
// . "' INTO TABLE
// pebble_email_addresses FIELDS TERMINATED BY '\t' LINES
// TERMINATED BY '\r\n' (firstname,
// surname, email) ";
// echo "<br>$query"; \\merely existing to run checks
// $sql_query_result = @mysql_query($query, $sql_userdb);
// if ($sql_query_result and @mysql_affected_rows() > 0)
// {
// //Worked OK
// echo "<br>it worked";
// }
// else
// {
// echo "<br>it didn't";
// break;
//
// I have yet to get the damn query to import anything at all! HELP
//
// Thanks in Advance!
//
// Keiran
//
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//