?> </div></legend> <form class="form-horizontal"> <fieldset> <!-- Select Basic --> <div class="form-group"> <label class="col-md-4 control-label" for="selectbasic">Student</label> <div class="col-md-5"> <select id="selectbasic" name="student" class="form-control"> <?php if ($addnew) { echo '<option value="0"> - Select Student</option>'; } $student_list = get_student_list(); while ($student_identity = mysql_fetch_assoc($student_list)) { if ($student_identity['student_key'] === $row['student']) { echo '<option value="', $student_identity['student_key'], '" selected>', $student_identity['last_name'], ', ', $student_identity['first_name'], '</option>'; } else { echo '<option value="', $student_identity['student_key'], '">', $student_identity['last_name'], ', ', $student_identity['first_name'], '</option>'; } } ?> </select> </div> </div> <div class="form-group"> <label class="col-md-4 control-label" for="textinput">Tuition For Class</label> <div class="col-md-5"> <input id="textinput" name="tuition_due" type="text" placeholder="Amount" class="form-control input-md" required="">
<li><a href="reports.php?tab=students&sortby=3">Teacher</a></li> <li><a href="reports.php?tab=students&sortby=4">Instrument</a></li> <li><a href="reports.php?tab=students&sortby=5">Photo Release</a></li> </ul> </div> <table class="table table-striped text-center"> <?php $link = connectDB(); //output student table. if (isset($_GET['sortby'])) { $sort = $_GET['sortby']; $results = get_student_list($sort); } else { $sort = 0; $results = get_student_list($sort); } if (!$results) { echo "Database Error"; } else { // table headers echo '<thead><tr>'; echo '<th><div class="text-center"><a href="edit-student-form.php?student=new""> <img class="table-icon" src="./res/image/add-user.png"></a></div></th> <th><div class="text-center"></div></th> <th><div class="text-center">Last Name</div></th> <th><div class="text-center">First Name</div></th> <th><div class="text-center">Parent</div></th> <th><div class="text-center">Date of Birth</div></th> <th><div class="text-center">Teacher</div></th> <th><div class="text-center">Instrument</div></th>
} echo '</tbody>'; } ?> </table> </div> </div> <?php } else { if ($tab == 'class') { ?> <div id="class" class="table-responsive"> <?php if (isset($_GET['class-key'])) { $class_key = clean_up($_GET['class-key']); $results = get_student_list($class_key); } $results = get_class_name($class_key); $row = mysql_fetch_assoc($results); echo "<h3>" . $row['class_name'] . " Class</h3>"; ?> <ul class="list-inline"> <li><a href="reports.php?tab=class&class-key=<?php echo $class_key; ?> &sortby=1">Last Name</a></li> <li><a href="reports.php?tab=class&class-key=<?php echo $class_key; ?> &sortby=2">First name</a></li> <li><a href="reports.php?tab=class&class-key=<?php
<?php require_once "core/init.php"; // $link = connectDB(); // if(!$link) { // echo "Unable to connect to DB"; // exit; // } $results = get_student_list(); if (!$results) { echo "results are empty"; } while ($row = $result->fetch_assoc()) { echo $row['first_name']; }