修改后:
$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(); 最佳答案