mysqli connection variable visible to all functions?

Question

I have config.php:

$mysqli = new mysqli($hostname, $user, $pass, $bd);

I include this config.php in all my website pages. eg

index.php

include("config.php");
include("functions.php");
...

in functions.php I have functions like this:

function get_name{
 $stmt = $mysqli->prepare("SELECT * FROM users WHERE user=?");
}

my problem is, function get_name cant see $mysqli var. I need to include config.php inside get_name function (and all functions).

is there any other way to get $mysqli variable without need to include config.php in all functions?

Louis D. · Accepted Answer · 2015-04-12 10:17:00Z

1

Use global for variables in functions.

function get_name{
    global $mysqli;
     $stmt = $mysqli->prepare("SELECT * FROM users WHERE user=?");
    }

answered Apr 12, 2015 at 10:17

Louis D.

4647 silver badges19 bronze badges

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

Comments

lakshman · Accepted Answer · 2015-04-12 10:20:29Z

0

Use class and objects for this. In config page write down the connection variables & by including the config page in a database class, write your functions in an inherited class then pass it in an object based reference to functions.

answered Apr 12, 2015 at 10:20

lakshman

6574 silver badges18 bronze badges

Collectives™ on Stack Overflow

mysqli connection variable visible to all functions?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related