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  // with PDO
    $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");
?>

Tags:

Php Example