1、配置数据库连接
/application/config/database.php
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'info_system';//连接的数据库名字
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;//改成false,能自动断开数据库
2、连接数据库(在controller文件中连接)
$this->load->database();
3、数据库查询
$sql = "INSERT INTO table_name (id, name, status) VALUES('123456','me',1)";
$sql = "UPDATE table_name SET `status` = 0 WHERE