Connect to PostgreSQL database using PHP

PHP is a widely used server-side scripting language that can interact with a variety of databases. PostgreSQL is a relational database management system and a very popular open source database solution. This article will introduce how to use PHP to connect to a PostgreSQL database.

1. Install the PostgreSQL database

Before you start using PHP to connect to PostgreSQL, you need to install the PostgreSQL database. You can download PostgreSQL from the official website (https://www.postgresql.org) and install it by following the instructions in the installation wizard.

2. Install PHP’s PostgreSQL extension

To use PHP to connect to PostgreSQL, you need to install PHP’s PostgreSQL extension. You can install the extension using the following command:

sudo apt-get install php-pgsql

If your PHP installation was compiled manually, you need to ensure that the PostgreSQL extension was included when PHP was compiled.

3. Connect to PostgreSQL database

After completing the installation, you can use the following code to connect to the PostgreSQL database:

<?php
    $host = "localhost";
    $port = "5432";
    $dbname = "database_name";
    $user = "username";
    $password = "password";

    $con = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$password");
    if(!$con){
        die("Connection failed: " . pg_last_error());
    }
    echo "Connected successfully";
?>

In the above code, you need to change the following variables Replace with actual values:

• $host: The hostname or IP address of the PostgreSQL server
• $port: The port of the PostgreSQL server Number (default is 5432)
• $dbname: The name of the database to be connected
• $user: The user name to connect to the database
• $password: Password for connecting to the database

If the connection is successful, "Connected successfully" will be output; if the connection fails, an error message will be output.

4. Query the database

After completing the connection, you can use the pg_query() function to execute the SQL query statement. The following sample code shows how to query a database table and output the results:

<?php
    $query = "SELECT * FROM table_name";
    $result = pg_query($con, $query);

    if(!$result){
        die("Error in query: " . pg_last_error());
    }

    while($row = pg_fetch_array($result)){
        echo $row['column_name'] . "<br>";
    }
?>

The above code will query the table named table_name and output each row of data in it. You need to replace query statements and table names with actual values. The query results will be stored in the $result variable as the return value of the pg_query() function. If the query fails, the code will print an error message.

If the query is successful, you can use the pg_fetch_array() function to read the results row by row and output the value of the specified column.

5. Disconnect

After connecting to the database, you should disconnect after completing the operation. Use the following code to disconnect:

<?php
    pg_close($con);
?>

The above code will disconnect to the PostgreSQL database. In actual applications, the connection should be disconnected in time after using the database in order to release resources and improve performance.

6. Summary

This article introduces how to use PHP to connect to the PostgreSQL database. First, you need to install the PostgreSQL database and the PostgreSQL extension for PHP. You can then connect to the database using the pg_connect() function and execute SQL query statements using the pg_query() function. Finally, you should use the pg_close() function to disconnect.

If you are developing a web application that uses a PostgreSQL database, this article provides a good starting point and I hope it will be helpful to you.

The above is the detailed content of Connect to PostgreSQL database using PHP. For more information, please follow other related articles on the PHP Chinese website!