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"
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();
?>
**********************************error*************************
array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
"/tmp/phpmycbhK" ["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
SQL query works when removed from the php
mysql> LOAD DATA LOCAL INFILE '/home/nyctelecomm.com/www/mail/emailtist.txt'
-> INTO TABLE `mailTest`
-> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
-> LINES TERMINATED BY "\\r\\n"
-> IGNORE 1 LINES;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
*******************show create*********************
mysql> SHOW CREATE TABLE mailTest\G
*************************** 1. row ***************************
Table: mailTest
Create Table: CREATE TABLE `mailTest` (
`temp` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
*****************sample data*********************
k2jthepoet@xxxxxxxxxxx
annamague@xxxxxxxxx
ken_casper@xxxxxxxxx
jmakselan@xxxxxxxxx
janegrey42@xxxxxxxxxxx
mitchamhr@xxxxxxxxx
klj184@xxxxxxxxxxx
var_dump($_FILES["file"]) at line 8
array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
"/tmp/php98AolN" ["error"]=> int(0) ["size"]=> int(61) } } array(5) {
["name"]=> string(14) "emailsTest.txt" ["type"]=> string(10) "text/plain"
["tmp_name"]=> string(14) "/tmp/php98AolN" ["error"]=> int(0) ["size"]=>
int(61) }
