codeigniter 操作mysql的PHP代码--更新_MySQL

CI框架

1）查询不等于且有等于

$this->db->get_where('host',array('host'=>'ddd','id !='=>0))->row();

2）2表相交

return $this->db	->select('f.*,count(s.id) as subtotal')	->from('category as f')->join('category s', 'f.id=s.upid', 'left')	->where('f.upid', $upid)	->group_by('f.id')	->order_by('f.sort', 'asc')	->get()->result();

3）多个order_by 排序

return $this->db->select('*')	->from('v_category')	->where('upid',$upid)	->order_by('sort','asc')	->order_by('id','desc')	->get()->result();

4）单条记录

return $this->db->get_where('category', array('id' => $id))->row();

5）多条记录

return $this->db->get_where('v_category', array('upid' => $upid))->result();

更多稍后补充，转载请注明来自 default7#zbphp.com，欢迎交流。