Connecting to a ClearDB database in a Heroku application using PHP fails with no error message

Question

I've ruled out the possibility of supplying an incorrect name or password in mysqli_connect, because when I change them to make them incorrect on purpose, I actually get an error message from mysqli_connect_error(). With the code below, the connection fails, but I get no error message. I am out of ideas. What do you recommend I do next to debug?

 <?php

        $con = mysqli_connect("eu-cdbr-west-02.cleardb.net", "b497f08cc1919a", "7d15759b", "heroku_8d537c3a6f00758"); 

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


    ?>

Edit: As Seth pointed out, I mistyped the name of a variable. I'm sorry, I'll see myself out. :(

We all make mistakes like that. Just mark Seth's answer as the answer. — music2myear, Jan 11 '19 at 17:07
Btw, I hope those aren't real login credentials. They look to be and if so, you'd better go change those now. — Funk Forty Niner, Jan 11 '19 at 17:28
Yes, I am aware that showing the password here means that it's compromised. I'm just setting up a sandbox to learn, it's ok. I'll change it when I deploy for real. — Hagel, Jan 12 '19 at 10:31

score 0 · Answer 1 · answered Jan 10 '19 at 13:46

0

Your code is using $con for the connection but checking $conn. If you don't see the "Connected successfully" text your app as a whole likely has yet another problem. Usually you'd put that in the else part.

answered Jan 10 '19 at 13:46

Seth

1,215
15
35

Connecting to a ClearDB database in a Heroku application using PHP fails with no error message

1 Answers1