如何将 MySQLi 准备好的语句的结果放入关联数组? [英] How can I put the results of a MySQLi prepared statement into an associative array?

问题描述

我有一个 sql 查询和一个 mysqli 准备好的语句:

I have a sql query and a mysqli prepared statement:

$sql = 'SELECT photographers.photographer_id, photographers.photographer_name
    FROM photographers';

$stmt = $conn->stmt_init(); 
if ($stmt->prepare($sql)) { 
    $stmt->bind_result($photographer_id, $photographer_name);  
    $OK = $stmt->execute(); 
    $stmt->fetch();
}

如何将结果存储在关联数组中，以便稍后循环并获取 sql 字符串返回的所有数据?

How can I store the results in an associative array so I can loop it later and get to all the data returned by the sql string?

推荐答案

尝试以下操作:

$meta = $statement->result_metadata(); 

while ($field = $meta->fetch_field()) { 
    $params[] = &$row[$field->name]; 
} 

call_user_func_array(array($statement, 'bind_result'), $params);            
while ($statement->fetch()) { 
    foreach($row as $key => $val) { 
        $c[$key] = $val; 
    } 
    $hits[] = $c; 
} 
$statement->close(); 

首先，您获取查询元数据，并从中获取您获取的所有字段(您可以手动执行此操作，但此代码适用于所有查询，而不是手动构建).call_user_func_array() 函数调用 mysqli_stmt::bind_result() 为您提供每个参数的函数.

First you get the query metadata and from that obtain all the fields you've fetched (you could do this manually, but this code works for all queries rather than building by hand). The call_user_func_array() function calls the mysqli_stmt::bind_result() function for you on each of those parameters.

之后，只需遍历每一行并为每一行创建一个关联数组并将其添加到一个数组中，从而得到所有结果.

After that it is just a matter of running through each row and creating an associative array for each row and adding that to an array resulting in all the results.

这篇关于如何将 MySQLi 准备好的语句的结果放入关联数组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！