Variable from different file in function without using global

Question

Ay,

I defined (in config.php):

$mysql = mysqli_connect (..);

for connecting to the mySQL database. now I want to use the variable in my functions (functions.php):

function x () { $fetch = ($mysql, "SELECT ...")); }

without using global:

function x () { global $mysql ... }

any clean ideas (procedural)?

score 1 · Accepted Answer · answered Jan 02 '16 at 13:57

1

You can e.g. pass the connection resource to your function

function x ($mysqli) { $mysqli->... }

answered Jan 02 '16 at 13:57

VolkerK

score 1 · Answer 2 · answered Jan 02 '16 at 14:41

You can access variables in global-scope without the global-keyword by using the Superglobal $GLOBALS:

function x() { $GLOBALS['mysql']->... }

I would recommend to create a separate function that returns the Database-Handle/Object you can use instead of the variable. e.g.:

function db() { return $GLOBALS['mysql']; }
function x() { db()->... }

2 Answers2