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 arrayfunction json_obj2array($json_obj){	$json_str = json_encode($json_obj);	$json_array = json_decode($json_str,true);	return $json_array;}

$result_array中就是以数组的形式保存着返回的数据

版权声明：本文为博主原创文章，未经博主允许不得转载。