WenLiangTseng · July 22, 2013 05:34
diff --git a/codeigniter_mysql_date_judgement.php b/codeigniter_mysql_date_judgement.php
 <?php
 // if you still want to use AR, 
 // you could pass a FALSE as third parameter of 
 // $this->db->where 
 // to avoid automatic escaping by CI:

 $this->db->select('id,name')
         ->where('dr','1')
         ->where('end >=', 'CURDATE()', FALSE);
 $query = $this->db->get('store');
	<?php
	// if you still want to use AR,
	// you could pass a FALSE as third parameter of
	// $this->db->where
	// to avoid automatic escaping by CI:

	$this->db->select('id,name')
	->where('dr','1')
	->where('end >=', 'CURDATE()', FALSE);
	$query = $this->db->get('store');