<td><input type='time' class='classroom_time' ></td> <td><select class='classroom_instructor'> <option>Select Instructor...</option> <?php echo optionInstructors("Classroom"); ?> </select></td> </tr> <tr class='session'> <td>Session 4</td> <td><input type='text' class='classroom_date date-field' class='date-field'></td> <td><input type='time' class='classroom_time' ></td> <td><select class='classroom_instructor'> <option>Select Instructor...</option> <?php echo optionInstructors("Classroom"); ?> </select></td> </tr> </table> </div> <diV><label class='flow'>In Classroom Score</label><input type='number' min='0' max='100' name='class_score' class='val-inclass_score' style='width:100px;'> %</diV> <div class='fltR'> <input type='button' value="PREVIOUS" class='previous'> <input type='submit' value="SAVE & CONTINUE" class='next'> </div> <div style="clear:both;"></div> </form> </div>
$q = "UPDATE students SET car_score=?, road_test_date=?, instructor_notes=?, road_test_pass=? WHERE user_id=?"; $r = $dbc->prepare($q); $r->execute(array($car_score, $test_date, $notes, $test_passed, $id)); //delete existing lessons if (isset($_POST['lessons'])) { $q = "DELETE FROM car_lessons WHERE student_id='{$id}'"; $r = $dbc->query($q); //iterate through lessons and write to db foreach ($lessons as $lesson) { $q = "INSERT INTO car_lessons (student_id, sess_num, sess_date, sess_time, instructor_id) VALUES (?,?,?,?,?)"; $r = $dbc->prepare($q); $r->execute(array($id, $lesson['sess_num'], $lesson['sess_date'], $lesson['sess_time'], $lesson['instructor_id'])); } } } elseif ($action == 'get instructor select') { $optionInstructors = optionInstructors("Vehicle"); $selectInstructors = "<select class='instructor'>\n\t\t<option>Select an Instructor</option>\n\t\t{$optionInstructors}\n\t</select>"; echo $selectInstructors; } elseif ($action == 'get upload indicators') { $stud_id = (int) $_GET['stud_id']; $q = "SELECT orig_filename, upload_type FROM uploads WHERE student_id='{$stud_id}'"; $r = $dbc->query($q); while ($row = $r->fetch(PDO::FETCH_ASSOC)) { $results[$row['upload_type']] = true; } echo json_encode($results); } elseif ($action == 'submit status change') { $id = (int) $_POST['stud_id']; $status = $_POST['status']; $date_sent = $_POST['date_sent']; $q = "UPDATE students SET status=?, date_cert_sent=? WHERE user_id=?";