How to use PostgreSQL database in PHP programming?

With the development of database technology, database management systems also present a variety of choices. Developers can choose the most suitable database according to their own needs and preferences. As an advanced open source relational database system, PostgreSQL is attracting more and more attention and use by developers. So, how to use PostgreSQL database in PHP programming?

1. Install and configure PostgreSQL database

Before using PostgreSQL, you need to install and configure it first. First, download the PostgreSQL installation package corresponding to the system version from the official website and install it. After the installation is complete, you can create databases and tables through the PgAdmin tool. Next, you need to enable PHP's support for PostgreSQL in the php.ini file. Find the line of code extension=pgsql.dll, remove the semicolon, and activate it.

2. Connect to PostgreSQL database

To use the PostgreSQL database in a PHP program, you need to connect to the database first. You can easily connect to a PostgreSQL database using PHP's built-in PG_connect() function. The code example is as follows:

<?php
//连接到数据库
$dbconn = pg_connect("host=localhost dbname=mydatabase user=postgres password=mypassword")
          or die('Could not connect: ' . pg_last_error());
?>

In the above code, you need to set the corresponding host address, database name, user name and password. If it is a local test environment, you can set the host address to localhost.

3. Data addition, deletion, modification and query operations

1. Data insertion operation

To insert data into the PostgreSQL database, you can use the PG_query() function to perform an insertion operate. The code example is as follows:

<?php
//向表中插入数据
pg_query($dbconn, "INSERT INTO mytable (name, age, gender) VALUES ('Tom', 23, 'male')");
?>

2. Data reading operation

To read data from the PostgreSQL database, you can use the PG_query() function and PG_fetch_array() function to perform a query operation. The code example is as follows:

<?php
//查询数据
$result = pg_query($dbconn, "SELECT name, age, gender FROM mytable");
//遍历结果集
while ($row = pg_fetch_array($result, null, PGSQL_ASSOC)) {
  echo "Name: ".$row['name']." Age: ".$row['age']." Gender: ".$row['gender']."<br>";
}
?>

3. Data deletion operation

To delete data from the PostgreSQL database, you can use the PG_query() function to perform a delete operation. The code example is as follows:

<?php
//删除数据
pg_query($dbconn, "DELETE FROM mytable WHERE name='Tom'");
?>

4. Data update operation

To update the data in the PostgreSQL database, you can use the PG_query() function to perform an update operation. The code example is as follows:

<?php
//更新数据
pg_query($dbconn, "UPDATE mytable SET age=24 WHERE name='Tom'");
?>

The above is the basic operation method of using PostgreSQL database in PHP programming. In actual development, these operations can be further enriched and optimized according to your own needs. All in all, PostgreSQL, as an advanced open source relational database system, has become more and more widely used in PHP programming and is worthy of users' in-depth understanding and try.

The above is the detailed content of How to use PostgreSQL database in PHP programming?. For more information, please follow other related articles on the PHP Chinese website!