foreach遍历输出数据表

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

?>