Problem scenario
You are running Ubuntu Linux, and you want to create a .php script to be ran at the command prompt like this:

php good.php

You want this to open a PosgreSQL connection and issue a DDL command to create a database.  This is not a PHP web page.

Solution
This solution is only slightly more complicated than using PHP to run a basic SQL query in a Postgres database.

…

Continue reading “How Do You Write a Backend PHP Script to Query Postgres and Create a Database Name “foobar”?”

Problem scenario
You are trying to use a .php script on the back end to connect to your PostgreSQL database.  However, you get an error like this when you try to run it:

‘PHP Warning:  pg_connect(): Unable to connect to PostgreSQL server: FATAL:  role  “funuser” is not permitted to log in in /tmp/d.php on line 7’

How can your .php script log into the Postgres database?

…

Continue reading “How Do You Troubleshoot the PHP Error “role is not permitted to log in” So Your Script Can Log into a Postgres Database?”

Problem scenario
You are trying to use a .php script on the back end to connect to your PostgreSQL database.  However, you get an error like this when you try to run it:  ‘PHP Fatal error:  Call to undefined function pg_connect() in ‘

Solution
Install php5-pgsql.  For Ubuntu you would run a command like this:  sudo apt-get install php5-pgsql

…

Continue reading “How Do You Troubleshoot a PHP Error “call to undefined function pg_connect()” So Your Script Can Log into a Postgres Database?”