ci mysqli和mysql_如何在Codeigniter中使用MySQLi驱动程序

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

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

My code:

Model

class Home_model extends CI_Model{

public function getusers(){

$q = "SELECT * FROM `users`";

return $r = mysqli_query($q);

}

}

Controller:

class Home extends CI_Controller{

public function iterateuser(){

while($row = mysqli_fetch_object($this->Home_model->getusers())){

echo $row->username;

}

}

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

解决方案

go to:

yourproject/application/config/database.php

change:

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

with:

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