very short code [ mysql_result to mysqli please help]

[cripin]

started learning php last week, at first didn't know anything about it so used mysql, now yesterday reading some article i saw that i should be using mysqli instead of mysql, so i changed all the code for my registration and login pages every works fine. However can't figure out the mysql_result to mysqli, couldn't find it on google too

the code:
the error im getting:
Warning: mysql_result() expects parameter 1 to be resource, object given in /Applications/XAMPP/xamppfiles/htdocs/index.php on line 12

<?php
require 'conect.php';

$user_ip = $_SERVER['REMOTE_ADDR'];

function update_count()
{ global $dbconnect;

$query = "SELECT count FROM hits_count";
if ($query_run = mysqli_query($dbconnect, $query))
{
$count = mysql_result($query_run, 0, 'count');
echo $count;
}
}
update_count();
?>

 

[mac_gyver]

afaik, there's no direct equivalent to msyql_result, because it is so inefficient at what it does. you need to fetch the row and access the value. you can do this all at once using -

list($count) = mysqli_fetch_row($query_run);

[cripin]

thanks 

[Barand]

As an aside, do not use globals. Pass the connection to the function as a parameter. If you inadvertently assign a value to the global inside a function you could spend hours in a large script trying to find why the whole script is screwed.

function update_count($db)
{ 

    $query = "SELECT count FROM hits_count";
    $count = 0;
    if ($query_run = mysqli_query($db, $query))
    {
        list($count) = mysqli_fetch_row($query_run);
    }
    return $count;
}


$count = update_count($dbconnect);

[cripin]

 

As an aside, do not use globals. Pass the connection to the function as a parameter. If you inadvertently assign a value to the global inside a function you could spend hours in a large script trying to find why the whole script is screwed.

function update_count($db)
{ 

    $query = "SELECT count FROM hits_count";
    $count = 0;
    if ($query_run = mysqli_query($db, $query))
    {
        list($count) = mysqli_fetch_row($query_run);
    }
    return $count;
}


$count = update_count($dbconnect);

 

Can i include it inside the function parameter even if I already have a parameter inside it? the parameter is the name of another function. Basically can i have 2 paramaters in a function and if so should the connection one come before or after

Edited May 12, 2013 by cripin

[Barand]

You can have many parameters but you must call the function with parameters in the correct order as  defined in the function definitions

[cripin]

so say if the function has 3 parameters and the one you wanna use is the 3rd one, would it calling the function look something like this: myfunction('','',$myparameter);       or       my function($myparameter) ;           or something else?

[Barand]

http://www.php.net/manual/en/language.functions.php