set mysql connect to a php and access them from multiple php functions

Question

I have a php file, which connects to a mysql database using:

  $mysqli = mysqli_connect("localhost","user","pass","db");

And on the same php, there are some functions that made use of that connection, and make querys...

I dont know how to set $mysqli to the entire php and call to it from functions, instead of repeating the connection on every function...

(I have 3 functions, i need to repeat the code of connection on every function, making at the end, 3 connections to the same database. I want to avoid that, and make one connection, and use it on the 3 functions without making another connection more.

Is there any way?

thanks

AbraCadaver · Accepted Answer · 2016-02-08 19:43:09Z

2

There's got to be dupes, but here's two ways:

Pass it into the function:

$mysqli = mysqli_connect("localhost","user","pass","db");
$something = test($mysqli);

function test($conn) {
    mysqli_query($conn, 'stuff);
}

Or access the global variable:

function test() {
    mysqli_query($GLOBALS['mysqli'], 'stuff');
}

answered Feb 8, 2016 at 19:43

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Comments

Adam Hull · Accepted Answer · 2016-02-08 19:44:54Z

1

You need to have your function look like

 function something(){
    global $mysqli;
    // Rest of function
    }

This is just one way you can do this

answered Feb 8, 2016 at 19:44

Adam Hull

1942 silver badges10 bronze badges

Comments

BryanT · Accepted Answer · 2016-02-08 20:15:46Z

-1

You can have a separate php module that "wraps" your mysqli calls.

function Sql_Query($query) {

$result = mysqli_query($database_connection, $query);
if (Sql_Check_Error($database_connection))
   dbg("Sql error in $query"); // Some debugging code
}
return $result;

}

Where Sql_Error_Check is yet another "wrapped" mysqli call, etc...

And this is a global.

$database_connection = Sql_Connect($database_host,$database_user,$database_password,$database_name);

There's an even better Object Oriented for mysqli. http://php.net/manual/en/mysqli.quickstart.dual-interface.php

edited Feb 8, 2016 at 20:15

answered Feb 8, 2016 at 19:55

BryanT

4123 silver badges13 bronze badges

2 Comments

uchi Over a year ago

that calls the function on every query, that is even worst, you connect every time you do a query

BryanT Over a year ago

My own code was actually very much like @AbraCadaver's - I over simplified it here to avoid having to explain where the GLOBAL was.

Collectives™ on Stack Overflow

set mysql connect to a php and access them from multiple php functions

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related