CodeIgniter - db active record常用指令

• basic
  
  • 取得config中，名為group_one的db

    $DB1 = $this->load->database('group_one', TRUE); //給true才會產生實體給$DB1
    $this->db->select('title')->from('mytable')->where('id', $id)->limit(10, 20);
    

    p.s. 給true才會回傳個db object
  • 取sql string
    • last_query()
      執行的過程中，最後的一個sql query string
    • _compile_select()
      目前sql條件的sql query string，尚未實際執行
• select

  $this->db->select('title, content, date'); //不下的話就是*
  $query = $this->db->get('mytable');
  foreach ($query->result() as $row)
  {
      echo $row->title;
  }
  

• from、join

  $this->db->from('mytable');

  $this->db->select('*');
  $this->db->from('blogs');
  $this->db->join('comments', 'comments.id = blogs.id');
  
  $query = $this->db->get();
  
  // Produces:
  // SELECT * FROM blogs
  // JOIN comments ON comments.id = blogs.id

• where 

  //法1.
  $query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);
  $this->db->or_where('id >', $id);  // Produces: WHERE name != 'Joe' OR id > 50
  
  //法2
  $this->db->select('title')->from('mytable')->where('id', $id);
  

• insert
新增欄位為now()的方法

$data = array (
   'customer_id'=> $customer_id,
   'total' => $totalprice
  );
  $this->db->set('order_date', 'NOW()', FALSE);
  $this->db->insert('omc_orders', $data);

Reference

• Connecting to your Database
• Active Record Class