php - fatal error : Call to undefined function mysqli_result() with click counter function

Question

这是我计算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;

和点击计数器

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);       
}

如何替换此函数中的 mysqli_result 以避免此错误？ fatal error :调用未定义函数 mysqli_result()

Answer 1

不推荐使用的 mysql 函数和 mysqli 函数之间没有 1:1 的精确匹配。您必须获取一行作为数组，然后检查其中的一个元素。

例子:

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