RE: Stuck trying to upload and grab file name

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:[email protected]] 
Sent: Wednesday, July 25, 2012 8:17 PM
To: Brad
Cc: Karl DeSaulniers; [email protected]
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:[email protected] <javascript:;> ]
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 <file:///\\r\n> "
>>
>>                       IGNORE 1 LINES
>>
>> EOF;
>>
>>                       mysql_query($presql);
>>
>>                       mysql_query($sql);
>>
>>                       //var_dump($sql);
>>
>>                       echo '$sql';
>>
>>                       if(mysql_error())
>>
>>                               {
>>
>>