ɸѡÆäʵºÜ¼òµ¥£¬¾ÍÊÇÈ·¶¨ºÃ ɸѡÌõ¼þ ºÍ url´«²Î£¬
ÓóÌÐòµÄÓïÑÔÀ´Ëµ£¬¾ÍÊÇÈ·¶¨ºÃ $where ºÍ $cid£¬¾Í¿ÉÒÔ ÁË
Àý×Ó¢Ù£º
¸ù¾ÝÈçÉÏ·½Ê½É¸Ñ¡£º1.ÉÌÆÌÃû³Æ Ä£ºý²éѯ£»2ÉóºËÓÐËÄÖÖÌõ¼þ£º0 ÇëÑ¡Ôñ£¬1´ýÉóºË£¬2ÉóºËͨ¹ý£¬3ÉóºËδͨ¹ý£»3ÉÌÆÌ״̬Ϊ1£¨¿ªÆô£©¡£
Âú×ãÌõ¼þ·ÖÎö£ºÉÌÆÌ״̬±ØÐëΪ1.ÉÌÆÌÃû³ÆÎª¿Õ£¬ÉóºËÊÇ“ÇëÑ¡Ôñ”ʱ£¬½«ÏÔʾȫ²¿¡£
¾ßÌå¿ØÖÆÆ÷·½·¨ÈçÏ£º
public function index(){
$Store = M('store');
$condition = '';
$store_name =I('post.store_name');//½ÓÊÕÉÌÆÌÃû³Æ
$audit =intval(I('post.audit'));//½ÓÊÕÉóºË״̬
/*ɸѡÌõ¼þÅжÏ*/
if($store_name){
$map['store_name'] =array('like',"%".$store_name."%");//like Ìõ¼þÅжÏ
}
if($audit){
$map['is_audit'] =$audit;//ÉóºË״̬
}
$map['store_state'] = 1;//±ØÑ¡Ìõ¼þ
$storelist =$Store->where($map)->select();//¸ù¾ÝÌõ¼þɸѡ
$this->assign('storelist',$storelist);// ¸³ÖµÊý¾Ý¼¯
}
·ÖÎö£ºÊ¹ÓÃ$mapµÄºÃ´¦Êǵ±ÆäÖÐÒ»¸öÌõ¼þΪ¿Õʱ£¬Ö±½Ó²éѯÆäËûÌõ¼þ¡£Ï൱ÓÚ SQLÓï¾äÖÐ ×Ö¶Î is null¡£ÈçÓÃifÓï¾äÅжϣ¬´úÂë»á·Ç³£·±Ëö¡£