In this example we use 3 file for Insert record or Data using PostgreSQL and PHP.
<!DOCTYPE html>
<html>
<body>
<form method="post" action="process.php">
First name:<br>
<input type="text" name="first_name">
<br>
Last name:<br>
<input type="text" name="last_name">
<br>
City name:<br>
<input type="text" name="city_name">
<br>
Email Id:<br>
<input type="email" name="email">
<br><br>
<input type="submit" name="save" value="submit">
</form>
</body>
</html>
<?php
$host = "host = 127.0.0.1";
$port = "port = 5432";
$dbname = "dbname = testdb";
$credentials = "user = postgres password=pass123";
$db = pg_connect( "$host $port $dbname $credentials");
?>
<?php
include_once 'database.php';
if(isset($_POST['save']))
{
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city_name = $_POST['city_name'];
$email = $_POST['email'];
$query = "INSERT INTO employee(first_name,last_name,city_name,email)
values ('$first_name','$last_name','$city_name','$email')";
if($result = pg_query($query)){
echo "Data Added Successfully.";
}
else{
echo "Error.";
}
}
?>