class Data extends CI_Controller
{
function index()
{
echo 'Hwllo DBer';
}
//多结果标准查询(对象形式)
function select()
{
$this->load->database();
$query = $this->db->query("SELECT * FROM test");
foreach($query->result() as $row)
{
echo $row->title."----";
echo $row->name."&----";
echo $row->email."<br>";
}
echo 'Total Results:'.$query->num_rows();
}
//多结果标准查询(数组形式)
function select_array(){
$this->load->database();
$query = $this->db->query("SELECT * FROM test");
foreach($query->result_array() as $row){
echo $row['title']."----";
echo $row['name']."&----";
echo $row['email']."<br>";
}
}
//但结果标准查询(对象形式)
function select_one($id=1)
{
$this->load->database();
$query = $this->db->query("SELECT * FROM test WHERE id=".$id);
$row = $query->row();
echo $row->name;
}
//但结果标准查询(数组形式)
function select_one_array($id=1)
{
$this->load->database();
$query = $this->db->query("SELECT * FROM test WHERE id=".$id);
$row = $query->row_array();
echo $row['name'];
}
//标准插入
function insert($title='',$name='')
{
$this->load->database();
$sql = "INSERT INTO test (title,name) VALUES ('".$title."','".$name."')";
$this->db->query($sql);
echo $this->db->affected_rows();
}
//快捷查询
function select_quick()
{
$this->load->database();
$query = $this->db->get('test');
foreach($query->result() as $row)
{
echo $row->title."<br>";
}
}
//快捷插入
function insert_quick(){
$this->load->database();
$data = array(
'title' => 'Title',
'name' => 'Name',
'email' => 'Email'
);
$this->db->insert('test',$data);
}
/*
Active Record
-------------------------------------------------------------------------------------
选择数据
-------------------------------------------------------------------------------------
$this->db->get('table_name'[,$limit[,$offset]]);
$this->db->get_where('table_name'[,$where[,$limit[,$offset]]]);
$this->db->select();//允许在SQL查询中写SELECT部分
$this->db->select('title,name,email');
$query = $this->db->get('table_name');
$this->db->select_max(field);
$this->db->select_min(field);
$this->db-<select_avg(filed);
$this->db->select_sum(filed);
$this->db->from();
$this->db->join();
$this->db->where();
$this->db->where('name',$name);
$this->db->where('name!=',$name);
$this->db->where(array('name!='=>$name,'title'=>$title));
$this->db->where('names="Joe" AND status="boss"');
$this->db->or_where();
$this->db->where_in('username',array('Frank','Todd','james'));
$this->db->or_where_in();
$this->db->where_not_in();
$this->db->like();
$this->db->like('title','match'[,before|after|both|none]);
$this->db->like(array('title'=>$match,'page'=>$match));
$this->db->or_like();
$this->db->not_like();
$this->db->or_not_like();
$this->db->group_by('title'|array('title','date'));
$this->db->distinct();
$this->db-having('user_id=45' | 'user_id',45); | array('title'=>'sfd','page'=>5);
$this->db->or_having();
$this->db->order_by('title','desc' | 'title desc,name asc');
$this->db->limit($limit[,$offset]);
$this->db->count_all_results('table_name');
-------------------------------------------------------------------------------------
插入数据
-------------------------------------------------------------------------------------
$this->db->insert('table_name',$data_array);
$this->db->insert_batch();
$this->db->set('name',$name[,FALSE|TRUE]);
$this->db->set(array('name'=>name,'title'=>$title));
-------------------------------------------------------------------------------------
更新数据
-------------------------------------------------------------------------------------
$this->db->where('id',$id);
$this->db->update('table_name',$data_array);
$this->db->update_batch();
-------------------------------------------------------------------------------------
删除数据
-------------------------------------------------------------------------------------
$this->db->delete('table_name',array('id'=>$id));
$this->db->empty_table('table_name');/清空
$this->db->from('table_name');//TURNCATE TABLE table_name
$this->db->turncate();
-------------------------------------------------------------------------------------
链式方法
-------------------------------------------------------------------------------------
$this->db->select('title')->from('table_name')->where('id',$id)->limit(10,20);
-------------------------------------------------------------------------------------
Actice Record缓存
-------------------------------------------------------------------------------------
Active Record 允许你将查询的某个特定部分保存(或"缓存")起来,以便在你的脚本执行之后重用。一般情况下,当一次Active Record调用结束,所有已存储的信息都会被重置,以便下一次调用。如果开启缓存,你就可以使信息避免被重置,方便你进行重用。
$this->db->start_cache();
$this->db->stop_cache();
$this->db->flush_cache();
*/
}
Active Record
最新推荐文章于 2022-09-01 21:28:55 发布