RE: Stuck trying to upload and grab file name

["Brad" <nyctelecomm@xxxxxxxxx>]

Here is where everything stands..   L

 

http://pastie.org/4317155

 

 

From: Roberto Carlos Garcia Luis [mailto:legnakarlos@xxxxxxxxx] 
Sent: Tuesday, July 24, 2012 5:23 AM
To: Brad
Cc: php-db@xxxxxxxxxxxxx
Subject: Re:  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@xxxxxxxxx
<javascript:_e(%7b%7d,%20'cvml',%20'legnakarlos@xxxxxxxxx');> ] 
Sent: Tuesday, July 24, 2012 5:12 AM
To: Brad
Cc: php-db@xxxxxxxxxxxxx
<javascript:_e(%7b%7d,%20'cvml',%20'php-db@xxxxxxxxxxxxx');> 
Subject: Re:  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@xxxxxxxxx] 
Sent: Tuesday, July 24, 2012 4:26 AM
To: Brad
Cc: php-db@xxxxxxxxxxxxx
Subject: Re:  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());