[Resolved] Dynamic checkboxes and MySQL insersion issue

Jezz

Imagine this:

You have a form. The values posted by this form go into a table. On the form you need to display a checkbox for each product you have. However products are listed dynamically, so depending on what happens else where in the DB, certain products may or may not appear on the form. I have this working fine.

My issue is thus: when the form is filled in, it is possible to select more than one product. If this happens then I need each product value to be stored in that record, or instead I want a record to be created for each product value, the rest of the data in the form would be repeated for each instance of a product value sent by the form.

At the moment the best I can get is that no matter how many products are selected, it only ever posts the last value in the results set, and only inserts this value in to the resulting record.

I have tried everything I know to fix this but cannot. I have been to many forums but noone else has a clue either. I cannot hardcode values for checkboxes cos they have to be dynamic.

laserlight

Show us the smallest and simplest example of a PHP script that demonstrates this problem that you've set out to solve.

trex005

page where they can select :

echo "<INPUT TYPE='checkbox' VALUE=1 NAME='item[$item_number]' ID=item_ID_$item_number><LABEL FOR=item_ID_$item_number>$item_name</LABEL>";

Page where you process :

$array_of_selected_items = array_keys($item);

Let me know if that works for you

Jezz

erm, no it didn't.

When the form was posted, I asked it to show me the posted value of $AssetId - the result was "Array" - no value was inserted into the table, so it defaulted to 0!

Here is the code I created based on you suggestion. The form is created in php hense the \ use. I use one script to do everything, show the form, post it, insert into table. I think the issue is that of posting an array, to this end I have add some additional code.

$AssetName</LABEL></input><br>";

if(is_array($POST['AssetId'])) {
$postAssetIdserialized = serialize($POST['AssetId']);

$sql = "insert into $table_name values('','$POST[Name]', '$POST[CompanyName]', '$_POST[EmailAddress]',
'mysql_escape_string($posttypeserialized)')";

trex005

unless you did not include it here, it appears you did not use array_keys

$asset_id_array = array_keys($_POST['AssetId']);
$asset_id_array = serialize($asset_id_array);
$sql = "insert into $table_name values('','$_POST[Name]', '$_POST[CompanyName]', '$_POST[EmailAddress]',
'mysql_escape_string($asset_id_array)')";

if this does not work for you... it would be helpful if I could see more of your code so I can see what you are trying to do

Jezz

Made some changes, based on stuff I read, and can now post the array and insert into the table - Good.

This is what's inserted for one selected product:
a:1:{i:0;a:1:{s:14:"Test Product";s:2:"on";}}

In a separate script, designed to read in the contents of this table for display purposes, I have the following code designed to get the records for display, and unserialize the array:

$Name = $row['Name'];
$EmailAddress = $row['EmailAddress'];
$AssetName = $row['AssetName'];
$CompanyName = $row['CompanyName'];

$var = unserialize ($AssetName);

$text_block .= "
<Table border=1 Table width=100% cellpadding='2'>
<tr valign ='Top'>
<td col width=25%>$Name</td>
<td col width=25%>$EmailAddress</td>
<td col width=25%>$var</td>
<td col width=25%>$CompanyName</td></tr>
</Table>";

When I now view the page which should, I would expect, under products say - Test Product, it says Array!

Why does it say Array and not Test Product?

trex005

what you are echoing there is indeed an array... of test product Names
Try this :

$var = unserialize ($AssetName); 
$var = explode(",",$var);

Jezz

didn't make any difference, still says array - having tried that also tried;

$var = implode(",",$var);

having done this, one of the records still said 'array', the other said 'on', so I don't think thats the way to go either?

trex005

could you possilby have an array of arrays?
try

$var = unserialize ($AssetName);
echo "<PRE>", print_r($var),"</PRE>";

to debug it

Jezz

erm, this was the result when page was run:

Array
(
[0] => Array
(
[Test Product] => on
)

)
1

I currently have a single record in the table, with a single product selected.

I added the bit of code with explode in it, as well as the debugging code, got this:

Array
(
[0] => Array
)
1

Does any of that mean anything to you?