thinkphpÌõ¼þɸѡ Àý×Ó

ɸѡÆäʵºÜ¼òµ¥£¬¾ÍÊÇÈ·¶¨ºÃ   É¸Ñ¡Ìõ¼þ  ºÍ  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Óï¾äÅжÏ£¬´úÂë»á·Ç³£·±Ëö¡£