Unable to insert data into PostgreSQL table through php heroku app

Question

I am trying to create a simple php application on heroku with postgresql back end. I have created a connection to postgresql server with the provided credentials from heroku:-

<?php

class DB_Connect
    {
        private $db; 
        public function connect()
        {
          $host        = "";
          $port        = "port=5432";
          $dbname      = "";
          $credentials = "user= password=";

          $db = pg_connect( " $url $host $port $dbname $credentials"  );
          if(!$db){
             echo "Error : Unable to open database\n";
          } else {
             echo "Opened database successfully\n";
          }
        }
    }

    $db1 = new DB_Connect();
    $conn = $db1->connect();

    $query = "insert into public.user_test(name,email) values('val','[email protected]')";
    $result = pg_query($conn,$query);
    echo $result;
?>

When i deploy the app on heroku, I get a Opened Database successfully message but nothing gets inserted into the table when I check the table using pgadmin.

I tried it with and without the schema name "public", but that didn't help either.

When I run the app locally by providing the local postgresql credentials, the table gets populated.

Just note that the $db from $db = pg_connect.. is not the same as the one from private $db. — FirstOne
– FirstOne, Commented Feb 29, 2016 at 14:30

Philipp · Accepted Answer · 2016-02-29 14:13:19Z

1

You didn't return the connection in your connect method. Adding return $db; after the if condition should do the trick.

class DB_Connect
{
    public function connect()
    {
      $host        = "";
      $port        = "port=5432";
      $dbname      = "";
      $credentials = "user= password=";

      $db = pg_connect( " $url $host $port $dbname $credentials"  );
      if(!$db){
         echo "Error : Unable to open database\n";
      } else {
         echo "Opened database successfully\n";
      }
      return $db;
    }
}

answered Feb 29, 2016 at 14:13

Philipp

15.7k4 gold badges38 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Unable to insert data into PostgreSQL table through php heroku app

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related