如何在Codeigniter中使用MySQLi驱动程序 [英] How to use MySQLi Driver in Codeigniter

问题描述

您好，我很喜欢这个，我想问一个在这里的人是codeigniter框架和PHP的专家。

Hi I'm kinda new to this and I would like to ask someone here that are experts in codeigniter framework and PHP.

如何使用mysqli驱动程序php原生查询？例如

How can I use mysqli drivers in php native query? For example.

我的代码：

模型

class Home_model extends CI_Model{

public function getusers(){
$q = "SELECT * FROM `users`";
return $r = mysqli_query($q);
}

}

控制器：

class Home extends CI_Controller{
public function iterateuser(){
while($row = mysqli_fetch_object($this->Home_model->getusers())){
echo $row->username;
}

}

上面的代码是一个错误，报告说mysqli_query期望至少2个参数。在codeigniter中有一种方法传递mysqli_query（）第一个参数的链接，如php.net文档 http://php.net/manual/en/mysqli.query.php

My code above is an error, report saying "mysqli_query expects at least 2 parameters". Is there a way in codeigniter to pass the link on the mysqli_query() first parameter as described on the php.net documentation http://php.net/manual/en/mysqli.query.php

推荐答案

转到：

yourproject/application/config/database.php

更改：

$db['default']['dbdriver'] = 'mysql';   

其中：

$db['default']['dbdriver'] = 'mysqli';

这篇关于如何在Codeigniter中使用MySQLi驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！