php get_results结果数量,PHP MySQLI编写了get_results()的语句中断

我对

mysqli准备好的陈述很新,其实这是我第一次尝试它.我有这个代码块,我把echos放在每个命令之间,它显示aaa和bbb但不是ccc,我在这里做错了什么？

没有错误出现,只是一个空白屏幕：

$mysqli = new mysqli("localhost", "username", "password", "database");

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

}

if ($stmt = $mysqli->prepare("SELECT title FROM `in-the-press`")) {

$stmt->execute();

echo 'aaa';

$stmt->bind_result($title);

echo 'bbb';

$result = $stmt->get_result();

echo 'ccc';

while ($stmt->fetch()) {

printf("%s %s\n", $title);

}

echo 'ddd';

$stmt->close();

}

$mysqli->close();

?>

更新通过执行以下操作,我能够实现此功能：

$mysqli = new mysqli("localhost", "username", "password", "database");

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

}

if ($stmt = $mysqli->prepare("SELECT id, community, map, image FROM `googleMaps`")) {

$stmt->execute();

$stmt->bind_result($id, $community, $map, $image);

$stmt->fetch();

printf($id . ' ' . $community . ' ' . $map . ' ' . $image);

$stmt->close();

}

?>

但这只给我一行数据,如何获取所有数据行？