沃梦达 / 编程问答 / php问题 / 正文

如何在mysqli中做mysql_fetch_assoc?

How to do mysql_fetch_assoc in mysqli?(如何在mysqli中做mysql_fetch_assoc?)

本文介绍了如何在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:

  • http://www.php.net/manual/en/class.mysqli-result.php

这篇关于如何在mysqli中做mysql_fetch_assoc?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:如何在mysqli中做mysql_fetch_assoc?

基础教程推荐