通过将数据库值存储到数组中,然后循环遍历数组与仅使用while循环相比有什么好处?
将db结果输出到数组:
$records = array();
if($results = $db->query("SELECT name, address FROM town")) {
if($results->num_rows) {
while($row = $results->fetch_object()) {
$records[] = $row;
}
$results->free();
}
}
遍历数组:
foreach($records as $r) {
$r->name;
}
使用VS与简单While循环的比较:
if($result = $db->query("SELECT name, address FROM town")) {
if($count = $result->num_rows) {
while($row = $result->fetch_object()) {
echo $row->name, ' ', $row->address, '<br />';
}
$result->free();
}
}