How to connect to heroku postgres database?

Question

I'm trying to connect to postgres databse on heroku but it doesn't work for me.

This is the code in index.php

<?php
$host = "my host";
$dbname = "my database name";
$user = "my username";
$password = "my password";
$port = "5432";

$dsn = "pgsql:host=$host;dbname=$dbname;user=$user;port=$port;password=$password";

$db = new PDO($dsn);

if($db){
  echo "Connected <br />".$db;
}else {
  echo "Not connected";
}
 ?>

But nothing appear on the screen it should print not connected if the credentials are wrong.

Help Please

Thanks all

Verance · Accepted Answer · 2017-05-04 21:38:50Z

2

You need to get your DATABASE_URL variable. You can get it going here and press 'View Credentials'. Then fill your DB connection with the info provided.

Regards

answered May 4, 2017 at 21:38

Verance

1372 silver badges13 bronze badges

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

Comments

user7612612 · Accepted Answer · 2017-08-06 18:29:15Z

0

Try next code, it works with me.

<?php

   $con = "dbname=fgsfg10pdq host=ghfghfh4654.amazonaws.com port=5432 user=gafasduyiu password=435346af8493196 sslmode=require";


   if (!$con) 
   {
     echo "Database connection failed.";
   }
   else 
   {
     echo "Database connection success.";
   }

?>

answered Aug 6, 2017 at 18:29

user7612612

2 Comments

B.Nabeih Over a year ago

I solved it long time ago.. thanks the problem is you can't connect via localhost. only through heroku server

Eklavya Chandra Over a year ago

Please tell how to connect with SSL in mysqli_connect

Collectives™ on Stack Overflow

How to connect to heroku postgres database?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related