PHP 数组未显示在页面中
注释列表应显示在 ul li 范围内，有什么原因说明它们没有显示，而是数组显示在页面顶部？
数据库连接似乎工作得很好，但是注释没有显示在跨度内。它还删除了“您尚未添加任何注释文本”
代码
<?php
require_once 'app/init.php';
$notesQuery = $db->prepare("
SELECT ID, note
FROM notes
");
$notesQuery->execute();
$notes = $notesQuery->rowCount() ? $notesQuery : [];
foreach($notes as $note) {
print_r($note);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Notes</title>
<link rel="stylesheet" href="styles.css">
</head>
<body>
<header>
<h1>myNotes</h1>
<nav>
<a href="index.php">Home</a>
<a href="about.html">About</a>
<a href="contact.html">Contact</a>
</nav>
</header>
<div class="container">
<form action="add.php" method="post">
<textarea name="note" placeholder="Insert a note..." autocomplete="off" required></textarea>
<input type="submit" value="Add" />
</form>
<div class="notes">
<h2>Notes</h2>
<?php if(!empty($notes)): ?>
<ul>
<?php foreach($notes as $note): ?>
<li>
<span><?php echo $note['note']; ?></span>
</li>
<?php endforeach; ?>
</ul>
<?php else: ?>
<p>you haven't added any notes yet.</p>
<?php endif; ?>
</div>
慕的地108432回答
-
FFIVE
请随意使用下面的示例作为您的查询。// Your sql query$sql = "SELECT ID, note FROM notes";// Prepare your statement$stmt = $db -> prepare($sql);// Execute your prepared statement$stmt -> execute();// Retreive all rows$notes = $stmt -> fetchAll();// Check if array is not emptyif (!empty($notes)) { //Spit out the array print_r($notes);} -
慕雪6442864
工作代码<?phprequire_once 'app/init.php';$notesQuery = $db->prepare(" SELECT ID, note FROM notes");$notesQuery->execute();$notes = $notesQuery->rowCount() ? $notesQuery : [];?><!DOCTYPE html><html><head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Notes</title> <link rel="stylesheet" href="styles.css"></head><body> <header> <h1>myNotes</h1> <nav> <a href="index.php">Home</a> <a href="about.html">About</a> <a href="contact.html">Contact</a> </nav> </header> <div class="container"> <form action="add.php" method="post"> <textarea name="note" placeholder="Insert a note..." autocomplete="off" required></textarea> <input type="submit" value="Add" /> </form> <div class="notes"> <h2>Notes</h2> <?php if(!empty($notes)): ?> <ul> <?php foreach($notes as $note): ?> <li> <span><?php echo $note['note']; ?></span> </li> <?php endforeach; ?> </ul> <?php else: ?> <p>you haven't added any notes yet.</p> <?php endif; ?> </div> </div></body></html>
随时随地看视频慕课网APP
PHP