你几乎就在那里,你只需要改变一些事情:
$result = $link->query("SELECT * FROM messages WHERE public = '1'");
$messages = array();
while($message = $result->fetch_assoc()){
$messages[] = $message;
}
这将导致类似这样的事情:
array(
0 => array('message' => ..., 'subject' => ...),
1 => array('message' => ..., 'subject' => ...),
2 => array('message' => ..., 'subject' => ...),
);
如果您想将ID作为键,请执行以下操作:
$messages = array();
while($message = $result->fetch_assoc()){
$messages[ $message["id"] ] = $message;
}
这将导致:
array(
123 => array('message' => ..., 'subject' => ...),
456 => array('message' => ..., 'subject' => ...),
789 => array('message' => ..., 'subject' => ...),
);
在PHP 5.3中,您还获得了一个新方法,它与我发布的第一个代码示例相同:
$messages = $result->fetch_all(MYSQLI_ASSOC);