how to get value from dynamical check box ?

phpkets

hi all,
does anyone know where i have done mistake ?

<?php $questionsInclude = mysql_query("SELECT * FROM ts_questions WHERE setid='".$row_tsset['id']."'");

while($aquestionsInclude = mysql_fetch_array($questionsInclude)){
//$qd1 = mysql_query("SELECT * FROM ts_questions ORDER by setid;");

$qd = $row_tsquestion['setid'];

echo "<input name='chqu' type='checkbox' value='$qd' onClick='alert(value);'>";

echo $aquestionsInclude['question'];

echo "<br>"; }?>

on all check boxes i am getting first setids value.
actually it should be different as per question's setid.

thanks.

Jourdain

you arnt setting $qd with the values returned from the database, try using:

$qd = $aquestionsInclude['setid'];

instead of your $row_tsquestion['setid'];

phpkets

oh man !
how easy it was !

i think i need to learn more.
really thanks Jourdain.

bradgrafelman

Don't forget to mark this thread resolved.

phpkets

Thank you for your help, but now the problem is while inserting into database it is taking just last value of that chechbox.
infact it should take all the values of checkboxes.

bradgrafelman

In that case, you need to add "[]" brackets to the end of your checkboxes' names. This turns the checkbox elements into an array (e.g. $_POST['setid'] will then be an array). You would then need to loop through the array to get all of the values.

For help with this part, see my reply here in a thread dealing with a similar issue - inserting data from an array element in a form into a SQL database. Alternatively, if you'll search the board with keywords such as "HTML array" or "form array" I'm sure you'll find similar topics that have been previously resolved.

phpkets

i saw ur post as well as search with same keyword.
but not able to get things clear.

anyway so far i have done like this :

if ((isset($POST["MM_insert"])) && ($POST["MM_insert"] == "form1")) {
$que_id = '';
foreach($POST["que_id"] AS $key => $value){
$insertSQL = sprintf("INSERT INTO ts_masterset (que_id, name) VALUES (%s, %s)",
GetSQLValueString($POST['que_id'], "text"),
GetSQLValueString($_POST['name'], "text"));}

and my html code looks like, where i am generating all question through array :

<?php $questionsInclude = mysql_query("SELECT * FROM ts_questions WHERE setid='".$row_tsset['id']."'");
while($aquestionsInclude = mysql_fetch_array($questionsInclude)){
$qd = $aquestionsInclude['id'];
echo "<input name='que_id[]' type='checkbox' value='$qd'>";
echo $aquestionsInclude['question'];
echo "<br>"; }?>

but with this code i am getting "Array" as a value in database.

awaiting ur reply,
thanks.

bradgrafelman

Well of course you do - you're trying to insert an array as if it were a string.

You use your GetSQLValueString() on the $_POST['que_id'] array. The whole point of using a foreach() loop on that array was so that you would loop through it and access each value (in the $value variable as you've defined it).

I'm not sure how the $_POST['name'] element is formed, but if you're trying to submit multiple textboxes with the same field name ("name") then you'll need to do the same thing you did with que_id.

phpkets

please look into attach image file.
i hope u will get some idea after seeing this table.
this is what i am generating all questions through array.
and wanted to save in db after submitting form.

any idea ?

thanks.