duanchun6148
2014-08-27 23:45
浏览 114
已采纳

致命错误:使用单击计数器功能调用未定义的函数mysqli_result()

here is my function to count clicks from ips,

function get_client_ip() {
$ipaddress = '';
if (getenv('HTTP_CLIENT_IP'))
    $ipaddress = getenv('HTTP_CLIENT_IP');
else if(getenv('HTTP_X_FORWARDED_FOR'))
    $ipaddress = getenv('HTTP_X_FORWARDED_FOR');
else if(getenv('HTTP_X_FORWARDED'))
    $ipaddress = getenv('HTTP_X_FORWARDED');
else if(getenv('HTTP_FORWARDED_FOR'))
    $ipaddress = getenv('HTTP_FORWARDED_FOR');
else if(getenv('HTTP_FORWARDED'))
   $ipaddress = getenv('HTTP_FORWARDED');
else if(getenv('REMOTE_ADDR'))
    $ipaddress = getenv('REMOTE_ADDR');
else
    $ipaddress = 'UNKNOWN';
return $ipaddress;

}

and the click counter

function update_visitas($id,$ip) {
global $dbc;
$sql = "SELECT COUNT(*) FROM ipclicks WHERE ip = "  . ip2long($ip) . " and ads = " . $id;

$res=mysqli_query($dbc,$sql);

if (mysqli_result($res, 0)==0){
        $sql = "INSERT INTO ipclicks VALUES (" . ip2long($ip) . "," . $id . ")";
        #echo $sql;
        $res=mysqli_query($dbc,$sql);           

        $sql = "UPDATE ads SET vistas = vistas +1 WHERE id_ad = " . $id;
        #echo $sql;
        $res=mysqli_query($dbc,$sql);       
}

}

how can i replace mysqli_result in this function to avoid this error? Fatal error: Call to undefined function mysqli_result()

图片转代码服务由CSDN问答提供 功能建议

这是我计算来自ips的点击次数的函数,

   function get_client_ip(){
 $ ipaddress =''; 
if(getenv('HTTP_CLIENT_IP'))
 $ ipaddress = getenv('HTTP_CLIENT_IP'); 
else if(getenv('HTTP_X_FORWARDED_FOR'))
 $ ipaddress  = getenv('HTTP_X_FORWARDED_FOR'); 
else if(getenv('HTTP_X_FORWARDED'))
 $ ipaddress = getenv('HTTP_X_FORWARDED'); 
else if(getenv('HTTP_FORWARDED_FOR'))
 $ ipaddress = getenv('  HTTP_FORWARDED_FOR'); 
else if(getenv('HTTP_FORWARDED'))
 $ ipaddress = getenv('HTTP_FORWARDED'); 
else if(getenv('REMOTE_ADDR'))
 $ ipaddress = getenv('REMOTE_ADDR');  
else 
 $ ipaddress ='UNKNOWN'; 
return $ ipaddress; 
   
 
 

}

和点击计数器< / p>

  function update_visitas($ id,$ ip){
global $ dbc; 
 $ sql =“SELECT COUNT(*)FROM ipclicks WHERE ip =”。  ip2long($ ip)。  “和ads =”。  $ id; 
 
 $ res = mysqli_query($ dbc,$ sql); 
 
if(mysqli_result($ res,0)== 0){
 $ sql =“INSERT INTO ipclicks VALUES(”。ip2long  ($ ip)。“,”。$ id。“)”; 
 #echo $ sql; 
 $ res = mysqli_query($ dbc,$ sql);  
 
 $ sql =“UPDATE ads SET vistas = vistas +1 WHERE id_ad =”。  $ id; 
 #echo $ sql; 
 $ res = mysqli_query($ dbc,$ sql);  
} 
   
 
 

}

如何在此函数中替换mysqli_result以避免此错误? Fatal错误:调用 到未定义的函数mysqli_result()

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongzh1988 2014-08-27 23:50
    已采纳

    There is not an exact 1:1 match between the deprecated mysql functions and the mysqli functions. You have to fetch a row as an array, and then inspect an element of it.

    Example:

    $res = mysqli_query($dbc,$sql);
    $row = mysqli_fetch_row($res);
    if ($row[0]==0){
        . . .
    
    打赏 评论

相关推荐 更多相似问题