I feel like this should be easy but I am stuck. I am attempting to create a form that will dynamically update rows using radiobuttons selected by the user. It is a questionnaire. Next will be figuring out the best way to use pagination and update only the records displayed on that page.
Thanks in advanced
Assessment.php
<form action="Process/Process.php" method="post">
<?php do { ?>
<label><?php echo $row_Questions['Questions']; ?></label>
<label>
<input <?php if (!(strcmp($row_Questions['Value'],"1"))) {echo "checked=\"checked\"";} ?> type="radio" name="Value[<?php echo $row_Questions['QuestionID']; ?>]" class="icheck" data-radio="iradio_square-blue" value="1">
Strongly Disagree </label>
<label>
<input <?php if (!(strcmp($row_Questions['Value'],"2"))) {echo "checked=\"checked\"";} ?> type="radio" name="Value[<?php echo $row_Questions['QuestionID']; ?>]" class="icheck" data-radio="iradio_square-blue" value="2">
Disagree </label>
<label>
<input <?php if (!(strcmp($row_Questions['Value'],"3"))) {echo "checked=\"checked\"";} ?> type="radio" name="Value[<?php echo $row_Questions['QuestionID']; ?>]" class="icheck" data-radio="iradio_square-blue" value="3">
Neutral </label>
<label>
<input <?php if (!(strcmp($row_Questions['Value'],"4"))) {echo "checked=\"checked\"";} ?> type="radio" name="Value[<?php echo $row_Questions['QuestionID']; ?>]" class="icheck" data-radio="iradio_square-blue" value="4">
Agree </label>
<label>
<input <?php if (!(strcmp($row_Questions['Value'],"5"))) {echo "checked=\"checked\"";} ?> type="radio" name="Value[<?php echo $row_Questions['QuestionID']; ?>]" class="icheck" data-radio="iradio_square-blue" value="5">
Strongly Agree </label>
<input type="hidden" name="AnswerID[]" value="<?php echo $row_Questions['AnswerID']; ?>">
<input type="hidden" name="QuestionID[]" value="<?php echo $row_Questions['QuestionID']; ?>">
<input type="hidden" name="UserID[]" value="User">
<?php } while ($row_Questions = mysql_fetch_assoc($Questions)); ?>
<input type="submit" name="ValueAssessmen" value="Submit">
</form>
Process.php
if(isset($_POST['ValueAssessment'])) {
$AnswerID = count($_POST['AnswerID']);
$i = 0;
while ($i < $AnswerID) {
$AnswerID= $_POST['AnswerID'][$i];
$Value= $_POST['Value'][$i];
$QuestionID= $_POST['QuestionID'][$i];
$UserID= $_POST['UserID'][$i];
$query = "UPDATE answer SET Value = '$Value', QuestionID = '$QuestionID', UserID = '$UserID' WHERE AnswerID = '$AnswerID'";
mysql_query($query) or die ("Error in update query: $query");
++$i;
}
}