Dynamic Multiple Input Processing

[Miyagi]

I am creating a simple "or so I thought" php/mysql survey.
There are 3 types of Surveys, with different questions. 1 for Clients,
1 for Employees, 1 for Peers.
Questions for each survey are created, editable, removable, and drag/
drop sortable.
Options to these questions are dynamic themselves.

Basically, everything works except when I try to Insert the data into
the answers table.

The one question I'm looking for is how would one process the data
based on the respective question_id's?
Sending it to another page would require an excessive amount of _POST
variables, and like i said before, there are different questions for
each survey.

or would this work? (it doesn't seem to process)
if($submit){
for($i=$start; $i<=$end; $i++){
$query[$i] = "INSERT INTO answer(ansresul t, ansdesc, idquestion,
idsurvey) VALUES('q_$i',' exp_$i','$idque stion','$survey Type')";
$result[$i]= mysql_query($qu ery[$i]);
if($result[$i]){$success++;}
}

$msg = sprintf("Succes s: %d, Questions: %d",$success,$e nd-$start);
echo($msg);
}

Any help, advice, or direction would be greatly appreciative.
- Justin Michaliga

[petersprc]

That will work. Instead of 'q_$i', you can use $_POST["q_$i"].

Here's an example:

<?
# survey.php
error_reporting (E_ALL);
require_once('M DB2.php');

if ($_SERVER['REQUEST_METHOD '] == 'POST') {
$items = array();
foreach ($_POST['answers'] as $id =$answer) {
$items[] = array($id, $answer);
}
$db = MDB2::singleton ('mysql://u:p@h/d');
$db->loadModule('Ex tended');
$st = $db->prepare('inser t into answer(question Ref, answer)
values (?, ?)');
$count = $db->extended->executeMultipl e($st, $items);
echo "Inserted $count answers.<br>";
}

?>

<p>Survey</p>
<form action=survey.p hp method=post>
Who?<br>
<input name="answers[1]"><br>
What?<br>
<input name="answers[2]"><br>
Where?<br>
<input name="answers[3]"><br><br>
<input type=submit>
<input type=hidden name=submit value=1>
</form>

On Jul 24, 3:01 pm, Miyagi <justin.michal. [e-mail] te:

I am creating a simple "or so I thought" php/mysql survey.
There are 3 types of Surveys, with different questions. 1 for Clients,
1 for Employees, 1 for Peers.
Questions for each survey are created, editable, removable, and drag/
drop sortable.
Options to these questions are dynamic themselves.

Basically, everything works except when I try to Insert the data into
the answers table.

The one question I'm looking for is how would one process the data
based on the respective question_id's?
Sending it to another page would require an excessive amount of _POST
variables, and like i said before, there are different questions for
each survey.

or would this work? (it doesn't seem to process)
if($submit){
for($i=$start; $i<=$end; $i++){
$query[$i] = "INSERT INTO answer(ansresul t, ansdesc, idquestion,
idsurvey) VALUES('q_$i',' exp_$i','$idque stion','$survey Type')";
$result[$i]= mysql_query($qu ery[$i]);
if($result[$i]){$success++;}

}

$msg = sprintf("Succes s: %d, Questions: %d",$success,$e nd-$start);
echo($msg);

}

Any help, advice, or direction would be greatly appreciative.
- Justin Michaliga