混合PHP的mysqli数据访问功能？-MixingPHP'smysqlidataaccessfunctions?

There are multiple implementations of a function to do this sort of thing in the comments on this page of the php manual: mysqli_stmt::fetch

在php手册的这个页面的注释中有一个函数的多个实现来做这种事情:mysqli_stmt :: fetch

Alnitak,

AFAIK, you cannot bind an entire array to the fetched results automatically. Unfortunately. However, if you're looking for array behavior out of it (presumably so it's easier to pass the results around), you could try this:

AFAIK,您无法自动将整个数组绑定到获取的结果。不幸。但是,如果您正在寻找其中的数组行为(可能因此更容易传递结果),您可以尝试这样做:

prepare( 'SELECT id, email FROM email_list' );
 {
  $stmt->execute();
  $stmt->bind_result( $arr['id'], $arr['email'] );

  while( $stmt->fetch() )
   DoSomething( $arr );
 }
?>

This will give you the behavior you requested, above. It will not, however, dynamically bind array fields to associative indeces in the array -- that is, you must specify that id be bound to $arr['id'], etc.

这将为您提供上述请求的行为。但是,它不会将数组字段动态绑定到数组中的关联indeces - 也就是说,必须指定将id绑定到$ arr ['id']等。

If dynamic binding to the associative indeces is really required by your scenario, you could always write a simple class that would first parse the query for the selected fields, then setup the assoc array indeces, then perform the query.

如果您的方案确实需要动态绑定到关联indeces,则可以始终编写一个简单的类,该类首先解析所选字段的查询,然后设置assoc数组indeces,然后执行查询。

I would say no. Thought I haven't worked with mysqli or prepared statements a ton, I believe that each step in your second example is discrete and necessary. The only consolation I can give you is that your first example glossed over some SQL escaping that you can safely and truly ignore in your second example.

我会说不。我以为我没有使用mysqli或准备好的声明,我相信你的第二个例子中的每一步都是离散的和必要的。我能给你的唯一安慰就是你的第一个例子掩盖了一些SQL转义,你可以在第二个例子中安全地忽略它。