<?php include "link.php"; ?>
<form method="post">
<p>id:<input type="text" name="id"/></p>
<p>length:<input type="text" name="length"</p>
<p>width:<input type="text" name="width"</p>
<p>height:<input type="text" name="height"</p>
<br>;
<input type="submit" value="UPDATE"/>
</form>
<?php
$con = mysqli_connect("localhost", "root", "CWT520", "jiaju");
if (!$con) {
die('Could not connect:' . mysql_error());
}
if (isset($_POST['id']))
mysqli_query($con, "UPDATE jiajudata SET ID='" . $_POST['id'] . "'
where id='" . $_POST['id'] . "'");
if (isset($_POST['length']))
mysqli_query($con, "UPDATE jiajudata SET length='" . $_POST['length'] . "'
where id='" . $_POST['id'] . "'");
if (isset($_POST['width']))
mysqli_query($con, "UPDATE jiajudata SET width='" . $_POST['width'] . "'
where id='" . $_POST['id'] . "'");
if (isset($_POST['height']))
mysqli_query($con, "UPDATE jiajudata SET height='" . $_POST['height'] . "'
where id='" . $_POST['id'] . "'");
function render_table($result)
{
echo "<table border=1>";
echo "<tr>";
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
foreach ($row as $key => $link) {
echo "<td>" . $key . "</td>";
}
echo "</tr>";
foreach ($row as $key => $link){
echo "<td>". $link. "</td>";
}
while ($row222 = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
echo "<tr>";
foreach ($row222 as $key => $link1) {
echo "<td>" . $link1 . "</td>";
}
echo "</tr>\n";
}
}
echo "</table>";
$result = mysqli_query($con, "SELECT * FROM jiajudata");
render_table($result);
mysqli_close($con);
?>