Insert Multiple Records from Repeat Region
Is there a way to insert multiple rows into a table from a repeat region in a form (similar to the data-assist multiple record inserts) using the MySQLi extension?
<?php
while(!$attendance->atEnd()) {
?>
<tr id="<?php echo($attendance->getColumnVal("person")); ?>">
<td align="center"><input name="present" type="checkbox" value="1" <?php echo($attendance->getColumnVal("present") ? "checked" : ""); ?>/></td>
<td><input type="hidden" name="person" value="<?php echo($attendance->getColumnVal("person")); ?>"><?php echo($attendance->getColumnVal("first_name")); ?> <?php echo($attendance->getColumnVal("last_name")); ?></td>
<td>
<select name="status">
<option value="">Select One</option>
<?php
while(!$status_menu->atEnd()) {
?>
<option value="<?php echo($status_menu->getColumnVal("person_status_id")); ?>" <?php echo($attendance->getColumnVal("status") == $status_menu->getColumnVal("person_status_id") ? "selected" : ""); ?>
><?php echo($status_menu->getColumnVal("person_status_name")); ?></option>
<?php
$status_menu->moveNext();
}
$status_menu->moveFirst(); //return RS to first record
?>
</select>
</td>
<td><input type="checkbox" name="remove"><label for="remove">Remove future list</label></td>
</tr>
<?php
$attendance->moveNext();
}
$attendance->moveFirst(); //return RS to first record
?>