DML operations

To execute a DML operation against the database, we can use a set of pg_* functions. We can use the same functions for all DML operations.

pg_query/pg_query_params/pg_insert/pg_update/pg_delete

First, let's try to insert records into the database with pg_query:

$sql=<<<EOF 
INSERT INTO test VALUES('A', 'B'); 
INSERT INTO test VALUES('I', 'U'); 
EOF; 
 
if (pg_query($con, $sql)) { 
  echopg_affected_rows($con); echo " Records are inserted    
  successfully"; 
} 
else { 
  echo"Failed inserting records"; 
  echopg_last_error($con); 
  echo"\n"; 
} 

Result:

$ php /tmp/test.php 
Successfully made connection to PostgreSQL 
pg connection pid is 92153 
2 Records are inserted successfully

If we want to know how many records our code inserted, then we will have to use pg_affected_rows($con) after executing the INSERT statements.

pg_query_params

Using the pg_query_params function, we can pass...