codeigniter 3上的Mysqli驱动程序无法正常工作[关闭]

Question

In CodeIgniter version 3.0, DB Driver "mysql" is deprecated, and the new recommended driver for MySql is "mysqli".

But my queries don't work when I use mysqli, and when I switch back to "mysql" driver an error is displayed:

A PHP Error was encountered
Severity: 8192

Message: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Filename: mysql/mysql_driver.php
Line Number: 136

...

Answer 1

Switch back to mysqli and use this SQL

SELECT
users.`id`
FROM `users`
WHERE
users.`name` = "ronaldob" AND
users.`password` = "123"

I usually use `` quotes and that helps alot avoiding SQL keywords , see a complete MySQL keyword list here

https://dev.mysql.com/doc/refman/5.0/en/keywords.html

Hope that helps