blocks|key|2922507|text|请阅读此方法的用户说明：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2922508|http://php.net/manual/en/mysqli-stmt.get-result.php|offset|length|2922509|它需要mysqlnd驱动程序...如果它没有安装在你的网站上，你将不得不使用bind_result()+&+fetch()！|style|CODE|2922510|entityMap|0|LINK|mutability|MUTABLE|url|1|https://www.php.net/manual/en/mysqli-stmt.bind-result.php|2|https://www.php.net/manual/en/mysqli-stmt.fetch.php^0|0|0|1F|0|0|12|D|1I|7|12|D|1|1I|7|2|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|F|3|G|5|6|7|Z|8|@$D|10|E|11|H|I]|$D|12|E|13|H|I]]|9|@$D|14|E|15|1|16]|$D|17|E|18|1|19]]|A|$]]|$1|J|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|R]]|S|$5|M|N|O|A|$P|T]]]]

Please read the user notes for this method:
<a href="http://php.net/manual/en/mysqli-stmt.get-result.php" rel="nofollow noreferrer">http://php.net/manual/en/mysqli-stmt.get-result.php</a>
It requires the mysqlnd driver... If it isn't installed on your webspace you will have to work with <a href="https://www.php.net/manual/en/mysqli-stmt.bind-result.php" rel="nofollow noreferrer"><code>bind_result()</code></a> &amp; <a href="https://www.php.net/manual/en/mysqli-stmt.fetch.php" rel="nofollow noreferrer"><code>fetch()</code></a>!

blocks|key|2922512|text|因此，如果MySQL本机驱动程序(mysqlnd)驱动程序不可用，因此使用bind_result和fetch而不是get_result，代码将变为：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2922513|include+'conn.php';
$conn+=+new+Connection();
$query+=+'SELECT+EmailVerified,+Blocked+FROM+users+WHERE+Email+=+?+AND+SLA+=+?+AND+`Password`+=+?';
$stmt+=+$conn->mysqli->prepare($query);
$stmt->bind_param('sss',+$_POST['EmailID'],+$_POST['SLA'],+$_POST['Password']);
$stmt->execute();
$stmt->bind_result($EmailVerified,+$Blocked);
while+($stmt->fetch())
{
+++/*+Use+$EmailVerified+and+$Blocked+*/
}
$stmt->close();
$conn->mysqli->close();|code-block|syntax|javascript|2922514|entityMap^0|11|B|1D|5|1L|A|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|L|$]]

So if the MySQL Native Driver (mysqlnd) driver is not available, and therefore using bind_result and fetch instead of get_result, the code becomes:

<pre><code>include 'conn.php';
$conn = new Connection();
$query = 'SELECT EmailVerified, Blocked FROM users WHERE Email = ? AND SLA = ? AND `Password` = ?';
$stmt = $conn-&gt;mysqli-&gt;prepare($query);
$stmt-&gt;bind_param('sss', $_POST['EmailID'], $_POST['SLA'], $_POST['Password']);
$stmt-&gt;execute();
$stmt-&gt;bind_result($EmailVerified, $Blocked);
while ($stmt-&gt;fetch())
{
 /* Use $EmailVerified and $Blocked */
}
$stmt-&gt;close();
$conn-&gt;mysqli-&gt;close();
</code></pre>

blocks|key|248179|text|您的系统缺少mysqlnd驱动程序！|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|248180|如果您能够在(基于Debian/Ubuntu的)服务器上安装新的软件包，请安装驱动程序：|248181|sudo+apt-get+install+php5-mysqlnd|code-block|syntax|javascript|248182|然后重新启动您的web服务器：|248183|sudo+/etc/init.d/apache2+restart|248184|entityMap^0|0|I|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

Your system is missing the mysqlnd driver!

If you are able to install new packages on your (Debian/Ubuntu-based) server, install the driver:

<pre class="lang-none prettyprint-override"><code>sudo apt-get install php5-mysqlnd
</code></pre>

and then restart your web server:

<pre class="lang-none prettyprint-override"><code>sudo /etc/init.d/apache2 restart
</code></pre>

blocks|key|3136619|text|我知道这已经回答了实际问题是什么，但是我想提供一个简单的解决方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3136620|我想使用get_results()方法，但是我没有驱动程序，而且我也不能得到添加的驱动程序。所以，在我打电话之前|3136621|$stmt->bind_results($var1,$var2,$var3,$var4...etc);|code-block|syntax|javascript|3136622|我创建了一个空数组，然后将结果绑定为该数组中的键：|3136623|$result+=+array();
$stmt->bind_results($result['var1'],$result['var2'],$result['var3'],$result['var4']...etc);|3136624|以便可以轻松地将这些结果传递到方法中或转换为对象以供进一步使用。|3136625|希望这篇文章能帮助任何想做类似事情的人。|3136626|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I know this was already answered as to what the actual problem is, however I want to offer a simple workaround.

I wanted to use the get_results() method however I didn't have the driver, and I'm not somewhere I can get that added. So, before I called 

<pre><code>$stmt-&gt;bind_results($var1,$var2,$var3,$var4...etc);
</code></pre>

I created an empty array, and then just bound the results as keys in that array:

<pre><code>$result = array();
$stmt-&gt;bind_results($result['var1'],$result['var2'],$result['var3'],$result['var4']...etc);
</code></pre>

so that those results could easily be passed into methods or cast to an object for further use.

Hope this helps anyone who's looking to do something similar.

blocks|key|2922523|text|对于那些正在寻找$result+=+$stmt->get_result()替代品的人，我做了这个函数，它允许你模仿$result->fetch_assoc()，但直接使用stmt对象：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2922524|function+fetchAssocStatement($stmt)
{
++++if($stmt->num_rows>0)
++++{
++++++++$result+=+array();
++++++++$md+=+$stmt->result_metadata();
++++++++$params+=+array();
++++++++while($field+=+$md->fetch_field())+{
++++++++++++$params[]+=+&$result[$field->name];
++++++++}
++++++++call_user_func_array(array($stmt,+'bind_result'),+$params);
++++++++if($stmt->fetch())
++++++++++++return+$result;
++++}

++++return+null;
}|code-block|syntax|javascript|2922525|正如您所看到的，它创建了一个数组并使用行数据获取它，因为它在内部使用$stmt->fetch()，所以您可以像调用mysqli_result::fetch_assoc一样调用它(只需确保$stmt对象已打开并存储了结果)：|2922526|//mysqliConnection+is+your+mysqli+connection+object
if($stmt+=+$mysqli_connection->prepare($query))
{
++++$stmt->execute();
++++$stmt->store_result();

++++while($assoc_array+=+fetchAssocStatement($stmt))
++++{
++++++++//do+your+magic
++++}

++++$stmt->close();
}|2922527|entityMap^0|8|T|1L|M|0|0|Y|E|1L|Q|2L|5|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|P|$]]

for those searching for an alternative to <code>$result = $stmt-&gt;get_result()</code> I've made this function which allows you to mimic the <code>$result-&gt;fetch_assoc()</code> but using directly the stmt object:

<pre><code>function fetchAssocStatement($stmt)
{
 if($stmt-&gt;num_rows&gt;0)
 {
 $result = array();
 $md = $stmt-&gt;result_metadata();
 $params = array();
 while($field = $md-&gt;fetch_field()) {
 $params[] = &amp;$result[$field-&gt;name];
 }
 call_user_func_array(array($stmt, 'bind_result'), $params);
 if($stmt-&gt;fetch())
 return $result;
 }

 return null;
}
</code></pre>

as you can see it creates an array and fetches it with the row data, since it uses <code>$stmt-&gt;fetch()</code> internally, you can call it just as you would call <code>mysqli_result::fetch_assoc</code> (just be sure that the <code>$stmt</code> object is open and result is stored):

<pre><code>//mysqliConnection is your mysqli connection object
if($stmt = $mysqli_connection-&gt;prepare($query))
{
 $stmt-&gt;execute();
 $stmt-&gt;store_result();

 while($assoc_array = fetchAssocStatement($stmt))
 {
 //do your magic
 }

 $stmt-&gt;close();
}
</code></pre>

blocks|key|249457|text|这是我的另一个选择。它是object-oriented，更像是mysql/mysqli。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|249458|class+MMySqliStmt{
++++private+$stmt;
++++private+$row;

++++public+function+__construct($stmt){
++++++++$this->stmt+=+$stmt;
++++++++$md+=+$stmt->result_metadata();
++++++++$params+=+array();
++++++++while($field+=+$md->fetch_field())+{
++++++++++++$params[]+=+&$this->row[$field->name];
++++++++}
++++++++call_user_func_array(array($stmt,+'bind_result'),+$params)+or+die('Sql+Error');
++++}

++++public+function+fetch_array(){
++++++++if($this->stmt->fetch()){
++++++++++++$result+=+array();
++++++++++++foreach($this->row+as+$k+=>+$v){
++++++++++++++++$result[$k]+=+$v;
++++++++++++}
++++++++++++return+$result;
++++++++}else{
++++++++++++return+false;
++++++++}
++++}

++++public+function+free(){
++++++++$this->stmt->close();
++++}
}|code-block|syntax|javascript|249459|用法：|249460|$stmt+=+$conn->prepare($str);
//...bind_param...+and+so+on
if(!$stmt->execute())die('Mysql+Query(Execute)+Error+:+'.$str);
$result+=+new+MMySqliStmt($stmt);
while($row+=+$result->fetch_array()){
++++array_push($arr,+$row);
++++//for+example,+use+$row['id']
}
$result->free();
//for+example,+use+the+$arr|249461|entityMap^0|C|F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Here is my alternative. It is object-oriented and is more like mysql/mysqli things.

<pre><code>class MMySqliStmt{
 private $stmt;
 private $row;

 public function __construct($stmt){
 $this-&gt;stmt = $stmt;
 $md = $stmt-&gt;result_metadata();
 $params = array();
 while($field = $md-&gt;fetch_field()) {
 $params[] = &amp;$this-&gt;row[$field-&gt;name];
 }
 call_user_func_array(array($stmt, 'bind_result'), $params) or die('Sql Error');
 }

 public function fetch_array(){
 if($this-&gt;stmt-&gt;fetch()){
 $result = array();
 foreach($this-&gt;row as $k =&gt; $v){
 $result[$k] = $v;
 }
 return $result;
 }else{
 return false;
 }
 }

 public function free(){
 $this-&gt;stmt-&gt;close();
 }
}
</code></pre>

Usage:

<pre><code>$stmt = $conn-&gt;prepare($str);
//...bind_param... and so on
if(!$stmt-&gt;execute())die('Mysql Query(Execute) Error : '.$str);
$result = new MMySqliStmt($stmt);
while($row = $result-&gt;fetch_array()){
 array_push($arr, $row);
 //for example, use $row['id']
}
$result-&gt;free();
//for example, use the $arr
</code></pre>

blocks|key|248203|text|我意识到已经有一段时间没有关于这个问题的任何新的活动了。但是，正如其他发帖者评论的那样-+get_result()现在只能通过安装MySQL本机驱动程序(+mysqlnd+)在PHP中使用，在某些情况下，安装mysqlnd可能是不可能或不可取的。因此，我认为在不使用get_result()的情况下，将这个答案与如何获得get_result()提供的功能的信息一起发布会很有帮助。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|248204|get_result()通常与fetch_array()结合使用，以遍历结果集，并将结果集每一行的值存储在一个数字索引或关联数组中。例如，下面的代码使用get_result()和fetch_array()遍历结果集，将每行中的值存储在按数字索引的$data[]数组中：|248205|$c=1000;
$sql="select+account_id,+username+from+accounts+where+account_id<?";
$stmt+=+$mysqli->prepare($sql);+++++++++++++++++
$stmt->bind_param('i',+$c);+++++++++++++++++++++++++++++++++++++++++++++
$stmt->execute();
$result+=+$stmt->get_result();+++++++
while($data+=+$result->fetch_array(MYSQLI_NUM))+{
+++print+$data[0]+.+',+'+.+$data[1]+.+" \n";+
}|code-block|syntax|javascript|248206|但是，如果get_result()不可用(因为没有安装mysqlnd+)，那么就会产生一个问题，即如何在不使用get_result()的情况下将结果集每一行的值存储在数组中。或者，如何迁移使用get_result()的遗留代码，以便在不使用它的情况下运行(例如，使用bind_result()+)-同时尽可能减少对其余代码的影响。|248207|事实证明，使用bind_result()在数字索引数组中存储每行中的值并不那么简单。bind_result()需要一个标量变量列表(而不是数组)。因此，它需要做一些工作才能使其将结果集每一行的值存储在一个数组中。|248208|当然，代码可以很容易地修改如下：|248209|$c=1000;
$sql="select+account_id,+username+from+accounts+where+account_id<?";
$stmt+=+$mysqli->prepare($sql);+++++++++++++++++
$stmt->bind_param('i',+$c);+++++++++++++++++++++++++++++++++++++++++++++
$stmt->execute();
$stmt->bind_result($data[0],+$data[1]);
while+($stmt->fetch())+{
+++print+$data[0]+.+',+'+.+$data[1]+.+" \n";+
}|248210|但是，这需要我们在对bind_result()的调用中分别显式列出$data、$data1等，这并不理想。我们想要一个解决方案，它不需要我们在调用bind_results()时显式地列出$data，$data1，...+$dataN-1。如果我们正在迁移具有大量查询的遗留应用程序，并且每个查询在select子句中可能包含不同数量的字段，则如果我们使用类似上面的解决方案，则迁移将非常费力且容易出错。|248211|理想情况下，我们需要一个“插入式替换”代码片段--只替换下一行中包含get_result()函数和while()循环的那一行。替换代码应该与要替换的代码具有相同的功能，而不影响前面的任何行，也不影响后面的任何行-包括while()循环中的行。理想情况下，我们希望替换代码尽可能紧凑，并且我们不希望根据查询的select子句中的字段数量对替换代码进行泰勒处理。|248212|在互联网上搜索，我发现了许多使用bind_param()和call_user_func_array()的解决方案(例如，Dynamically+bind+mysqli_stmt+parameters+and+then+bind+result+(PHP))，但我找到的大多数解决方案最终导致结果存储在关联数组中，而不是数字索引数组中，并且这些解决方案中的许多并不像我希望的那样紧凑，和/或不适合作为“插入式替换”。然而，从我发现的示例中，我能够拼凑出这个解决方案，它符合要求：|248213|$c=1000;
$sql="select+account_id,+username+from+accounts+where+account_id<?";
$stmt+=+$mysqli->prepare($sql);+++++++++++++++++
$stmt->bind_param('i',+$c);+++++++++++++++++++++++++++++++++++++++++++++
$stmt->execute();
$data=array();
for+($i=0;$i<$mysqli->field_count;$i%2B%2B)+{+
++++$var+=+$i;
++++$$var+=+null;+
++++$data[$var]+=+&$$var;+
}
call_user_func_array(array($stmt,'bind_result'),+$data);
while+($stmt->fetch())+{
+++print+$data[0]+.+',+'+.+$data[1]+.+" \n";+
}|248214|当然，可以将for()循环压缩成一行以使其更紧凑。|248215|我希望这能帮助那些正在寻找使用bind_result()在数字索引数组中存储每一行中的值和/或寻找使用get_result()迁移遗留代码的方法的人。欢迎评论。|248216|entityMap|0|LINK|mutability|MUTABLE|url|where+N+is+the+number+of+fields+in+the+select+statement|1|https://stackoverflow.com/questions/5300365/dynamically-bind-mysqli-stmt-parameters-and-then-bind-result-php^0|19|C|3P|C|4G|C|0|0|C|F|D|0|0|5|C|1J|C|2O|C|3P|D|0|7|D|16|D|0|0|0|A|D|21|E|44|6|37|3|0|0|Y|C|49|6|0|G|C|T|M|1O|1U|1|0|0|0|F|D|1F|C|0^^$0|@$1|2|3|4|5|6|7|1G|8|@$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]|$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1N|8|@$9|1O|A|1P|B|C]|$9|1Q|A|1R|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1S|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1T|8|@$9|1U|A|1V|B|C]|$9|1W|A|1X|B|C]|$9|1Y|A|1Z|B|C]|$9|20|A|21|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|22|8|@$9|23|A|24|B|C]|$9|25|A|26|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|27|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|28|8|@]|D|@]|E|$K|L]]|$1|U|3|V|5|6|7|29|8|@$9|2A|A|2B|B|C]|$9|2C|A|2D|B|C]|$9|2E|A|2F|B|C]]|D|@$9|2G|A|2H|1|2I]]|E|$]]|$1|W|3|X|5|6|7|2J|8|@$9|2K|A|2L|B|C]|$9|2M|A|2N|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|2O|8|@$9|2P|A|2Q|B|C]|$9|2R|A|2S|B|C]]|D|@$9|2T|A|2U|1|2V]]|E|$]]|$1|10|3|11|5|J|7|2W|8|@]|D|@]|E|$K|L]]|$1|12|3|13|5|6|7|2X|8|@]|D|@]|E|$]]|$1|14|3|15|5|6|7|2Y|8|@$9|2Z|A|30|B|C]|$9|31|A|32|B|C]]|D|@]|E|$]]|$1|16|3|-4|5|6|7|33|8|@]|D|@]|E|$]]]|17|$18|$5|19|1A|1B|E|$1C|1D]]|1E|$5|19|1A|1B|E|$1C|1F]]]]

I realize that it's been a while since there has been any new activity on this question. But, as other posters have commented - <code>get_result()</code> is now only available in PHP by installing the MySQL native driver (mysqlnd), and in some cases, it may not be possible or desirable to install mysqlnd. So, I thought it would be helpful to post this answer with info on how get the functionality that <code>get_result()</code> offers - without using <code>get_result()</code>.

<code>get_result()</code> is/was often combined with <code>fetch_array()</code> to loop through a result set and store the values from each row of the result set in a numerically-indexed or associative array. For example, the code below uses get_result() with fetch_array() to loop through a result set, storing the values from each row in the numerically-indexed $data[] array:

<pre><code>$c=1000;
$sql="select account_id, username from accounts where account_id&lt;?";
$stmt = $mysqli-&gt;prepare($sql); 
$stmt-&gt;bind_param('i', $c); 
$stmt-&gt;execute();
$result = $stmt-&gt;get_result(); 
while($data = $result-&gt;fetch_array(MYSQLI_NUM)) {
 print $data[0] . ', ' . $data[1] . "&lt;BR&gt;\n"; 
}
</code></pre>

However, if <code>get_result()</code> is not available (because mysqlnd is not installed), then this leads to the problem of how to store the values from each row of a result set in an array, without using <code>get_result()</code>. Or, how to migrate legacy code that uses <code>get_result()</code> to run without it (e.g. using <code>bind_result()</code> instead) - while impacting the rest of the code as little as possible.

It turns out that storing the values from each row in a numerically-indexed array is not so straight-forward using <code>bind_result()</code>. <code>bind_result()</code> expects a list of scalar variables (not an array). So, it takes some doing to make it store the values from each row of the result set in an array.

Of course, the code could easily be modified as follows:

<pre><code>$c=1000;
$sql="select account_id, username from accounts where account_id&lt;?";
$stmt = $mysqli-&gt;prepare($sql); 
$stmt-&gt;bind_param('i', $c); 
$stmt-&gt;execute();
$stmt-&gt;bind_result($data[0], $data[1]);
while ($stmt-&gt;fetch()) {
 print $data[0] . ', ' . $data[1] . "&lt;BR&gt;\n"; 
}
</code></pre>

But, this requires us to explicitly list $data[0], $data[1], etc. individually in the call to <code>bind_result()</code>, which is not ideal. We want a solution that doesn't require us to have to explicitly list $data[0], $data[1], ... $data[N-1] (where N is the number of fields in the select statement) in the call to <code>bind_results()</code>. If we're migrating a legacy application that has a large number of queries, and each query may contain a different number of fields in the <code>select</code> clause, the migration will be very labor intensive and prone to error if we use a solution like the one above.

Ideally, we want a snippet of 'drop-in replacement' code - to replace just the line containing the <code>get_result()</code> function and the while() loop on the next line. The replacement code should have the same function as the code that it's replacing, without affecting any of the lines before, or any of the lines after - including the lines inside the while() loop. Ideally we want the replacement code to be as compact as possible, and we don't want to have to taylor the replacement code based on the number of fields in the <code>select</code> clause of the query.

Searching on the internet, I found a number of solutions that use <code>bind_param()</code> with <code>call_user_func_array()</code>
(for example, <a href="https://stackoverflow.com/questions/5300365/dynamically-bind-mysqli-stmt-parameters-and-then-bind-result-php">Dynamically bind mysqli_stmt parameters and then bind result (PHP)</a>), but most solutions that I found eventually lead to the results being stored in an associative array, not a numerically-indexed array, and many of these solutions were not as compact as I would like and/or were not suited as 'drop-in replacements'. However, from the examples that I found, I was able to cobble together this solution, which fits the bill:

<pre><code>$c=1000;
$sql="select account_id, username from accounts where account_id&lt;?";
$stmt = $mysqli-&gt;prepare($sql); 
$stmt-&gt;bind_param('i', $c); 
$stmt-&gt;execute();
$data=array();
for ($i=0;$i&lt;$mysqli-&gt;field_count;$i++) { 
 $var = $i;
 $$var = null; 
 $data[$var] = &amp;$$var; 
}
call_user_func_array(array($stmt,'bind_result'), $data);
while ($stmt-&gt;fetch()) {
 print $data[0] . ', ' . $data[1] . "&lt;BR&gt;\n"; 
}
</code></pre>

Of course, the for() loop can be collapsed into one line to make it more compact. 

I hope this helps anyone who is looking for a solution using <code>bind_result()</code> to store the values from each row in a numerically-indexed array and/or looking for a way to migrate legacy code using <code>get_result()</code>. Comments welcome.

blocks|key|246558|text|我已经编写了两个简单的函数，它们提供了与$stmt->get_result();相同的功能，但它们不需要mysqlnd驱动程序。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|246559|你只需用替换|BOLD|246560|带有+$fields+=+bindAll($stmt);的$result+=+$stmt->get_result();+|246561|和|246562|$row=+$stmt->get_result();+和+$row+=+fetchRowAssoc($stmt,+$fields);。|246563|(要获得返回的行数，可以使用$stmt->num_rows。)|246564|你只需要把这两个函数放在你的+Script中的某个地方，我已经写了。(例如，就在底部)|246565|function+bindAll($stmt)+{
++++$meta+=+$stmt->result_metadata();
++++$fields+=+array();
++++$fieldRefs+=+array();
++++while+($field+=+$meta->fetch_field())
++++{
++++++++$fields[$field->name]+=+"";
++++++++$fieldRefs[]+=+&$fields[$field->name];
++++}

++++call_user_func_array(array($stmt,+'bind_result'),+$fieldRefs);
++++$stmt->store_result();
++++//var_dump($fields);
++++return+$fields;
}

function+fetchRowAssoc($stmt,+&$fields)+{
++++if+($stmt->fetch())+{
++++++++return+$fields;
++++}
++++return+false;
}|code-block|syntax|javascript|246566|它是如何工作的|246567|我的代码使用$stmt->result_metadata();函数来确定返回了多少和哪些字段，然后自动将获取的结果绑定到预先创建的引用。就像一种护身符！|246568|entityMap^0|K|K|0|4|2|0|3|P|T|U|0|0|1|0|0|Q|R|1|T|12|0|Q|T|11|0|0|V|E|F|0|0|E|X|A|0|0|0|7|0|0|24|6|P|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@$9|17|A|18|B|H]]|D|@]|E|$]]|$1|I|3|J|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|K|3|L|5|6|7|1E|8|@$9|1F|A|1G|B|H]]|D|@]|E|$]]|$1|M|3|N|5|6|7|1H|8|@$9|1I|A|1J|B|H]|$9|1K|A|1L|B|H]|$9|1M|A|1N|B|H]|$9|1O|A|1P|B|C]|$9|1Q|A|1R|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1S|8|@$9|1T|A|1U|B|H]|$9|1V|A|1W|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1X|8|@$9|1Y|A|1Z|B|H]|$9|20|A|21|B|H]]|D|@]|E|$]]|$1|S|3|T|5|U|7|22|8|@]|D|@]|E|$V|W]]|$1|X|3|Y|5|6|7|23|8|@$9|24|A|25|B|H]]|D|@]|E|$]]|$1|Z|3|10|5|6|7|26|8|@$9|27|A|28|B|H]|$9|29|A|2A|B|C]]|D|@]|E|$]]|$1|11|3|-4|5|6|7|2B|8|@]|D|@]|E|$]]]|12|$]]

I have written two simple functions that give the same functionality as <code>$stmt-&gt;get_result();</code>, but they don't require the mysqlnd driver.

You simply replace

<code>$result = $stmt-&gt;get_result();</code> with <code>$fields = bindAll($stmt);</code> 

and 

<code>$row= $stmt-&gt;get_result();</code> with <code>$row = fetchRowAssoc($stmt, $fields);</code>.

(To get the numbers of returned rows you can use <code>$stmt-&gt;num_rows</code>.)

You just have to place these two functions I have written somewhere in your PHP Script. (for example right at the bottom)

<pre><code>function bindAll($stmt) {
 $meta = $stmt-&gt;result_metadata();
 $fields = array();
 $fieldRefs = array();
 while ($field = $meta-&gt;fetch_field())
 {
 $fields[$field-&gt;name] = "";
 $fieldRefs[] = &amp;$fields[$field-&gt;name];
 }

 call_user_func_array(array($stmt, 'bind_result'), $fieldRefs);
 $stmt-&gt;store_result();
 //var_dump($fields);
 return $fields;
}

function fetchRowAssoc($stmt, &amp;$fields) {
 if ($stmt-&gt;fetch()) {
 return $fields;
 }
 return false;
}
</code></pre>

How it works:

My code uses the <code>$stmt-&gt;result_metadata();</code> function to figure out how many and which fields are returned and then automatically binds the fetched results to pre-created references. Works like a charm!

blocks|key|2922624|text|我在我的服务器上得到了同样的错误--已经启用了mysqlnd扩展的PHP7.0。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2922625|我的解决方案(感谢this+page)是取消选择mysqli扩展，而选择nd_mysqli。|2922626|注意-您可以访问cPanel中的分机选择器。(我是通过Select+PHP+Version选项访问我的。)|2922627|entityMap|0|LINK|mutability|MUTABLE|url|https://www.sitepoint.com/community/t/how-to-enable-mysqli-api-extension-for-mysqlnd/216897^0|N|7|0|O|6|10|9|9|9|0|0|R|I|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|H|3|I|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

I was getting this same error on my server - PHP 7.0 with the mysqlnd extension already enabled.

Solution was for me (thanks to <a href="https://www.sitepoint.com/community/t/how-to-enable-mysqli-api-extension-for-mysqlnd/216897" rel="noreferrer">this page</a>) was to deselect the mysqli extension and select nd_mysqli instead.

NB - You may be able to access the extensions selector in your cPanel. (I access mine via the Select PHP Version option.)

blocks|key|249495|text|在PHP7.2版本中，我只使用了nd_mysqli，而不是mysqli，它的工作效果与预期一致。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|249496|将其启用到godaddy托管服务器的步骤-|249497|249498|登录到cpanel。|ordered-list-item|249499|点击“选择PHP提供的最新配置的快照”取消选中“|249500|”并启用cpanel|249501|​|249502|📷|atomic|249503|249504|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4de5c04063d0518d99ad0894e7533d9f.png|imageAlt^0|G|9|T|6|0|0|0|0|2|M|0|0|A|0|0|1|0|0|1|0|1|0|0|0|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]|$9|17|A|18|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|19|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|1B|8|@]|D|@]|E|$]]|$1|L|3|M|5|K|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|1F|8|@$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1I|8|@$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|R|3|S|5|T|7|1L|8|@$9|1M|A|1N|B|C]]|D|@$9|1O|A|1P|1|1Q]]|E|$]]|$1|U|3|Q|5|6|7|1R|8|@$9|1S|A|1T|B|C]]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1U|8|@]|D|@]|E|$]]]|W|$X|$5|Y|Z|10|E|$11|12|13|-4]]]]

With PHP version 7.2 I just used nd_mysqli instead of mysqli and it worked as expected.

Steps to enable it into godaddy hosting server-

<ol>
<li>Login to cpanel.</li>
<li>Click on "Select PHP version".</li>
<li>As provided the snapshot of the latest configurations uncheck "mysqli" and enable "nd_mysqli".</li>
</ol>

<a href="https://i.stack.imgur.com/iL63K.png" rel="noreferrer"><img src="https://i.stack.imgur.com/iL63K.png" alt="enter image description here"></a>

Here's my code:

<pre><code>include 'conn.php';
$conn = new Connection();
$query = 'SELECT EmailVerified, Blocked FROM users WHERE Email = ? AND SLA = ? AND `Password` = ?';
$stmt = $conn-&gt;mysqli-&gt;prepare($query);
$stmt-&gt;bind_param('sss', $_POST['EmailID'], $_POST['SLA'], $_POST['Password']);
$stmt-&gt;execute();
$result = $stmt-&gt;get_result();
</code></pre>

I get the error on last line as: Call to undefined method mysqli_stmt::get_result()

Here is the code for conn.php:

<pre><code>define('SERVER', 'localhost');
define('USER', 'root');
define('PASS', 'xxxx');
define('DB', 'xxxx');
class Connection{
 /**
 * @var Resource 
 */
 var $mysqli = null;

 function __construct(){
 try{
 if(!$this-&gt;mysqli){
 $this-&gt;mysqli = new MySQLi(SERVER, USER, PASS, DB);
 if(!$this-&gt;mysqli)
 throw new Exception('Could not create connection using MySQLi', 'NO_CONNECTION');
 }
 }
 catch(Exception $ex){
 echo "ERROR: ".$e-&gt;getMessage();
 }
 }
}
</code></pre>

If I write this line: 

<pre><code>if(!stmt) echo 'Statement prepared'; else echo 'Statement NOT prepared';
</code></pre>

It prints 'Statement NOT prepared'. If I run the query directly in the IDE replacing ? marks with values, it works fine. Please note that $conn object works fine in other queries in the project.

Any help please.......

Call to undefined method mysqli_stmt::get_result

服务器

Ubuntu

Debian

MySQL

下面是我的代码：include 'conn.php';$conn = new Connection();$query = 'SELECT EmailVerified, Blocked FROM users WHERE Email = ? AND SLA = ? AND `Password` = ?';$stmt = $...

问调用未定义的方法mysqli_stmt::get_result
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问调用未定义的方法mysqli_stmt::get_resultEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问调用未定义的方法mysqli_stmt::get_result
EN