코드이그나이터 쿼리

코드이그나이터 쿼리

데이터의 row count

$where = "grp_idx=".$grp_idx." and u_id='".$u_id."' and c_expire_date >= date_add(now(), interval -600 minute)"; $this->db->where($where); $this->db->from($this->certify_table); $certify_cnt = $this->db->count_all_results();

실행 쿼리 문자열 반환

print_r($this->db->last_query());

join의 예

$this->db->select("A.*, B.g_img"); $this->db->where('A.grp_idx', $grp_idx); $this->db->where('A.g_pack_idx', $row->idx); $this->db->from($this->goods_inout_detail_table." AS A"); $this->db->join($this->goods_table." AS B", 'A.g_barcode = B.g_barcode'); $this->db->order_by('A.idx', 'DESC'); $query2 = $this->db->get(); foreach ($query2->result() as $row2) { echo $row2->idx }

from http://devlink.tistory.com/451 by ccl(A) rewrite - 2021-01-05 21:00:40