NYCPHP Meetup

NYPHP.org

[nycphp-talk] inserting data into MySQL table.

PaulCheung paulcheung at tiscali.co.uk
Tue Jul 24 08:12:57 EDT 2007


Yep!! as Chris said it was a rogue ";" there were other problems but they 
have all now been solved.
Once again thanks to everybody for all your help.

Paul

----- Original Message ----- 
From: "csnyder" <chsnyder at gmail.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Monday, July 23, 2007 10:13 PM
Subject: Re: [nycphp-talk] inserting data into MySQL table.


> On 7/23/07, PaulCheung <paulcheung at tiscali.co.uk> wrote:
>> Hi everybody,
>>
>> Thanks for the information, unfortunately for me there are no arrays 
>> being
>> used. The names used are solely the names of each individual column/field 
>> in
>> the table. I have already tried all the suggestions to no avail. That is 
>> why
>> I hardcoded a version of my insert-data-into-table and once I knew it 
>> worked
>> I substituted all the hardcoded fields with $_POST in place of the
>> hardcoding, I then cut and pasted in each field the corresponding 
>> hardcoded
>> value and just before writing the record. I echoed the record values and 
>> all
>> appears to be well. Then via the MySQL Monitor I check to see if the 
>> record
>> had been written and found that nothing has happened. Please forgive me 
>> if I
>> appear to be ungrateful, which is not the case I am just frustrated.
>> Especially after proving that one version of my insert-data-into-table
>> (hardcoded) worked and a version of my insert-data-into-table works with 
>> a 4
>> column table (a different table) and will not work with a version using 
>> as
>> input data the values of the hardcoded version. I knows the fault lays 
>> with
>> me but I cannot see it.
>>
>> Paul
>
> Hmm, is there any input filtering going on that is modifying the
> values in $_POST, to make them different from the hardcoded version?
> Is the dreaded magic_quotes_runtime enabled?
>
> Also, you have a semicolon in your POST test code, maybe you caught
> that already?
>
>> '".$R."'; '".$S."',
>
> -- 
> Chris Snyder
> http://chxo.com/
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php 



More information about the talk mailing list