index.php无法正常将数据库内容显示到网页上,请检查以下代码<?php //" target="_blank">https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"> //User Management //Name //Email //Add User //User List include 'db.php'; $sql = "SELECT id, time, IP,info,WXDJ,GSD,PIC,AQSB,up_time,beizhu FROM info_computer"; $result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "";
}
} else {
echo "";
}
$conn->close();
?>
要将数据库内容显示到网页上,需要确保以下几点:
以下是一个改进后的代码示例,确保数据库内容能够正确显示到网页上:
<?php
// 引入数据库连接文件
include 'db.php';
// SQL 查询语句
$sql = "SELECT id, time, IP, info, WXD, GSD, PIC, AQSB, up_time, beizhu FROM info_computer";
$result = $conn->query($sql);
// 检查查询结果
if ($result->num_rows > 0) {
// 输出表格头部
echo '<table class="table table-bordered">';
echo '<thead>';
echo '<tr>';
echo '<th>ID</th>';
echo '<th>Time</th>';
echo '<th>IP</th>';
echo '<th>Info</th>';
echo '<th>WXDJ</th>';
echo '<th>GSD</th>';
echo '<th>PIC</th>';
echo '<th>AQSB</th>';
echo '<th>Up Time</th>';
echo '<th>Beizhu</th>';
echo '</tr>';
echo '</thead>';
echo '<tbody>';
// 输出每一行数据
while($row = $result->fetch_assoc()) {
echo '<tr>';
echo '<td>' . $row['id'] . '</td>';
echo '<td>' . $row['time'] . '</td>';
echo '<td>' . $row['IP'] . '</td>';
echo '<td>' . $row['info'] . '</td>';
echo '<td>' . $row['WXDJ'] . '</td>';
echo '<td>' . $row['GSD'] . '</td>';
echo '<td>' . $row['PIC'] . '</td>';
echo '<td>' . $row['AQSB'] . '</td>';
echo '<td>' . $row['up_time'] . '</td>';
echo '<td>' . $row['beizhu'] . '</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
} else {
echo 'No records found.';
}
// 关闭数据库连接
$conn->close();
?>
确保在 HTML 头部引入 Bootstrap CSS 文件,以便表格样式能够正确显示:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>User Management</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<h1>User Management</h1>
<!-- 这里是 PHP 代码输出表格的地方 -->
<?php include 'index.php'; ?>
</div>
</body>
</html>
确保 db.php
文件中包含正确的数据库连接代码,例如:
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
通过以上步骤,应该能够正确地将数据库内容显示到网页上。