Re: 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"
> >>
> >>                       IGNORE 1 LINES
> >>
> >> EOF;
> >>
> >>                       mysql_query($presql);
> >>
> >>                       mysql_query($sql);
> >>
> >>                       //var_dump($sql);
> >>
> >>                       echo '$sql';
> >>
> >>                       if(mysql_error())
> >>
> >>                               {
> >>
> >>