php postgresql connection code example
Example 1: php connect to postgresql
<?php
$db_connection = pg_connect("host=localhost dbname=dbname user=username password=password");
$result = pg_query($db_connection, "SELECT lastname FROM employees");
?>
<?php
$myPDO = new PDO('pgsql:host=localhost;dbname=dbname', 'username', 'password');
$result = $myPDO->query("SELECT lastname FROM employees");
?>
Example 2: php postgresql
<?php
$db_connection = pg_connect("host=localhost dbname=DBNAME user=USERNAME password=PASSWORD");
?>
Example 3: php postgresql
<?php
$result = pg_query($db_connection, "SELECT lastname FROM employees");
?>