数据库where里条件问题???急求

浏览:3521 发布日期:2014/04/19 分类:求助交流
原版:$card=M('Member_card_create')->field('id,number')->where("token='".$this->_get('token')." and wecha_id = ' '")->find();
修改后:
$card=M('Member_card_create')->field('id,number')->where("token='".$this->_get('token')."and cardid='".$this->_get('cardid')."' and wecha_id = ' '")->find();

多了一个条件 就是字段cardid等于获取url里的cardid,但是一这样写 就查不到数据了?

现在改写法了,第60行 获取不到数据?(数据库有符合条件的数据)

全部代码:<?php
class UserinfoAction extends BaseAction{
    public function index(){
        $agent = $_SERVER['HTTP_USER_AGENT'];
        //if(!strpos($agent,"MicroMessenger")) {
            //echo '此功能只能在微信浏览器中使用';exit;
        //}
        //$cardid2=$_GET['cardid'];
        $card = D('Member_card_create'); 
        $data['wecha_id']=$this->_get('wecha_id');
        $data['token']=$this->_get('token');
        $data['cardid']=$this->_get('cardid');
        
        $cardinfo=$card->where($data)->find(); //是否领取过

            

        $sql=D('Userinfo');
        $userinfo=$sql->where($data)->find();
        $member=M('Member')->where(array('token'=>$data['token']))->find();
        if($memboer['hoempic']!=false){
            $img=$member['homepic'];            
        }else{
            $img='tpl/Wap/default/common/images/userinfo/fans.jpg';
        }
        $this->assign('cardnum',$cardinfo['number']);
        $this->assign('homepic',$img);
        $this->assign('info',$userinfo);
        if(IS_POST){
            
            //如果有post提交,说明是修改
            $data['wechaname'] = $this->_post('wechaname');
            $data['tel']       = $this->_post('tel');
            if(empty($data['wechaname']) || empty($data['tel'])){
                $this->error("微信号或手机号必填。");exit;
            }

            $data['truename']  = $this->_post('truename');            
            $data['qq']  = $this->_post('qq');
            $data['sex'] = $this->_post('sex');
            $data['age'] = $this->_post('age');
             //如果会员卡不为空[更新]
             //写入两个表 Userinfo Member_card_create 
            if($cardinfo){ //如果Member_card_create 不为空,说明领过卡,但是可以修改会员信息
                $update['wecha_id']=$data['wecha_id'];
                $update['token']=$data['token'];
                unset($data['wecha_id']);
                unset($data['token']);
                if(M('Userinfo')->where($update)->save($data)){
                    echo 1;exit;
                }else{
                    echo 0;exit;
                }
            }else{
                //还没有会员卡,领卡
                
                 $where['token']=$this->_get('token');
                 $where['cardid']=$this->_get('cardid');
                 $where['wecha_id']=' ';
                $card=M('Member_card_create')->field('id,number')->where($where)->find();
                //如果商家还有会员卡,可以领
                    if($card != false){
                        //微信与会员卡绑定
                        $card_up=M('Member_card_create')->where(array('id'=>$card['id']))->save(array('number'=>$card['number'],'cardid'=>$data['cardid'],'wecha_id'=>$data['wecha_id']));
                        //写入会员卡信息
                        $data['token'] = $this->_get('token');
                        $data['getcardtime'] = time();
                        M('Userinfo')->data($data)->add();
                        echo 2;exit;
                    }else{
                        //商家没有了会员卡
                        
                        $token=M('wxuser')->field('uid')->where(array('token'=>$this->_get('token')))->find();
                        
                    //    M('Users')->where(array('id'=>$token['uid']))->setField(array('card_create_status'=>0));//?????
                        echo 3;exit;
                    }                 
            } //post 





        } 

        $this->display();    
最佳答案
评论() 相关
后面还有条评论,点击查看>>