RE: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
p/phpKeJFI0' INTO TABLE `3` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\'' LINES TERMINATED BY "\r\n" IGNORE 1 LINES" $sqlstring(165) " LOAD DATA LOCAL INFILE '/tmp/phpKeJFI0' INTO TABLE `3` FIELDS TERMINATED BY ','

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Karl DeSaulniers
ampaign emails sucessfull into mysql table.'); } } } else { print('Invalid file type. Please make sure it is a text file.'); } } //var_dump($_FILES); uploadList(); ?> Brad Sumrall NYCTeleco

RE: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
eturned 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. Origina

RE: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
Updated code with var_dump; https://gist.github.com/3179506 Brad -Original Message- From: lists-php [mailto:replies-lists-d5y3-...@listmail.innovate.net] Sent: Wednesday, July 25, 2012 7:55 PM To: Brad Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name

RE: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
RCHAR(60); FIELDS TERMINATED BY ',' OPTIONALLY EN' at line 2 Brad -Original Message- From: lists-php [mailto:replies-lists-d5y3-...@listmail.innovate.net] Sent: Wednesday, July 25, 2012 7:55 PM To: Brad Subject: RE: [PHP-DB] Re: Stuck trying to upload and grab file name

RE: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
25, 2012 7:18 PM To: php-db@lists.php.net 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 includ

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Karl DeSaulniers
umm.com] Sent: Wednesday, July 25, 2012 7:05 PM To: php-db@lists.php.net 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 bric

[PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
PM To: php-db@lists.php.net 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. > > > > > var_

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Karl DeSaulniers
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. 0) { echo "Return Code: " . $file['error'] . ">"; }

[PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-25 Thread Brad
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. 0) { echo "Return Code: " . $file['error'] . ""; } else {

[PHP-DB] RE: Stuck trying to upload and grab file name

2012-07-24 Thread Brad
I wanted to start off by saying thank you to the list for your warm support. I was working with jonez from irc.oftc.net #php and we were able to far enough into the issue for me to realize I'm an idiot. I am creating a new table like I wanted but should be creating new field due to a little parad

[PHP-DB] RE: Stuck trying to upload and grab file name

2012-07-24 Thread Pavan puligandla
@lists.php.net Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name Okay. That line is also in the Pastie code :) Though it isn't in the OP. Hence my (and your) confusion now. Line 20 from here: http://pastie.org/4317155 also line 24. On Tue, Jul 24, 2012 at 10:44 AM, Jim Giner

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Graham H.
Okay. That line is also in the Pastie code :) Though it isn't in the OP. Hence my (and your) confusion now. Line 20 from here: http://pastie.org/4317155 also line 24. On Tue, Jul 24, 2012 at 10:44 AM, Jim Giner wrote: > On 7/24/2012 12:40 PM, Graham H. wrote: > >> If by "the line" you mean: ["

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
On 7/24/2012 12:40 PM, Graham H. wrote: If by "the line" you mean: ["tmp_name"]=> string(14) "/tmp/phpcLtE6W" That is from the bottom of this Pastie link: http://pastie.org/4317155 $file = $_FILES["file"]["tmp_name"]; I meant the above line. -- PHP Database Mailing List (http://www.php.

[PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
On 7/24/2012 4:16 AM, Brad wrote: $file = $_FILES['file']['name']; //$presql = "CREATE TABLE IF NOT EXISTS (`$_SESSION[SESS_MEMBER_ID]_$file`)"; $presql = "CREATE TABLE IF NOT EXISTS `$_SESSION[SESS_MEMBER_ID]_$file`";

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Graham H.
If by "the line" you mean: ["tmp_name"]=> string(14) "/tmp/phpcLtE6W" That is from the bottom of this Pastie link: http://pastie.org/4317155 On Tue, Jul 24, 2012 at 10:29 AM, Jim Giner wrote: > > On 7/24/2012 12:05 PM, Graham H. wrote: > >> Does the problem have anything to do with this: >> >>

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
On 7/24/2012 12:05 PM, Graham H. wrote: Does the problem have anything to do with this: ["tmp_name"]=> string(14) "/tmp/phpcLtE6W" So this: $file = $_FILES["file"]["tmp_name"]; Would make $file == "/tmp/phpcLtE6W" I'm not sure if that's what you want. Seems more likely that you'd want it

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Graham H.
- > From: Jim Giner [mailto:jim.gi...@albanyhandball.com] > Sent: Tuesday, July 24, 2012 8:45 AM > To: php-db@lists.php.net > Subject: [PHP-DB] Re: Stuck trying to upload and grab file name > > At the risk of being unable to understand all the posts that are here > already, he

RE: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Brad
oon as you throw in a variable/dynamic value, it just becomes a mess. Brad -Original Message- From: Jim Giner [mailto:jim.gi...@albanyhandball.com] Sent: Tuesday, July 24, 2012 8:45 AM To: php-db@lists.php.net Subject: [PHP-DB] Re: Stuck trying to upload and grab file name At the risk

[PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
At the risk of being unable to understand all the posts that are here already, here is some std. code that I use when I'm uploading a file. First - i capture the input field in a local var and all of its components in other local vars to make my coding easier later on. $inputfield = $_POST['