CodeIgniter Laravel PHP PostgreSQL PHP Example Javascript jQuery MORE

Insert record or Data using PostgreSQL and PHP


In this example we use 3 file for Insert record or Data using PostgreSQL and PHP.

  1. index.php
  2. database.php
  3. process.php

index.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>

database.php

<?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");
?>

process.php

<?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.";
	 }
}
?>