深藍色論壇

代碼: 選擇全部

$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);