如何在mysqli中执行mysql_fetch_assoc? [英] How to do mysql_fetch_assoc in mysqli?
本文介绍了如何在mysqli中执行mysql_fetch_assoc?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在mysqli prepare语句中执行以下操作?
How can I do the following in mysqli prepare statement?
$result = mysql_query($sql);
$data = mysql_fetch_assoc($result);
return $data:
推荐答案
在某些地方创建与mysql的连接之后,这很简单:
That's pretty simple after you've created the connection to mysql somewhere:
<?php
// create the connection to mysql.
$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db');
?>
当您需要执行查询或执行其他操作时,引用mysqli对象.
The refer to the mysqli object when you need to do a query or do something else.
<?php
// get the result object.
$result = $mysqli->query($sql);
// fetch the result row.
$data = $result->fetch_assoc();
return $data;
?>
然后在某个时候(如果您有一个类,可以编写一个析构函数),如果不再需要它,则应关闭与mysql的连接.
Then at some point (if you have a class, you can write a destructor) you should close the connection to mysql if you won't need it anymore.
<?php
$mysqli->kill($mysqli->thread_id);
$mysqli->close();
?>
您可以对拥有的结果对象做更多的事情.
因此,请在此处详细了解MySQLi_Result
:
You can do much more with the result object you have.
So read more about the MySQLi_Result
here:
这篇关于如何在mysqli中执行mysql_fetch_assoc?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文