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 `id` = '123456'";
$sql = "DELETE FROM table_name WHERE `id` = '123456'";
$sql = "SELECT * FROM table_name WHERE `status` = 1";
$query = $this->db->query($sql);
$result = $query->result();
4、判断查询是否成功
select的时候
if($query->num_rows()>=0){
//query success
}else{
//query failed
}
insert、delete、update的时候
if($this->db->affected_rows()>0){
//query success
}else{
//query failed
}
5、处理select返回的数据
$result_obj = $result;
$result_array = json_obj2array($result_obj);
// json object 转成 json array
function json_obj2array($json_obj){
$json_str = json_encode($json_obj);
$json_array = json_decode($json_str,true);
return $json_array;
}
$result_array中就是以数组的形式保存着返回的数据
版权声明:本文为博主原创文章,未经博主允许不得转载。