Adding mysqli_connect() function stops running the script

Question

When I add the mysqli_connect statement in my php file it stops working the whole script. If make this statement comment my php file works as expected. I am adding this file to a wordpress website.

I have tried to connect using mysql_connect() also but the result is same.

My Code:

<?php

require_once ($_SERVER['DOCUMENT_ROOT'].'/wp-config.php');

ini_set('display_errors', 1); 
error_reporting(E_ALL);

//phpinfo();

echo DB_NAME ."<br>";
echo DB_USER ."<br>";
echo DB_PASSWORD ."<br>";
echo DB_HOST."<br>"


$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD,DB_NAME);
// database port is also 3306 which is default

if (!$conn) {
    echo  "Connection failed: " . mysqli_connect_error();
}
echo "Connected successfully";

?>

php.info() outputs that mysqli is installed is also enabled.

Do I need to include some file to access mysqli_connect() function.

How can I connect to the database?

@SaadSuri but the echo statements are fine and shows the proper output if I remove the mysqli_connect() and oter db related statements but in combinations I get nothing in output — stackOverflow
– stackOverflow, Commented Jul 8, 2017 at 8:18
Because you don't need to terminate the last line of code. It can be done through ?>. When you remove your all db related statements so echo DB_HOST."<br>" becomes the last statement which will be successfully terminated by ?> — Saad Suri
– Saad Suri, Commented Jul 8, 2017 at 8:20

Saad Suri · Accepted Answer · 2017-07-08 08:30:11Z

1

You missed a semicolon at echo DB_HOST."

    require_once ($_SERVER['DOCUMENT_ROOT'].'/wp-config.php');

    ini_set('display_errors', 1); 
    error_reporting(E_ALL);

    //phpinfo();

    echo DB_NAME ."<br>";
    echo DB_USER ."<br>";
    echo DB_PASSWORD ."<br>";
    echo DB_HOST."<br>";


    $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD,DB_NAME);
    // database port is also 3306 which is default

    if (!$conn) {
        echo  "Connection failed: " . mysqli_connect_error();
    }
    echo "Connected successfully";

    ?>

answered Jul 8, 2017 at 8:30

Saad Suri

1,3821 gold badge14 silver badges27 bronze badges

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

Comments

Bhunesh Satpada · Accepted Answer · 2017-07-08 08:27:29Z

0

Use this code. You missed semi colon at end of DB_HOST."<br>" line. Every thing is fine in code.

<?php

require_once ($_SERVER['DOCUMENT_ROOT'].'/wp-config.php');

ini_set('display_errors', 1); 
error_reporting(E_ALL);

//phpinfo();

echo DB_NAME ."<br>";
echo DB_USER ."<br>";
echo DB_PASSWORD ."<br>";
echo DB_HOST."<br>";


$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD,DB_NAME);
// database port is also 3306 which is default

if (!$conn) {
    echo  "Connection failed: " . mysqli_connect_error();
}
echo "Connected successfully";

?>

answered Jul 8, 2017 at 8:27

Bhunesh Satpada

8102 gold badges7 silver badges19 bronze badges

Collectives™ on Stack Overflow

Adding mysqli_connect() function stops running the script

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