?>
</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'];
}
