RE: [PHP-DB] Stuck trying to upload and grab file name
| From: | Brad | Date: | Tue, 24 Jul 2012 09:25:34 +0000 |
| Subject: | RE: [PHP-DB] Stuck trying to upload and grab file name | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48339@lists.php.net to get a copy of this message | ||
array(1) { ["file"]=> array(5) { ["name"]=> string(14)
"emailsTest.txt"
["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
"/tmp/php8Tx8es" ["error"]=> int(0) ["size"]=> int(61) } }
$sqlYou have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ''\' LINES TERMINATED BY
"\r\n" IGNORE 1 LINES' at line 3
Brad
From: Roberto Carlos Garcia Luis [mailto:legnakarlos@gmail.com]
Sent: Tuesday, July 24, 2012 5:23 AM
To: Brad
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name
Use
$_FILES["file"]["tmp_name"]
El martes, 24 de julio de 2012, Brad escribió:
<?php
var_dump($_FILES);
//db connection
require 'dbConnect.php';
//session file
require_once('../auth.php');
function uploadList(){
//var_dump($_FILES['file']);
if ($_FILES["file"]["type"] == "text/plain")
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " .
$_FILES['file']['error'] ..
"<br />";
}
else
{
dbConnect();
mysql_select_db('mailList') or die(mysql_error());
//$file=''
$file = $_FILES['tmp_name'];
//$presql = "CREATE TABLE IF NOT EXISTS
(
$_SESSION[SESS_MEMBER_ID]_$file)";
$presql = "CREATE TABLE IF NOT EXISTS
$_SESSION[SESS_MEMBER_ID]_$file";
$sql = <<<EOF
LOAD DATA LOCAL INFILE '{$_FILES['tmp_name']}'
INTO TABLE $_SESSION[SESS_MEMBER_ID]_$file
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
LINES TERMINATED BY "\\r\\n <file:///\\r\n> "
IGNORE 1 LINES
EOF;
mysql_query($presql);
mysql_query($sql);
//var_dump($sql);
echo '$sql';
if(mysql_error())
{
echo(mysql_error());
}
else
{
print('Import of campaign emails sucessfull
into mysql table.');
}
}
}
else
{
print('Invalid file type. Please make sure it is a text
file.');
}
}
//var_dump($_FILES);
uploadList();
?>
array(1) { ["file"]=> array(5) { ["name"]=> string(14)
"emailsTest.txt"
["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
"/tmp/phpq8pi44" ["error"]=> int(0) ["size"]=> int(61) } }
Notice: Undefined index: tmp_name in
/home/nyctelecomm.com/www/mail/import.php on line 20
Notice: Undefined index: tmp_name in
/home/nyctelecomm.com/www/mail/import.php on line 24
$sqlYou have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ''\' LINES
TERMINATED BY "\r\n" IGNORE 1 LINES' at line 3
From: Roberto Carlos Garcia Luis [mailto:legnakarlos@gmail.com
<javascript:_e(%7b%7d,%20'cvml',%20'legnakarlos@gmail.com');> ]
Sent: Tuesday, July 24, 2012 5:12 AM
To: Brad
Cc: php-db@lists.php.net
<javascript:_e(%7b%7d,%20'cvml',%20'php-db@lists.php.net');>
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name
In the
LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
You need use The tmp_name to load The file contents.
And The SQL var result as a string diferent of The SQL that you insert in
console
El martes, 24 de julio de 2012, Brad escribió:
The tmp_file is just gibberish. I truly do not want that as the table
name.
From: Roberto Carlos Garcia Luis [mailto:legnakarlos@gmail.com]
Sent: Tuesday, July 24, 2012 4:26 AM
To: Brad
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name
You need to use te tmp_name ... The plain text file is in path indicated by
The string...
Regards,
El martes, 24 de julio de 2012, Brad escribió:
I am making a function that uploads a txt file in csv format and the grabs
uploaded file name and the memberID from the sessions login and names the
new table memberID_filename.
The program error on line 24 @ 'name'.
I have tried '{$_FILES[file][name]}' '{$_FILES[file]['name']}'
'{$_FILES['file']['name']}' {$_FILES[file][name]}
{$_FILES['file']['name']}
$_FILES[file][name] $_FILES[file]['name'] $_FILES['file']['name']
'$_FILES[file][name]' '$_FILES['file']['name']' and
'$_FILES[0]['name']'
********************************code*************************
<?php
var_dump($_FILES);
//db connection
require 'dbConnect.php';
//session file
require_once('../auth.php');
function uploadList(){
//var_dump($_FILES);
if ($_FILES["file"]["type"] == "text/plain")
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " .
$_FILES['file']['error'] ..
"<br />";
}
else
{
dbConnect();
mysql_select_db('mailList') or die(mysql_error());
//$file=''
$file = $_FILES['file']['name'];
//$presql = "CREATE TABLE IF NOT EXISTS
($_SESSION[SESS_MEMBER_ID]_$file)";
$presql = "CREATE TABLE IF NOT EXISTS
$_SESSION[SESS_MEMBER_ID]_$file";
$sql = <<<EOF
LOAD DATA LOCAL INFILE
'{$_FILES['file']['name']}'
INTO TABLE $_SESSION[SESS_MEMBER_ID]_$file
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
LINES TERMINATED BY "\\r\\n <file:///\\r\n> "
IGNORE 1 LINES
EOF;
mysql_query($presql);
mysql_query($sql);
var_dump($sql);
echo '$sql';
if(mysql_error())
{
echo(mysql_error());