Am coding something. Cannot quite clear my head. I know what my SQL
looks like. I just cannot see clearly to input it.
What is $_POST["checkregion"] going to look like? Is it going to have
all the convenient commas I will need in my SQL? Or do I have to parse
God knows how many checkboxes?
John

<input type="text" name="Name">
<label><input type="checkbox" name="checkregion" value="Knowlton">A</label>
<label><input type="checkbox" name="checkregion" value="Thetford
Mines">A</label>


$sql ='insert into `database`.`table` (`Nom` ,`checkregion`)
values ('John', 'Knowlton,Thetford Mines') ';


CREATE TABLE IF NOT EXISTS `GLApplications` (
`Name` varchar(200) NOT NULL,
set(''Knowlton','Thetford Mines','Clarenceville','Sawyerville','Laval')
NOT NULL,
`dummy` int(10) NOT NULL auto_increment,
PRIMARY KEY (`dummy`)
)

http://www.glquebec.org/English/test.php
When I check "Knowlton" and "Thetford Mines" or others, only "Thetford
Mines" shows up in phpinfo(). $_POST["checkregion"] only sees "Thetford
Mines".
What am I doing wrong? How do I parse value checkregion? Or set this up
differently?

> <input type="text" name="Name">
> <label><input type="checkbox" name="checkregion" value="Knowlton">A</label>
> <label><input type="checkbox" name="checkregion" value="Thetford
> Mines">A</label>
>
>
> CREATE TABLE IF NOT EXISTS `GLApplications` (
> `Name` varchar(200) NOT NULL,
> set(''Knowlton','Thetford Mines','Clarenceville','Sawyerville','Laval')
> NOT NULL,
> `dummy` int(10) NOT NULL auto_increment,
> PRIMARY KEY (`dummy`)
> )

$_POST["checkregion"] is supposed to be an array, no?

John Taylor-Johnston wrote:
> http://www.glquebec.org/English/test.php
> When I check "Knowlton" and "Thetford Mines" or others, only "Thetford
> Mines" shows up in phpinfo(). $_POST["checkregion"] only sees
> "Thetford Mines".
> What am I doing wrong? How do I parse value checkregion? Or set this
> up differently?
>
>> <input type="text" name="Name">
>> <label><input type="checkbox" name="checkregion"
>> value="Knowlton">A</label>
>> <label><input type="checkbox" name="checkregion" value="Thetford
>> Mines">A</label>
>>
>>
>> CREATE TABLE IF NOT EXISTS `GLApplications` (
>> `Name` varchar(200) NOT NULL,
>> set(''Knowlton','Thetford
>> Mines','Clarenceville','Sawyerville','Laval') NOT NULL,
>> `dummy` int(10) NOT NULL auto_increment,
>> PRIMARY KEY (`dummy`)
>> )
>
>

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

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.

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" />

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" />

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

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.

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

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?

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

check out this discussion:
http://groups.google.com/group/alt.p...1216c72ba62a99