That's a little presumptuous don't you think?
I runs without error now but my test data is not in the database?
array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
"/tmp/phpkVycB6" ["error"]=> int(0) ["size"]=> int(61) } } Import of
campaign emails sucessfull into mysql table.
<?php
var_dump($_FILES);
//db connection
require 'dbConnect.php';
//session file
require_once('../auth.php');
function uploadList(){
$file = $_FILES["file"];
//var_dump($_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)";
$midsql = "ALTER TABLE `{$memberID}` ADD {$file}
VARCHAR(60)";
$sql = <<<EOF
LOAD DATA LOCAL INFILE '{$tmp_name}'
INTO TABLE `{$memberID}`
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
'\\''
LINES TERMINATED BY "\\r\\n"
IGNORE 1 LINES
EOF;
//var_dump($sql);
//echo '$sql';
mysql_query($presql);
mysql_query($midsql);
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();
?>
Brad Sumrall
NYCTelecomm.com
212 444-2996
-----Original Message-----
From: lists-php [mailto:[email protected]]
Sent: Wednesday, July 25, 2012 9:35 PM
To: Brad
Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name
Is this supposed to be what you submitted to mysql? I suspect not, as among
things, it includes the returned mysql error.
Sorry, but I don't think you get the basics of debugging code.
I would suggest that you find someone who is willing to give you sample code
and help you **off list** (this level of tutorial really doesn't belong on a
mailing list).
Good luck.
------------ Original Message ------------
> Date: Wednesday, July 25, 2012 09:24:53 PM -0400
> From: Brad <[email protected]>
> To: 'lists-php' <[email protected]>
> Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name
>
> https://gist.github.com/3179723
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(14)
> "emailsTest.txt" ["type"]=> string(10) "text/plain" ["tmp_name"]=>
> string(14) "/tmp/phpepEKoj" ["error"]=> int(0) ["size"]=> int(61) } }
> string(188) " LOAD DATA LOCAL INFILE '/tmp/phpepEKoj' ALTER TABLE `3`
> ADD Array VARCHAR(60); FIELDS TERMINATED BY ','
> OPTIONALLY ENCLOSED BY '\'' LINES TERMINATED BY "\r\n" IGNORE 1 LINES"
> $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
>
> -----Original Message-----
> From: lists-php
> [mailto:[email protected]] Sent:
> Wednesday, July 25, 2012 8:57 PM
> To: Brad
> Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name
>
> No. What you have there is the dump *after* you've passed things to
> mysql -- including the mysql error. Look at what you are passing to
> mysql *before* you actually feed it to mysql.
>
> I suspect you are missing a mysql command terminator (semicolon) or
> two so you are running commands together. E.g., after the "load data"
> command -- but it's mostly impossible to tell without cleaner detail.
>
> Just as a general coding practice issue -- why are you trying to
> string that group of commands into one set that you dump to mysql in a
> single set. It would be much cleaner, and more controllable, to do the
> different mysql commands as separate statements.
>
>
> ------------ Original Message ------------
>> Date: Wednesday, July 25, 2012 08:43:51 PM -0400
>> From: Brad <[email protected]>
>> To: 'lists-php'
>> Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name
>>
>> I believe I was already doing that on line 33?
>> https://gist.github.com/3179584
>>
>>
>> array(1) { ["file"]=> array(5) { ["name"]=> string(14)
>> "emailsTest.txt" ["type"]=> string(10) "text/plain" ["tmp_name"]=>
>> string(14) "/tmp/phpKsDHhS" ["error"]=> int(0) ["size"]=> int(61) } }
>> string(188) " LOAD DATA LOCAL INFILE '/tmp/phpKsDHhS' ALTER TABLE `3`
>> ADD Array VARCHAR(60); FIELDS TERMINATED BY ','
>> OPTIONALLY ENCLOSED BY '\'' LINES TERMINATED BY "\r\n" IGNORE 1
>> LINES" $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
>>
>> Brad
>>
>>
>>
>> -----Original Message-----
>> From: lists-php
>> [mailto:[email protected]] Sent:
>> Wednesday, July 25, 2012 8:31 PM
>> To: Brad
>> Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name
>>
>>>
>>>
>>> ------------ Original Message ------------
>>>> Date: Wednesday, July 25, 2012 07:33:09 PM -0400
>>>> From: Brad <[email protected]>
>>>> Subject: RE: [PHP-DB] 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
>>>>
>>>
>>> Echo the statement out (after the variable substitutions have
>>> taken place), and then work with that at the mysql command
>>> line. You'll likely figure out the issue much faster (it might even
>>> be obvious from what gets displayed).
>>>
>>> - Richard
>>>
>>>
>>> Date: Wednesday, July 25, 2012 08:16:07 PM -0400
>>> From: Brad <[email protected]>
>>>
>>> Unfortunately that has already been done and that exact method is
>>> what got me this far. I can visually confirm that I am calling on
>>> the correct names/variables.
>>>
>>> array(1) { ["file"]=> array(5) { ["name"]=> string(14)
>>> "emailsTest.txt" ["type"]=> string(10) "text/plain"
>>> ["tmp_name"]=> string(14) "/tmp/phpec4hX9" ["error"]=> int(0)
>>> ["size"]=> int(61) } } array(5) { ["name"]=> string(14)
>>> "emailsTest.txt" ["type"]=> string(10) "text/plain"
>>> ["tmp_name"]=> string(14) "/tmp/phpec4hX9" ["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
>>>
>>> Brad
>>>
>>
>> What you're showing isn't what I mean.
>>
>> What I'm suggesting is the actual mysql statement (in this case your
>> ALTER line) so you can see *exactly* what you're passing to mysql.
>> The mysql statement that you echo from your php code should be able
>> to copied/pasted directly to the mysql command prompt. The above
>> dump isn't that.
>>
>>
>>
>> - Richard
>>
>>
>
> ------------ End Original Message ------------
>
------------ End Original Message ------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
