mysqli_connect will not pass to it functions

Question

I am conventing old mysql to mysqli and run into a problem, which is that my mysqli_connect will not work in any my functions. after looking on the internet I found that it was a scope problems so i passed the mysqli_connect variable on to the function. which did not work. here are my two error

Notice: Undefined variable: con in C:\xampp\htdocs\bear_mysqli\functions\cart.php on line 44

Warning: Missing argument 1 for products(), called in C:\xampp\htdocs\bear_mysqli\shop.php on line 30 and defined in C:\xampp\htdocs\bear_mysqli\functions\cart.php on line 40

$con = mysqli_connect("localhost","root","","bear") or die ($connect_error);

function products($con)
{
    $get = mysqli_query($con,'SELECT * FROM items WHERE quantity > 0 ORDER BY id DESC ');
}

Post the code where you called `products($con)` (line 30, shop.php). The error suggests that you forgot to pass its argument. Redefining the function to accept an argument is not sufficient. — Michael Berkowski, Jan 14 '15 at 21:17
And the other error isn't fully discernable from the posted code, but likely relates to a variable scope issue where `$con` was either not passed or not defined in the right scope to begin with. — Michael Berkowski, Jan 14 '15 at 21:20

score -1 · Answer 1 · edited Mar 24 '15 at 17:10

-1

function f1(){
  $get = mysqli_query($GLOBALS['con'], "SELECT * FROM location");
}

If you write $GLOBALS['con'] then $con variable is treated as global so you can use it now in any function.

edited Mar 24 '15 at 17:10

Tim Lewis

27,813
13
73
102

answered Mar 24 '15 at 16:53

Dharini

1
2

mysqli_connect will not pass to it functions

1 Answers1