RE: Re: Stuck trying to upload and grab file name

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:[email protected]] 
Sent: Wednesday, July 25, 2012 7:18 PM
To: [email protected]
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:[email protected]]
> Sent: Wednesday, July 25, 2012 7:05 PM
> To: [email protected]
> 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())
>>
>>                               {
>>
>>                               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/phpBKCv3n" ["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 'ALTER 
>> TABLE `3` ADD Array VARCHAR(60); FIELDS TERMINATED BY ',' OPTIONALLY 
>> EN' at line 2
>>
>>
>>
>> ********************proof it's supposed to work****************
>>
>>
>>
>>
>>
>> mysql> CREATE TABLE IF NOT EXISTS `215` (id MEDIUMINT AUTO_INCREMENT
>> PRIMARY
>> KEY UNIQUE);
>>
>> Query OK, 0 rows affected (0.00 sec)
>>
>>
>>
>> mysql> ALTER TABLE `215` ADD emailList VARCHAR(40);
>>
>> Query OK, 0 rows affected (0.00 sec)
>>
>> Records: 0  Duplicates: 0  Warnings: 0
>>
>>
>>
>
>
> Just currious and for my own edification.
> Why are you trying to store the temp name in your database?
> You should move and rename the file and then store that name in your 
> database.
> If I understand temp_name, that name dissapears after done processing.
>
> Am I correct everyone?
>
> Shouldn't he move the file first and rename then store?
>
> and do you store the path in the database or just the name?
> Because the temp_name var has directory slashes in it and if those are 
> not escaped it wont work.
>
> 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
>
>
> --
> PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: 
> http://www.php.net/unsub.php
>


Try using that to store in the database and dont use it for the column name.
use `mail_file` or something like that for the column name.

Karl DeSaulniers
Design Drumm
http://designdrumm.com


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


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