Php MySql connection issue

Question

I have db.php with the following code.

<?php
$dbHost = "localhost";
$dbUser = "root";
$dbPass = "password";
$dbName = "test";
$databaseLink = new mysqli ($dbHost, $dbUser, $dbPass);
if($databaseLink)
{
    mysqli_select_db($databaseLink,$dbName);
}
?>

which I usually import on to other php page like this

<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/core/include/db.php";
?>

and works fine. I can start querying using $databaseLink. But there is one page where its not working. But if I explicitly define the connection like this $databaseLink= mysqli_connect("localhost", "root", "password", "test"); it works. There are other php files in the same directory which has no issues.

I have tried

<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/core/include/db.php";
global($databaseLink);
?>

But that does not seem to work too. I have looked it up online for examples but can find any help.

You need to require $path; (or better yet require_once ) — apokryfos
– apokryfos, Commented Jan 26, 2018 at 7:01
Are you sure the path is still the same and correct every time you use it? Plus, why not use require_once $pathtodb instead? — Carl Binalla
– Carl Binalla, Commented Jan 26, 2018 at 7:02

Ali Faris · Accepted Answer · 2018-01-26 07:10:20Z

1

you forget to require your db.php file

require_once($path);

edited Jan 26, 2018 at 7:10

answered Jan 26, 2018 at 7:04

Ali Faris

18.7k12 gold badges51 silver badges75 bronze badges

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

2 Comments

Rotimi Over a year ago

OP's method of initializing the database connection is perfectly valid

The Naga Tanker Over a year ago

Thanks this Works. But cant I do without that.

Jonny · Accepted Answer · 2018-01-26 07:06:46Z

0

You can simply use include at the top of your php code to link in another php page.

include '/core/include/db.php';

answered Jan 26, 2018 at 7:06

Jonny

1,3371 gold badge16 silver badges27 bronze badges

Collectives™ on Stack Overflow

Php MySql connection issue

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related