dpp10181 2016-07-28 01:57
浏览 119
已采纳

PHP / HTML表单显示

Can someone tell me what I am doing wrong? The code runs fine, but the result that outputs is weird. It is giving me an extra column.

<?php
error_reporting(E_ALL); ini_set('display_errors', 1);
$serverName = "server\sqlexpress";
$connectionInfo = array("Database"=>"mine");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn === FALSE){
  die( print_r( sqlsrv_errors(), true));
}

$sql = 'SELECT id, name, age FROM names';
$records = sqlsrv_query($conn, $sql);

?>

<html>
<head>
    <meta charset="UTF-8">
    <title>Heath Data</title>
</head>
<body>
    <table width="600" border="1" cellspacing="1" cellpadding="1">
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Age</th>
        </tr>


    <?php
    while ($employee = sqlsrv_fetch_array($records, SQLSRV_FETCH_ASSOC)){
        echo "<tr>";
        echo "<td>".$employee['id']."<td>";
        echo "<td>".$employee['name']."<td>";
        echo "<td>".$employee['age']."<td>";
        echo "<tr>";

    }
    ?>

    </table>
</body>

Here is the rersult: enter image description here

Why the extra column?

  • 写回答

2条回答 默认 最新

  • duangan6636 2016-07-28 01:59
    关注

    Just need to terminate the tags

    echo "<tr>";
echo "<td>".$employee['id']."</td>";
echo "<td>".$employee['name']."</td>";
echo "<td>".$employee['age']."</td>";
echo "</tr>";
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？