php - 回显具有特定字段的html表格

Question

我对 PHP 还很陌生。而且我似乎无法在这里找到我的代码的问题。我试图从我的表中选择特定行，并使用我自己的标题在我的 HTML 表中回显它。我不断收到表消息中没有可用数据。

<?php
       $db_host = 'localhost';
       $db_user = 'my user';
       $db_pwd = 'my pwd';

       $database = 'my db';
       $table = 'client';

    if (!mysql_connect($db_host, $db_user, $db_pwd))
                    die("Can't connect to database");

                if (!mysql_select_db($database))
                    die("Can't select database");

                // sending query
                $result = mysql_query("SELECT 'id', 'datecreated', FROM {$table}");
                if (!$result) {
                    die("Query to show fields from table failed");
                }

                $fields_num = mysql_num_fields($result);

                echo "<table class='table table-bordered table-striped mb-none' id='datatable-tabletools' data-swf-path='assets/vendor/jquery-datatables/extras/TableTools/swf/copy_csv_xls_pdf.swf' >";
                // printing table headers
                echo "<thead>";
                echo "<th>Client ID</th>";
                echo "<th>Sign Up Date</th>";
                echo "</thead>";
                // printing table rows
                if ($results->num_rows > 0) {
                while ($row = $results->fetch_assoc()){

                }
                    echo "<tbody>";
                    echo "<tr>";


                    echo "<td>".$row["id"]."</td>";
                    echo "<td>".$row["datecreated"]."</td>";



                    echo "</tr>";
                    echo "</tbody>";
                }
                mysql_free_result($result);
                ?>

Answer 1

将 while 循环中的代码顺序更改为:

if ($fields_num > 0) {
    echo "<tbody>";
    while ($row = mysql_fetch_assoc($result)) {

        echo "<tr>
            <td>".$row["id"]."</td>
            <td>".$row["datecreated"]."</td>
            </tr>";

    }
    echo "</tbody>";
}

目前您实际上并未对正在检索的数据执行任何操作。

仅供引用 - mysql 已弃用，您应该使用 mysqli