Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Tamara Temple
Brad nyctelec...@gmail.com wrote:
 Here is where everything stands..   L
 
 http://pastie.org/4317155

I feel strange bottom posting, somehow, BUT THAT'S THE RULE

You have never actually shown what your SQL statement is, because:

line 33: echo '$sql';

This will NOT interpolate the sql string. This is why you keep getting:

line 57: array(1) { [file]= array(5) { [name]= string(14) 
emailsTest.txt [type]= string(10) text/plain [tmp_name]= string(14) 
/tmp/phpcLtE6W [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

See where it says $sqlYou have after your vardump of $_FILES?

Change:
Line 33 to:
echo $sql.PHP_EOL;

then give it a go.

(The actual source of your problem is elsewhere, but I'll let you go
from there.)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Matijn Woudt
On Wed, Jul 25, 2012 at 12:21 PM, Tamara Temple
tamouse.li...@tamaratemple.com wrote:
 Brad nyctelec...@gmail.com wrote:
 Here is where everything stands..   L

 http://pastie.org/4317155

 I feel strange bottom posting, somehow, BUT THAT'S THE RULE

It makes each individual message readable in a human readable order. That's why.



 You have never actually shown what your SQL statement is, because:

 line 33: echo '$sql';

 This will NOT interpolate the sql string. This is why you keep getting:

 line 57: array(1) { [file]= array(5) { [name]= string(14) 
 emailsTest.txt [type]= string(10) text/plain [tmp_name]= string(14) 
 /tmp/phpcLtE6W [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

 See where it says $sqlYou have after your vardump of $_FILES?

 Change:
 Line 33 to:
 echo $sql.PHP_EOL;

 then give it a go.

A quick guess, you probably need double escapes at OPTIONALLY ENCLOSED
BY '\\', like OPTIONALLY ENCLOSED BY ''

- Matijn

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Karl DeSaulniers

On Jul 25, 2012, at 5:21 AM, Tamara Temple wrote:


Brad nyctelec...@gmail.com wrote:

Here is where everything stands..   L

http://pastie.org/4317155


I feel strange bottom posting, somehow, BUT THAT'S THE RULE

You have never actually shown what your SQL statement is, because:

line 33: echo '$sql';

This will NOT interpolate the sql string. This is why you keep  
getting:


line 57: array(1) { [file]= array(5) { [name]= string(14)  
emailsTest.txt [type]= string(10) text/plain [tmp_name]=  
string(14) /tmp/phpcLtE6W [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


See where it says $sqlYou have after your vardump of $_FILES?

Change:
Line 33 to:
   echo $sql.PHP_EOL;

then give it a go.

(The actual source of your problem is elsewhere, but I'll let you go
from there.)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




$sql = BLAH BLAH BLAH var='.mysql_real_escape_string($var).' LINES  
TERMINATED BY '\r\n' IGNORE 1 LINES;


Strings for SQL are wrapped in single quotes and dont escape your  
single quotes, the php $sql string is wrapped in double quotes.


HTH,

Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Roberto Carlos Garcia Luis
The table ñame need The ñame var not tmp_name tmp_name contains / bar



El miércoles, 25 de julio de 2012, Brad escribió:

 Switching it to - ALTER TABLE `{$memberID}` ADD {$tmp_name} VARCHAR(60);
 produces the same error.
 For the record $tmp_name is just gibberish and should not be the final
 column name.

 Brad

 -Original Message-
 From: Karl DeSaulniers [mailto:k...@designdrumm.com javascript:;]
 Sent: Wednesday, July 25, 2012 7:18 PM
 To: php-db@lists.php.net
 Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name

 On Jul 25, 2012, at 6:11 PM, Brad wrote:

  I am only uploading the temporary file. The filename is acquired via
  - $file = $_FILES[file]; and that is what is included in the naming
  of the column.
 
 
 
  -Original Message-
  From: Karl DeSaulniers [mailto:k...@designdrumm.com]
  Sent: Wednesday, July 25, 2012 7:05 PM
  To: php-db@lists.php.net
  Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name
 
  On Jul 25, 2012, at 5:49 PM, Brad wrote:
 
  I revamped my logic, proved the SQL works in a client the way I want
  and once again, I am hitting the same mysql brick wall.
 
 
 
  ?php
 
  var_dump($_FILES);
 
  //db connection
 
  require 'dbConnect.php';
 
  //session file
 
  require_once('../auth.php');
 
  function uploadList(){
 
$file = $_FILES[file];
 
$memberID = $_SESSION[SESS_MEMBER_ID];
 
if ($file[type] == text/plain)
 
{
 
if ($file[error]  0)
 
{
 
echo Return Code:  . $file['error'] . br /
  ;
 
}
 
else
 
{
 
dbConnect();
 
mysql_select_db('mailList') or
  die(mysql_error());
 
$tmp_name =  $file[tmp_name];
 
$presql = CREATE TABLE IF NOT EXISTS
  `{$memberID}` (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY UNIQUE);
 
$sql = EOF
 
LOAD DATA LOCAL INFILE '{$tmp_name}'
 
ALTER TABLE `{$memberID}` ADD {$file}
  VARCHAR(60);
 
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())
 
{
 
 


RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Brad
I am not sure I am following you sir. Can you send me a sample?

$tmp_name is incorrect and should only be used for the upload.

On a whim I tried - ALTER TABLE `{$memberID}` ADD tmp_name VARCHAR(60);
making it static and it still errored the same.

 

Brad

 

 

From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com] 
Sent: Wednesday, July 25, 2012 8:17 PM
To: Brad
Cc: Karl DeSaulniers; php-db@lists.php.net
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name

 

The table ñame need The ñame var not tmp_name tmp_name contains / bar

 



El miércoles, 25 de julio de 2012, Brad escribió:

Switching it to - ALTER TABLE `{$memberID}` ADD {$tmp_name} VARCHAR(60);
produces the same error.
For the record $tmp_name is just gibberish and should not be the final
column name.

Brad

-Original Message-
From: Karl DeSaulniers [mailto:k...@designdrumm.com javascript:; ]
Sent: Wednesday, July 25, 2012 7:18 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name

On Jul 25, 2012, at 6:11 PM, Brad wrote:

 I am only uploading the temporary file. The filename is acquired via
 - $file = $_FILES[file]; and that is what is included in the naming
 of the column.



 -Original Message-
 From: Karl DeSaulniers [mailto:k...@designdrumm.com]
 Sent: Wednesday, July 25, 2012 7:05 PM
 To: php-db@lists.php.net
 Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name

 On Jul 25, 2012, at 5:49 PM, Brad wrote:

 I revamped my logic, proved the SQL works in a client the way I want
 and once again, I am hitting the same mysql brick wall.



 ?php

 var_dump($_FILES);

 //db connection

 require 'dbConnect.php';

 //session file

 require_once('../auth.php');

 function uploadList(){

   $file = $_FILES[file];

   $memberID = $_SESSION[SESS_MEMBER_ID];

   if ($file[type] == text/plain)

   {

   if ($file[error]  0)

   {

   echo Return Code:  . $file['error'] . br /
 ;

   }

   else

   {

   dbConnect();

   mysql_select_db('mailList') or
 die(mysql_error());

   $tmp_name =  $file[tmp_name];

   $presql = CREATE TABLE IF NOT EXISTS
 `{$memberID}` (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY UNIQUE);

   $sql = EOF

   LOAD DATA LOCAL INFILE '{$tmp_name}'

   ALTER TABLE `{$memberID}` ADD {$file}
 VARCHAR(60);

   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())

   {

 



Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
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

 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*





 k2jthep...@hotmail.com javascript:;

 annama...@gmail.com javascript:;

 ken_cas...@yahoo.com javascript:;

 jmakse...@gmail.com javascript:;

 janegre...@hotmail.com javascript:;

 mitcha...@yahoo.com javascript:;

 klj...@hotmail.com javascript:;



 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) }








Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
Pelase, print The SQL var and show here The result.


El martes, 24 de julio de 2012, Roberto Carlos Garcia Luis escribió:

 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

 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

 Cre




RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
The tmp_file is just gibberish.  I ‘truly’ do not want that as the table
name.

 

 

 

 

From: Roberto Carlos Garcia Luis [mailto:legnakar...@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());

}

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 file:///\\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*





k2jthep...@hotmail.com javascript:; 

annama...@gmail.com javascript:; 

ken_cas...@yahoo.com javascript:; 

jmakse...@gmail.com javascript:; 

janegre...@hotmail.com javascript:; 

mitcha...@yahoo.com javascript:; 

klj...@hotmail.com javascript:; 



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) }








RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
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) }

 

 

 

 

From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com] 
Sent: Tuesday, July 24, 2012 4:30 AM
To: Brad
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name

 

Pelase, print The SQL var and show here The result.



El martes, 24 de julio de 2012, Roberto Carlos Garcia Luis escribió:

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());

}

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 file:///\\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

Cre



Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
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:legnakar...@gmail.comjavascript:_e({}, 'cvml', 
 'legnakar...@gmail.com');]

 *Sent:* Tuesday, July 24, 2012 4:26 AM
 *To:* Brad
 *Cc:* php-db@lists.php.net javascript:_e({}, 'cvml',
 '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

 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 CREA



RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
?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

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:legnakar...@gmail.com] 
Sent: Tuesday, July 24, 2012 5:12 AM
To: Brad
Cc: 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:legnakar...@gmail.com
javascript:_e(%7b%7d,%20'cvml',%20'legnakar...@gmail.com'); ] 
Sent: Tuesday, July 24, 2012 4:26 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

 

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

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
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

 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:legnakar...@gmail.comjavascript:_e({}, 'cvml', 
 'legnakar...@gmail.com');]

 *Sent:* Tuesday, July 24, 2012 5:12 AM
 *To:* Brad
 *Cc:* php-db@lists.php.net javascript:_e({}, 'cvml',
 '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:legnakar...@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

RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
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:legnakar...@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:legnakar...@gmail.com
javascript:_e(%7b%7d,%20'cvml',%20'legnakar...@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:legnakar...@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

RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
Here is where everything stands..   L

 

http://pastie.org/4317155

 

 

From: Roberto Carlos Garcia Luis [mailto:legnakar...@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:legnakar...@gmail.com
javascript:_e(%7b%7d,%20'cvml',%20'legnakar...@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:legnakar...@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