Re: Stuck trying to upload and grab file name

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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<javascript:_e({}, 'cvml', 'legnakarlos@xxxxxxxxx');>]
>
> *Sent:* Tuesday, July 24, 2012 4:26 AM
> *To:* Brad
> *Cc:* php-db@xxxxxxxxxxxxx <javascript:_e({}, 'cvml',
> '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"
>
>                         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
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux