php - PHP 和 Mysql 返回空白页面的问题

Question

我有一个简单的表单，我正在尝试编码以获取将 php 页面从 drupal 重新编码到 linux 的句柄。我认为我无法访问所有旧代码，但尽我所能。HTML 代码如下:

<form accept-charset="UTF-8" method="post" action="keyset_checkin.php">
<div>
 <label for="edit-keysetnumber">Serial Number: </label>
 <input type="text" maxlength="128" name="keysetnumber"  size="60" value="" />
</div>
<input type="submit" name="op" value="Check In Keyset"  />
</form>

然后这是 PHP:

<?php

$dbhost = '*********';
$dbuser = '*********';
$dbpass = '*********';
$dbname = '*********';

$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
mysql_select_db($dbname);

/*$content .=  backLink();
    $content .= "<table border='0'><tr><td colspan='3'><strong>Keylog Report: All Keyset/Keys</strong></td></tr>";

    $content .= "</table>";
        return $content;
*/
        $content .= "<table border='0'><tr><td colspan='3'><strong>Keylog Report: All Keyset/Keys</strong></td></tr>";

    $query = "SELECT keysetnumber,keyring_id,building FROM {keyinv_key_sets} WHERE building NOT LIKE '%ZONE%' and building NOT LIKE '%SUPV%' GROUP BY keyring_id ORDER BY building ASC";

    $result = db_query($query);

    if(db_affected_rows() !=0)
    {   
        while($row = db_fetch_object($result))
        {
            $content .= "<tr><td valign='top'><font size='-3'><strong>$row->building</strong></font></td><td valign='top' width='50' align='center'><font size='-3'><strong>$row->keyring_id</strong></font></td>";

            $content .= "<td valign='top'>";

            //drupal_set_message($row->keysetnumber);   

            $query2 = "SELECT keytext, keydescription FROM {keyinv_keyset_keys} WHERE keysetnumber='$row->keysetnumber'";
            $result2 = db_query($query2);

            //drupal_set_message("Made it here");

            while($row2 = db_fetch_object($result2))
            {
                //drupal_set_message("Got Here");
                $content .= "<font size='-3'>$row2->keytext <font color='#CCCCCC'>($row2->keydescription)</font><font> ";
            }   

            $content .= "</td></tr>";
        }
    }
    else
    {
        $content .= "<tr><td>No Results</td></tr>";
    }

    $content .= "</table>";


        return $content;
?>

我尝试将其缩减为

行

$content .= "<table border='0'><tr><td colspan='3'><strong>Keylog Report: All Keyset/Keys</strong></td></tr>";
$content .= "<tr><td>No Results</td></tr>";
$content .= "</table>";

它只返回一个空白页，我认为至少这 3 行会返回一个带有标题的空表。我认为它应该返回到我所在的页面，即表格所在的位置。我在这里做错了什么

Answer 1

尝试回显结果($content)而不返回它。