MySQL query inside a function

Question

I have that code:

$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

$result = $mysqli->query("SELECT id FROM User");
echo("users: " . $result->num_rows ."<br/>");

function echoUserNum()
{
    $result = $mysqli->query("SELECT id FROM User");
    echo("users: " . $result->num_rows ."<br/>");
}
echoUserNum();

It prints the number of users only once (first echo call). Where is the problem?

Aaron W. · Accepted Answer · 2012-12-09 02:37:58Z

3

$mysqli is out of scope in the function echoUserNum. Try global, or pass the connection

function echoUserNum()
{
    global $mysqli;
    $result = $mysqli->query("SELECT id FROM User");
    echo("users: " . $result->num_rows ."<br/>");
}

or

function echoUserNum($mysqli)
{
    $result = $mysqli->query("SELECT id FROM User");
    echo("users: " . $result->num_rows ."<br/>");
}
echoUserNum($mysqli);

answered Dec 9, 2012 at 2:37

Aaron W.

9,2952 gold badges36 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ivan Kuckir Over a year ago

Thank you :) I have no experience with PHP, I was looking at it from JavaScript perspective :)

Collectives™ on Stack Overflow

MySQL query inside a function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related