Re: 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