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:karl@xxxxxxxxxxxxxxx <javascript:;>]
> Sent: Wednesday, July 25, 2012 7:18 PM
> To: php-db@xxxxxxxxxxxxx
> Subject: Re: 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:karl@xxxxxxxxxxxxxxx]
> > Sent: Wednesday, July 25, 2012 7:05 PM
> > To: php-db@xxxxxxxxxxxxx
> > Subject: 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())
> >>
> >> {
> >>
> >>
