mysql字段报错请问如何修改正确的字段

Question

<?php
header("Content-type:text/html;charset=utf-8");  
ini_set('date.timezone','Asia/Shanghai');
include_once("../../cfg.php");
@$openId = trim($_GET['openId']);//渠道ID
@$appid = trim($_GET['appid']);
@$pfParam = trim($_GET['pfParam']);
@$serverId = trim($_GET['serverId']);
@$payName = trim($_GET['payName']);
@$itemid = trim($_GET['itemid']);
 
$qufu=$server_list[$serverId];
$qufu_db=$qufu["dbname"];
 
$data = [
    "code"=>"200",
    "msg"=>urlencode ("开通成功"),
];
 
 
@$mysqli = new mysqli($config['host'],$config['root'],$config['pass'],$config['dbname'],$config['port']);
 
//第一步查询用户信息
 
$sql = "SELECT * FROM `h5`.`account` WHERE `id`={$appid} LIMIT 1";
 
$row = $mysqli->query($sql);
if($row && $row->num_rows > 0){
    $ret = $row->fetch_array(1);
    $account=$ret['account'];
 
    $sql="SELECT `actorid` FROM $qufu_db.`actors` WHERE `accountname` = '${account}'";
    $row = $mysqli->query($sql);
    
    $sqlrmb="SELECT `rmb` FROM $qufu_db.`globaluser` WHERE `account` = '${account}'";
    $rowrmb = $mysqli->query($sqlrmb);
    $accrmb=$rowrmb->fetch_array(1)['rmb'];
    
    if($row && $row->num_rows > 0){
        $actorid=$row->fetch_array(1)['actorid'];
        if(strpos($payName,'充值') !== false){$stak="充值";}else{$stak="激活";}
        //充值：
            if(600==$itemid){$rmb=6;}    //6元    
            if(1200==$itemid){$rmb=12;}    //12元    
            if(3000==$itemid){$rmb=30;}    //30元    
            if(6000==$itemid){$rmb=60;}    //60元    
            if(10000==$itemid){$rmb=98;}    //98元    
            if(20000==$itemid){$rmb=198;}    //198元    
            if(50000==$itemid){$rmb=488;}    //488元    
            if(100000==$itemid){$rmb=988;}    //988元    
            if(150000==$itemid){$rmb=1498;}    //1498元    
        
        //其他 其他的 自己按照编号添加
            if(1000==$itemid){$rmb=10;}//首冲
            if(2800==$itemid){$rmb=28;}//钻石月卡
            if(8800==$itemid){$rmb=88;}//至尊特权
            if(110==$itemid){$rmb=1;}//1元抢购
            if(100==$itemid){$rmb=1;}//1元秒杀
            if(300==$itemid){$rmb=3;}//3元秒杀
            if(700==$itemid){$rmb=6;}//6元秒杀
            if(900==$itemid){$rmb=8;}//8元秒杀
            if(6800==$itemid){$rmb=68;}//黄金圣龙

            if($rmb>0){
            if($accrmb>=$rmb){
            //添加    
            $sql="insert into $qufu_db.feecallback(serverid,openid,itemid,actor_id) values ('{$serverId}','{$account}','{$itemid}','{$actorid}')";
            $mysqli->query($sql);        
            //减少账户余额 
            $sqlrmb = "UPDATE $qufu_db.`globaluser` SET `rmb`=rmb-{$rmb} WHERE `account`='${account}'";
            $mysqli->query($sqlrmb);            
            $tips=$payName.$stak."成功！消费：".$rmb."剩余:".($accrmb-$rmb)."平台币";
            $status=1;            
            }else{
            $tips="账户余额不足！！！剩余:".$accrmb."平台币";
            $status=1;
        
            }}
            
            if($status==1)    {
            $data['code'] = "500";
            $data['msg'] = urlencode ($tips);                    
            }else{
            $data['code'] = "500";
            $data['msg'] = urlencode ($payName."暂未开放内购！编号:".$itemid);                
            }

/*        
        //第二步判断payName 发送对应邮件
        if(strpos($payName,'充值') !== false){
            //充值：
            ///$sql="insert into $qufu_db.feecallback(serverid,openid,itemid,actor_id) values ('{$serverId}','{$account}','{$itemid}','{$actorid}')";
            ///$mysqli->query($sql);
            $rmb=10;
            $tips=$payName."成功！消费：".$rmb."剩余:".$accrmb."平台币";
            $data['code'] = "500";
            $data['msg'] = urlencode ($tips);
        }else{ 
            //开通：九-零-一-起-玩-w-w-w-.--9-0-17--5.-c-om
            $status=0;
            if(1000==$itemid){//首冲
            $rmb=10;                
            }

            if($accrmb>=$rmb){
            //添加    
            //$sql="insert into $qufu_db.feecallback(serverid,openid,itemid,actor_id) values ('{$serverId}','{$account}','{$itemid}','{$actorid}')";
            //$mysqli->query($sql);        
            //减少账户余额
            $tips=$payName."激活成功！消费：".$rmb."剩余:".$accrmb."平台币";
            $status=1;            
            }else{
            $tips="账户余额不足！！！剩余:".$accrmb."平台币";
            $status=1;
        
            }
            
            if($status==1)    {
            $data['code'] = "500";
            $data['msg'] = urlencode ($tips);                    
            }else{
            $data['code'] = "500";
            $data['msg'] = urlencode ($payName."暂未开放内购！编号:".$itemid);                
            }        

 
        } */ 
    }else{
       $data['code'] = "500";
       $data['msg'] = urlencode ("角色不存在");
    }
     
}else{
    $data['code'] = "500";
    $data['msg'] = urlencode ("账号不存在");
}
 
exit(urldecode(json_encode($data)));
?>

代码如上 每次登录会弹出报错 但是不知道具体是哪里出错了

Answer 1

你代码是充值的接口吧，不是登录的接口吧？