how to display and storing selected loop option using checkbox? URGENT,PLS HELP ME...

li_rong

😕i'm doing an online questionnanires system. i'm using loop to display multiple question created in a page. Can anyone tel me how to use checkbox to display only selected loop questions in a next page and save all those selected questions as 1 field in database?? PLEASE HELP ME.. I NEED IT VERY URGENTLY!! 😕

dagon

well it is urgent ...

djjjozsi

multiple answers into one field sounds me a poor designed database model :eek:

lets save the checked questions in a session array, and on next page display only those which are in the "selected questions" array.

li_rong

thanks djjjozsi... but how to save checked question in session array if the questions are display using loop?? can teach me how to do that wif some example of code?

knowj

sounds like somone's got an assignment due and hasn't done the work.

If you provide one of us with the foundations of your code we can give you guidance/example code but currently your system requirements are very vague.

Most of what you want to do is basic programming theory with a few php functions.

li_rong

Below is the part of coding that i use to display the questions under a selected facility:

<?

$fasility = $_GET['RadioGroup1'];
$sql = "SELECT * FROM question where fasiliti='$fasility'order by created ";
$result_stu = mysql_query($sql);
$num_kow=mysql_num_rows($result_stu);

$c=1;
while($row = mysql_fetch_assoc($result_stu))

{
?>
<tr>
<td style="style8"><div align="center"><?php echo $c?></div>
<td style="style8"><?php echo $row['ques']?></td>
<td style="style8"><?php echo $row['ans_a']?></td>
<td style="style8"><?php echo $row['ans_b']?></td>
<td style="style8"><?php echo $row['ans_c']?></td>
<td style="style8"><?php echo $row['ans_d']?></td>
<td><div align="center"><span class="style16"><a href="display_selected_ques.php?id=<?php echo $row['id']; ?>&fasiliti=<?php echo $fasility; ?>"><input type="checkbox" name="checkbox" value="checkbox"></a></div></td>
</tr>
<?php
$c++;
}
?>

I don't know how to post the selected question using checkbox to the next page.. Please tell me what to do, help~~

knowj

are you trying to have each answer selectable with a raido button or is this page purely to select the questions you want on the next page?

li_rong

ya, this page is purely to select the questions i want on the next page..

knowj

each row of the database should have a unique id (primary key, auto_increment)

<input type="checkbox" name="checkbox[$row['id']]" value="checkbox" value="<?=$row['id']?>">

then have this for when the form is submit

<?php
if ($_POST) {
foreach ($_POST['checkbox'] as $value) {
$csv = $value.', ';
}
$csv = substr($csv, 0, -2);
}
?>

save $csv into your database field or a session then your SQL on the questionnaire page would be along the lines of:

SELECT * FROM `questions` WHERE `id` IN ($csv)

li_rong

This is the page that i wanted to use to select multiple questions i wan using checkbox:

[ATTACH]3804[/ATTACH]

li_rong

thanks a lot to knowj, i will try to use the coding u have teach me...