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()

Comments

  1. 最近剛摸索CI,有些不明白怎做.
    版主是否能解說一下,Codeigniter 如何寫多條件搜尋 ? 怎讓 pagination 帶上 query string .

    • 網站有教學喔:https://codeigniter.org.tw/userguide3/database/query_builder.html
      或是參考原文對照:https://www.codeigniter.com/user_guide/database/query_builder.html

發表迴響