<div class="menutitlecontainer">
<div class="menutitle">PHP & MYSQL <sub>ONLINEMARKBOOK</sub></div>
</div>
<ul class="menucontainer">
<li><div class="menuitem">
<form method="post">
<input type="submit" name="menu_edit" value="EDIT" id="menu_button"></div>
</form></li>
<li><div class="menuitem"><a href="../index.html">↵</a></div></li>
</ul>
</div>
<div class="maincontainer">
<div class="subcontainer_phpmb">
<?php
$sql = SelectData('*', 'Markbook');
$tabledata = QuerySQL($sql, $database);
if ($tabledata->num_rows > 0) {
//table headings
echo "<table align='center'><tr class='first_col'>\n\t\t\t\t\t\t\t\t<th>First Name</th>\n\t\t\t\t\t\t\t\t<th>Last Name</th>\n\t\t\t\t\t\t\t\t<th>Student Number</th>\n\t\t\t\t\t\t\t\t</tr>";
//table content
while ($field = mysqli_fetch_assoc($tabledata)) {
echo "<tr class='highlightable_row'><td>" . $field['FirstName'] . "</td>";
echo "<td>" . $field['LastName'] . "</td>";
echo "<td>" . $field['StudentNum'] . "</td></tr>";
}
//close the table
echo "</table>";
} else {
echo "There are no markbook entries to view. Press EDIT to add an entry.";
}
?>
function UpdateInfo($data, $editcol, $info, $infocol, $table)
{
$sql = "UPDATE {$table}\n\t\t\t\tSET {$col} = [{$data}]\n\t\t\t\tWHERE {$infocol} = '{$name}'";
QuerySQL($sql);
}
