这里在a.p p文件中只有1行被显示。我使用fetch(PDO::FETCH_ASSOC)，但我没有得到所有的行从聊天日志。问题在哪里?
a.php
<html>
<head>
</head>
<body>
<?php
Include ('connect.php');
$query = $handler->prepare("SELECT message FROM chatlog");
$query->execute();
while ($row = $query->fetch()) {
$message = $row['message'];
$query = $handler->prepare("SELECT * FROM smilies");
$query->execute();
while ($row = $query->fetch()) {
$emoji = $row['emoji'];
$smiley = "<img src='image/" . $row['smiley'] . "'/>";
$message = str_replace($emoji, $smiley, $message);
}
print_r("$message");
}
?>
</body>
</html>
<?php
Include ('connect.php');
$smileys = $handler->query("SELECT emoji, smiley FROM smilies")->fetchAll();
$query = $handler->query("SELECT message FROM chatlog");
foreach($query as $row)
{
$message = $row['message'];
foreach($smileys as $sm)
{
$smiley = "<img src='image/$sm[smiley]'/>";
$message = str_replace($sm['emoji'], $smiley, $message);
}
echo $message;
}