>我正在尝试在无序列表的页面上显示数据库条目。我在 li 中回响我的行,我的 sql 连接似乎很好......我不明白我哪里做错了...有人有想法吗?
<body class="projects">
<?php
$mysqli = new mysqli("localhost", "root", "root", "project");
if ($mysqli->connect_errno) {
printf("Connect failed: %s'n", $mysqli->connect_error);
exit();
}
$query = "SELECT * FROM companies";
$result = $mysqli->query($query);
?>
<div id="projects" class="container">
<h1>Projects</h1>
<?php
while($row = $result->fetch_row());
?>
<ul>
<li>
<h2><?php echo $row['name']; ?></h2>
<p><?php echo $row['description']; ?></p>
</li>
</ul>
</div>
<?php
$result->close();
$mysqli->close();
?>
</body>
<ul>
<?php
while($row = $mysqli->fetch_row($result)) {
echo "<li>
<h2>".$row['name']."</h2>
<p>".$row['description']."</p>
</li>";
}
?>
</ul>
或者你可以用 {$row['item']} 包装回声,而不是我上面对进出 HTML 所做的。