How can you run a mysqli query with CodeIgniter?

Question

Hello guys,

Does anyone have a clue how to run a mysqli query with CI. I did change the db driver in the config file, but I'm still unable to use multiple queries like

$sql = "SELECT * FROM c WHERE 1;
        DROP TABLE IF EXISTS c;"
$query = $this->db->query($sql);

Anyone has any clue how to do this using only CI, no additional libraries, because theoretically CI supports mysqli.

Thanks

Answer 1

Just check the below link and see if it solves your problem -

http://codeigniter.com/forums/viewthread/94796/