php - Using database objects in functions -


in webapp building make use of pdo database object querying database. instantiated @ top of every page using custom class built based on pdo:

$db = new database; //database name of class. 

i use class in script:

$db->query("select field table"); $results = $db->resultset(); 

i have number of standalone functions need make use of database object.

my question is better practise pass $db function argument or globalize within function, given $db globally used variable. have heard things avoiding polluting global namespace.

i.e.

function myfunction($db, $a1, $a2){     //stuff } 

vs

function myfunction($a1, $a2){     global $db;     //stuff } 

in opinion, global vars practice. think should use first solution: passing db instance first parameters function.

if have 1 instance of database, better option make database class singleton. allow $db = database.getinstance(); in functions.


Comments

Popular posts from this blog

How to logout from a login page in asp.net -

Stack level too deep error after upgrade to rails 3.2 and ruby 1.9.3 -