代碼: 選擇全部
$mysqli = new mysqli('[host]', '[username]', '[passowrd]', '[database]');
if ($stmt = $mysqli->prepare("[sql statement]")) {
$stmt->execute();
$meta = $stmt->result_metadata();
while ($field = $meta->fetch_field())
{
$params[] = &$row[$field->name];
}
call_user_func_array(array($stmt, 'bind_result'), $params);
while ($stmt->fetch()) {
foreach($row as $key => $val)
{
$c[$key] = $val;
}
$result[] = $c;
}
$stmt->close();
}
$mysqli->close();
var_dump($result);
https://www.php.net/manual/en/mysqli-st ... .php#92505
https://www.php.net/manual/en/mysqli-stmt.fetch.php