Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHP Function Accessing Database Connection

Tags:

scope

php

How do I allow a function to access a database connection without using GLOBAL?

config.php

 DEFINE ('DB_HOSTNAME', 'hostname');
 DEFINE ('DB_DATABASE', 'database');
 DEFINE ('DB_USERNAME', 'username');
 DEFINE ('DB_PASSWORD', 'password');

 $dbc = mysqli_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

 if(!$dbc) die("Unable to connect to MySQL: " . mysqli_error($dbc));

functions.php

 function something()
 {
 $info = mysqli_query($dbc, "SELECT info FROM text") or die("Error: ".mysqli_error($dbc));
 }

The above gives me the following error: mysqli_query() expects parameter 1 to be mysqli, null given in

like image 601
markerpower Avatar asked Oct 27 '25 12:10

markerpower


1 Answers

Use function parameters

function something ($dbc) {
  // your db code here
}

function arguments

like image 194
KingCrunch Avatar answered Oct 29 '25 01:10

KingCrunch



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!