php – Codeigniter – Query Builder Class 快速檢視表
欄位
$this->db->get()
$this->db->get_compiled_select()
$this->db->get_where()
$this->db->select()
$this->db->select_max()
$this->db->select_min()
$this->db->select_avg()
$this->db->select_sum()
從哪個資料表
$this->db->from()
$this->db->join()
條件
$this->db->where()
$this->db->or_where()
$this->db->where_in()
$this->db->or_where_in()
$this->db->where_not_in()
$this->db->or_where_not_in()
$this->db->like()
$this->db->or_like()
$this->db->not_like()
$this->db->or_not_like()
$this->db->group_by()
$this->db->distinct()
$this->db->having()
$this->db->or_having()
$this->db->order_by()
數量
$this->db->limit()
$this->db->count_all_results()
$this->db->count_all()
分組
$this->db->group_start()
$this->db->or_group_start()
$this->db->not_group_start()
$this->db->or_not_group_start()
$this->db->group_end()
新增
$this->db->insert()
$this->db->get_compiled_insert()
$this->db->insert_batch()
修改
$this->db->replace()
$this->db->set()
$this->db->update()
$this->db->update_batch()
$this->db->get_compiled_update()
刪除
$this->db->delete()
$this->db->empty_table()
$this->db->truncate()
$this->db->get_compiled_delete()
緩存
$this->db->start_cache()
$this->db->stop_cache()
$this->db->flush_cache()
zyx
2017-04-07 - 05:08
最近剛摸索CI,有些不明白怎做.
版主是否能解說一下,Codeigniter 如何寫多條件搜尋 ? 怎讓 pagination 帶上 query string .
JSN
2017-04-14 - 16:26
網站有教學喔:https://codeigniter.org.tw/userguide3/database/query_builder.html
或是參考原文對照:https://www.codeigniter.com/user_guide/database/query_builder.html