Pass SQL database connection to PHP function

Question

I am calling a function from a second PHP file and I want to avoid creating the DB connection again. I am using this code but it does not work.

$Db = mysqli_init();
$Db->options(MYSQLI_OPT_LOCAL_INFILE, true);
$Db->real_connect($servername, $username, $password, $dbname, 3306);
$connection = $Db->real_connect($servername, $username, $password, $dbname, 3306);

CheckTableMetrics($connection, $dbname, $table1, $table2, $metric1, $metric2, $date1, $date2, $start_date, $end_date);

I get errors out of the blue. If I put the first part of my code in the PHP file that contains the function everything works.

The errors I get :

mysqli::query(): invalid object or resource mysqli

and

Call to a member function fetch_assoc() on a non-object

The code works fine if I just put the :

$Db = mysqli_init();
$Db->options(MYSQLI_OPT_LOCAL_INFILE, true);
$Db->real_connect($servername, $username, $password, $dbname, 3306);

Which is the best way to do it?

Does not work.. I love questions like these.. How are we magically supposed to know why it doesn't work? Turn on your error reporting and try to debug your code?! — Naruto
– Naruto, Commented Dec 15, 2015 at 12:33
You can create a singleton object for dbConnection. Also check this document -> stackoverflow.com/a/11369679/767329 — Mihriban Minaz
– Mihriban Minaz, Commented Dec 15, 2015 at 12:37

TwoStraws · Accepted Answer · 2015-12-15 12:38:55Z

4

Your problem is fairly simple:

$connection = $Db->real_connect($servername, $username, $password, $dbname, 3306);

This is wrong. real_connect() returns a boolean marking success or failure, not a connected database object. Instead, you should send $Db into your function, and it will all work.

answered Dec 15, 2015 at 12:38

TwoStraws

13.2k3 gold badges60 silver badges72 bronze badges

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

3 Comments

Steve Over a year ago

Well spotted - missed that completely

Datacrawler Over a year ago

Great. It was so simple !

TwoStraws Over a year ago

The simple problems are often the hardest to spot :)

Collectives™ on Stack Overflow

Pass SQL database connection to PHP function

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related