PHP page doesn't work after open mysqli connection

Question

Why my page doesn't work anymore after I added this code in:

<?php 
    $conn = mysqli_connect($host, $user, $pw, $db);
    if ($conn == false) {
        die("Es konnte keine Verbindung zur Datenbank hergestellt werden");
    }
?>

The error which I get is:

ERR_EMPTY_RESPONSE

If I uncomment this code then it works.

How can I solve this?

Add `error_reporting(E_ALL); ini_set('display_errors', '1');` to the beginning of your php file. — Phiter, Nov 07 '16 at 10:24
have you created all the varriable and given value to that ? which you have passed in mysqli_connect () -- give all the necessary value like host name ,username ,password , db — Manthan Dave, Nov 07 '16 at 10:25

score -1 · Answer 1 · answered Nov 07 '16 at 10:24

-1

change your code to this:

 <?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

answered Nov 07 '16 at 10:24

Blueblazer172

551
2
14
43

I tried but it didn't work... – Cihat Nov 07 '16 at 11:24
@xCihat what is your error with my answer ? – Blueblazer172 Nov 07 '16 at 11:25
still the same error. – Cihat Nov 07 '16 at 11:26
@xCihat is this the error: `Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data.` ?? – Blueblazer172 Nov 07 '16 at 11:37
yes all other php codes are working. At begin, i had an extra file with the code above and then i included in the index file and it worked. Now i added it directly to the index file and it dont work anymor – Cihat Nov 07 '16 at 11:37
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/127531/discussion-between-blueblazer172-and-xcihat). – Blueblazer172 Nov 07 '16 at 11:38

score -1 · Answer 2 · answered Nov 07 '16 at 10:26

-1

Do it like this, hope it will work

$conn = new mysqli($host, $user, $pw, $db);
if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}

answered Nov 07 '16 at 10:26

Waleed Ahmed

1,094
9
16

I tried but it didn't work... – Cihat Nov 07 '16 at 11:24

score -2 · Answer 3 · answered Nov 07 '16 at 10:28

-2

First you should check your database connectivity code, recheck the dbconfig php file. assign correct values for config db.

Check Blueblazer172 answer. it will help you.

answered Nov 07 '16 at 10:28

Sathishkumar

337
2
7
15

PHP page doesn't work after open mysqli connection

3 Answers3