Re: [PHP] Re: input type=checkbox
On Fri, 2008-03-14 at 23:14 -0400, John Taylor-Johnston wrote: $_POST[checkregion] is supposed to be an array, no? You want the following (otherwise each checked entry overwrites the previous): input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
Ah! ok, Array ( [0] = Hemmingford [1] = Huntingdon ) How do I set up my $sql? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '.implode(',', $_POST['myvalues'].') '; ... Hey!! What is this? Diagnostic-Code: smtp; 550-5.7.1 mail rejected by policy. SURBL hit 550-Spammy URLs in your message 550 See http://master.php.net/mail/why.php?why=SURBL Robert Cummings wrote: On Fri, 2008-03-14 at 23:14 -0400, John Taylor-Johnston wrote: $_POST[checkregion] is supposed to be an array, no? You want the following (otherwise each checked entry overwrites the previous): input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / Cheers, Rob. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
Will this do it? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '.implode(',', serialise($_POST['checkregion']).') '; http://ca.php.net/manual/en/function.serialize.php Array ( [0] = Hemmingford [1] = Huntingdon ) input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
Sorry, will this work? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '.serialise($_POST['checkregion']).') '; John Taylor-Johnston wrote: Will this do it? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '.implode(',', serialise($_POST['checkregion']).') '; http://ca.php.net/manual/en/function.serialize.php Array ( [0] = Hemmingford [1] = Huntingdon ) input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
On Sat, 2008-03-15 at 00:18 -0400, John Taylor-Johnston wrote: Sorry, will this work? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '.serialise($_POST['checkregion']).') '; Depends on what you want to do with the data. But you've certainly spelled serialize() wrong as it regards usage in PHP. Cheers, Rob. John Taylor-Johnston wrote: Will this do it? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '.implode(',', serialise($_POST['checkregion']).') '; http://ca.php.net/manual/en/function.serialize.php Array ( [0] = Hemmingford [1] = Huntingdon ) input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
Robert, Array ( [0] = Hemmingford [1] = Huntingdon ) You want the following (otherwise each checked entry overwrites the previous): input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / How would you proceed? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '. ?? .') '; I'm just guessing. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
On Sat, 2008-03-15 at 00:33 -0400, John Taylor-Johnston wrote: Robert, Array ( [0] = Hemmingford [1] = Huntingdon ) You want the following (otherwise each checked entry overwrites the previous): input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / How would you proceed? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '. ?? .') '; I'm just guessing. It depend son what you want to do with the data. It may be that you want a row for every selected entry or it may be that you can just serialize the data. Do you want to just have a snapshot of what the user chose? Or do you want to be able to query the database about who selected Knowlton? If the former, then you can get away with just serializing the data, but if you want to be able to do queries, then you need to store each entry in its own row. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
Robert Cummings wrote: On Sat, 2008-03-15 at 00:33 -0400, John Taylor-Johnston wrote: Robert, Array ( [0] = Hemmingford [1] = Huntingdon ) You want the following (otherwise each checked entry overwrites the previous): input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / How would you proceed? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '. ?? .') '; I'm just guessing. It depend son what you want to do with the data. It may be that you want a row for every selected entry or it may be that you can just serialize the data. Do you want to just have a snapshot of what the user chose? Or do you want to be able to query the database about who selected Knowlton? If the former, then you can get away with just serializing the data, but if you want to be able to do queries, then you need to store each entry in its own row. Cheers, Rob. It would look like: $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', 'Montreal,Knowlton,anything') '; checkregion[5] = Montreal; checkregion[7] = Knowlton; checkregion[55] = anything; I need to unarray checkregion[] and break it up into separate words and then separate them by commas. Hmm? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: input type=checkbox
On Sat, 2008-03-15 at 01:00 -0400, John Taylor-Johnston wrote: Robert Cummings wrote: On Sat, 2008-03-15 at 00:33 -0400, John Taylor-Johnston wrote: Robert, Array ( [0] = Hemmingford [1] = Huntingdon ) You want the following (otherwise each checked entry overwrites the previous): input type=checkbox name=checkregion[] value=Knowlton / input type=checkbox name=checkregion[] value=Thetford Mines / How would you proceed? $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', '. ?? .') '; I'm just guessing. It depend son what you want to do with the data. It may be that you want a row for every selected entry or it may be that you can just serialize the data. Do you want to just have a snapshot of what the user chose? Or do you want to be able to query the database about who selected Knowlton? If the former, then you can get away with just serializing the data, but if you want to be able to do queries, then you need to store each entry in its own row. Cheers, Rob. It would look like: $sql ='insert into `database`.`table` (`Nom` ,`checkregion`) values ('John', 'Montreal,Knowlton,anything') '; checkregion[5] = Montreal; checkregion[7] = Knowlton; checkregion[55] = anything; I need to unarray checkregion[] and break it up into separate words and then separate them by commas. $regions = implode( ',', $checkregion ); $sql = INSERT INTO `database`.`table` .( .`Nom`, .`checkregion` .) .VALUES .( .'.mysql_real_escape_string( $nom, $conn ).', .'.mysql_real_escape_string( $regions, $conn ).' .) ; Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php