<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); }