I've just set Postgres up on my Mac (El Capitan) and I am trying to connect to it via PHP... however, when I submit a sample form, I get "Fatal error: Call to undefined function pg_connect()". I've been researching this on Stack (which is how I got this far), but I'm not sure where I need to go from here.
Here's how I've put this together so far...
I use homebrew, and I ran
brew install php55-pdo-pgsql
.I updated my Apache httpd.conf file, replacing
LoadModule php5_module libexec/apache2/libphp5.so
withLoadModule php5_module /usr/local/opt/php55/libexec/apache2/libphp5.so
.I restarted Apache.
I'm not sure if it's helpful here or not, but here's the PHP...
$name = $_POST['name'];
$species = $_POST['species'];
$conn = pg_connect("host=localhost dbname=menagerie user=root password=****");
pg_query($conn, "INSERT INTO pet (name, species) VALUES ('$name', '$species')");
What have I overlooked? Thanks very much.