How to connect Postgre SQL with PHP
Install PostgreSQL and PHP
Make sure both PostgreSQL and PHP are installed on your system. You can download them from their official websites or install them via package managers
Code for PostgreSQL connection with PHP
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
<?php // Database configuration $host = 'localhost'; $db = 'database_name'; $user = 'postgres'; // by default its postgres $pass = 'database_user_password'; $port = '5432'; // Default port for PostgreSQL // Create connection string $conn_string = "host=$host port=$port dbname=$db user=$user password=$pass"; // Establish a connection to the PostgreSQL database $conn = pg_connect($conn_string); if (!$conn) { echo "Error: Unable to open database\n"; exit; } |
1. In the below we can define our hostname. For local, you can use localhost. If you want to access the other host then put that hostname or Server IP here
|
1 |
$host = 'localhost'; |
2. Here we define our database name
|
1 |
$db = 'database_name'; |
3. This code for DB user name. For local we use postgre its default username. But you can create db user name whatever you want.
|
1 |
$user = 'postgres'; |
4. Here we can define db password.
|
1 |
$pass = 'database_user_password'; |
5. Here we can define the Postgre post number. By default port no is 5432
|
1 |
$port = '5432'; |
6. The pg_connect function opens a new connection to the MySQL server.
|
1 2 3 4 |
// Create connection string $conn_string = "host=$host port=$port dbname=$db user=$user password=$pass"; // Establish a connection to the PostgreSQL database $conn = pg_connect($conn_string); |
NOTE: For using Postgre Database with PHP, you need to enable the pgsql extension in php.in.
