How to insert data using PostgreSQL and PHP

In this tutorial, we will learn how to insert data using PostgreSQL and PHP.

File Structure for this tutorial

dbcon.php: This is used for PostgreSQL database connection with PHP.

index.php: This is used for HTML form and we will also put the PHP code here for data insertion

PostgreSQL database is testdb and tblemployee table name used in this tutorial

First, create the database (testdb) then run this PostgreSQL Table structure script

CREATE TABLE IF NOT EXISTS public.tblemployee
(
    id integer NOT NULL DEFAULT nextval('tblemployee_id_seq'::regclass),
    empname character varying(255) COLLATE pg_catalog."default",
    empemailid character varying(255) COLLATE pg_catalog."default",
    empmobileno integer,
    empdepartment character varying(255) COLLATE pg_catalog."default",
    creationdate date NOT NULL DEFAULT CURRENT_DATE,
    CONSTRAINT tblemployee_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.tblemployee
    OWNER to postgres;

CREATE TABLE IF NOT EXISTS public.tblemployee

(

id integer NOT NULL DEFAULT nextval('tblemployee_id_seq'::regclass),

empname character varying(255) COLLATE pg_catalog."default",

empemailid character varying(255) COLLATE pg_catalog."default",

empmobileno integer,

empdepartment character varying(255) COLLATE pg_catalog."default",

creationdate date NOT NULL DEFAULT CURRENT_DATE,

CONSTRAINT tblemployee_pkey PRIMARY KEY (id)

)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.tblemployee

OWNER to postgres;

Code for PostgreSQL connection with PHP (dbcon.php)

<?php
// Database configuration
$host = 'localhost';
$db   = 'testdb'; // Here you can use your datbase name
$user = 'postgres';
$pass = 'Test@123'; // Here you can your PostgreSQL DB user password
$port = '5432'; // Default port for PostgreSQL

// Create connection string
$conn_string = "host=$host port=$port dbname=$db user=$user password=$pass";

// Establish a connection to the PostgreSQL database
$conn = pg_connect($conn_string);

if (!$conn) {
    echo "Error: Unable to open database\n";
    exit;
}

<?php

// Database configuration

$host = 'localhost';

$db = 'testdb'; // Here you can use your datbase name

$user = 'postgres';

$pass = 'Test@123'; // Here you can your PostgreSQL DB user password

$port = '5432'; // Default port for PostgreSQL

// Create connection string

$conn_string = "host=$host port=$port dbname=$db user=$user password=$pass";

// Establish a connection to the PostgreSQL database

$conn = pg_connect($conn_string);

if (!$conn) {

echo "Error: Unable to open database\n";

exit;

}

Create an HTML Form for user inputs

<div class="signup-form">
    <form method="post" class="form-horizontal">
      	<div class="row">
        	<div class="col-8 offset-4">
				<h2>Sign Up</h2>
			</div>	
      	</div>			
        <div class="form-group row">
			<label class="col-form-label col-4">Name</label>
			<div class="col-8">
                <input type="text" class="form-control" name="empname" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<label class="col-form-label col-4">Email</label>
			<div class="col-8">
                <input type="email" class="form-control" name="empemail" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<label class="col-form-label col-4">Mobile</label>
			<div class="col-8">
                <input type="text" class="form-control" name="empmobile" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<label class="col-form-label col-4">Department</label>
			<div class="col-8">
                <input type="text" class="form-control" name="empdept" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<div class="col-8 offset-4">

				<button type="submit" name="submit" class="btn btn-primary btn-lg">Submit</button>
			</div>  
		</div>		      
    </form>
</div>

</div>

</div>

<label class="col-form-label col-4">Email</label>

</div>

<label class="col-form-label col-4">Mobile</label>

</div>

<label class="col-form-label col-4">Department</label>

</div>

<button type="submit" name="submit" class="btn btn-primary btn-lg">Submit</button>

</div>

</form>

</div>

Now get user inputs and store them in the PHP variables

$ename=$_POST['empname'];
$eemail=$_POST['empemail'];
$emobile=$_POST['empmobile'];
$edept=$_POST['empdept'];

$ename=$_POST['empname'];

$eemail=$_POST['empemail'];

$emobile=$_POST['empmobile'];

$edept=$_POST['empdept'];

Query for inserting data into PostgreSQL using PHP

$result = pg_query($conn, "insert into tblemployee(empname,empemailid,empmobileno,empdepartment) values('$ename','$eemail','$emobile','$edept')");

if ($result) {
    echo "Data inserted successfully!";
} else {
    echo "Error: " . pg_last_error($conn);
}

$result = pg_query($conn, "insert into tblemployee(empname,empemailid,empmobileno,empdepartment) values('$ename','$eemail','$emobile','$edept')");

if ($result) {

echo "Data inserted successfully!";

} else {

echo "Error: " . pg_last_error($conn);

}

Full PHP Script for inserting data into the database PostgreSQL

<?php include_once('dbcon.php');
if(isset($_POST['submit']))
{
$ename=$_POST['empname'];
$eemail=$_POST['empemail'];
$emobile=$_POST['empmobile'];
$edept=$_POST['empdept'];

// Execute the query with parameters
$result = pg_query($conn, "insert into tblemployee(empname,empemailid,empmobileno,empdepartment) values('$ename','$eemail','$emobile','$edept')");

if ($result) {
    echo "Data inserted successfully!";
} else {
    echo "Error: " . pg_last_error($conn);
}
// Close the connection
pg_close($conn);
}
?>

<?php include_once('dbcon.php');

if(isset($_POST['submit']))

{

$ename=$_POST['empname'];

$eemail=$_POST['empemail'];

$emobile=$_POST['empmobile'];

$edept=$_POST['empdept'];

// Execute the query with parameters

$result = pg_query($conn, "insert into tblemployee(empname,empemailid,empmobileno,empdepartment) values('$ename','$eemail','$emobile','$edept')");

if ($result) {

echo "Data inserted successfully!";

} else {

echo "Error: " . pg_last_error($conn);

}

// Close the connection

pg_close($conn);

}

Here is the full code that we have written during this tutorial:

<?php include_once('dbcon.php');
if(isset($_POST['submit']))
{
$ename=$_POST['empname'];
$eemail=$_POST['empemail'];
$emobile=$_POST['empmobile'];
$edept=$_POST['empdept'];

// Execute the query with parameters
$result = pg_query($conn, "insert into tblemployee(empname,empemailid,empmobileno,empdepartment) values('$ename','$eemail','$emobile','$edept')");

if ($result) {
    echo "Data inserted successfully!";
} else {
    echo "Error: " . pg_last_error($conn);
}
// Close the connection
pg_close($conn);
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700">
<title>Data insertion in PostgreSQL usinh PHP</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
<style>
body {
	color: #999;
	background: #f3f3f3;
	font-family: 'Roboto', sans-serif;
}
.form-control {
	border-color: #eee;
	min-height: 41px;
	box-shadow: none !important;
}
.form-control:focus {
	border-color: #5cd3b4;
}
.form-control, .btn {        
	border-radius: 3px;
}
.signup-form {
	width: 500px;
	margin: 0 auto;
	padding: 30px 0;
}
.signup-form h2 {
	color: #333;
	margin: 0 0 30px 0;
	display: inline-block;
	padding: 0 30px 10px 0;
	border-bottom: 3px solid #5cd3b4;
}
.signup-form form {
	color: #999;
	border-radius: 3px;
	margin-bottom: 15px;
	background: #fff;
	box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3);
	padding: 30px;
}
.signup-form .form-group row {
	margin-bottom: 20px;
}
.signup-form label {
	font-weight: normal;
	font-size: 14px;
	line-height: 2;
}
.signup-form input[type="checkbox"] {
	position: relative;
	top: 1px;
}
.signup-form .btn {        
	font-size: 16px;
	font-weight: bold;
	background: #5cd3b4;
	border: none;
	margin-top: 20px;
	min-width: 140px;
}
.signup-form .btn:hover, .signup-form .btn:focus {
	background: #41cba9;
	outline: none !important;
}
.signup-form a {
	color: #5cd3b4;
	text-decoration: underline;
}
.signup-form a:hover {
	text-decoration: none;
}
.signup-form form a {
	color: #5cd3b4;
	text-decoration: none;
}	
.signup-form form a:hover {
	text-decoration: underline;
}
</style>
</head>
<body>
<div class="signup-form">
    <form method="post" class="form-horizontal">
      	<div class="row">
        	<div class="col-8 offset-4">
				<h2>Sign Up</h2>
			</div>	
      	</div>			
        <div class="form-group row">
			<label class="col-form-label col-4">Name</label>
			<div class="col-8">
                <input type="text" class="form-control" name="empname" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<label class="col-form-label col-4">Email</label>
			<div class="col-8">
                <input type="email" class="form-control" name="empemail" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<label class="col-form-label col-4">Mobile</label>
			<div class="col-8">
                <input type="text" class="form-control" name="empmobile" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<label class="col-form-label col-4">Department</label>
			<div class="col-8">
                <input type="text" class="form-control" name="empdept" required="required">
            </div>        	
        </div>
		<div class="form-group row">
			<div class="col-8 offset-4">

				<button type="submit" name="submit" class="btn btn-primary btn-lg">Submit</button>
			</div>  
		</div>		      
    </form>
</div>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

<?php include_once('dbcon.php');

if(isset($_POST['submit']))

{

$ename=$_POST['empname'];

$eemail=$_POST['empemail'];

$emobile=$_POST['empmobile'];

$edept=$_POST['empdept'];

// Execute the query with parameters

$result = pg_query($conn, "insert into tblemployee(empname,empemailid,empmobileno,empdepartment) values('$ename','$eemail','$emobile','$edept')");

if ($result) {

echo "Data inserted successfully!";

} else {

echo "Error: " . pg_last_error($conn);

}

// Close the connection

pg_close($conn);

}

<!DOCTYPE html>

<head>

<title>Data insertion in PostgreSQL usinh PHP</title>

<style>

body {

color: #999;

background: #f3f3f3;

font-family: 'Roboto', sans-serif;

}

.form-control {

border-color: #eee;

min-height: 41px;

box-shadow: none !important;

}

.form-control:focus {

border-color: #5cd3b4;

}

.form-control, .btn {

border-radius: 3px;

}

.signup-form {

width: 500px;

margin: 0 auto;

padding: 30px 0;

}

.signup-form h2 {

color: #333;

margin: 0 0 30px 0;

display: inline-block;

padding: 0 30px 10px 0;

border-bottom: 3px solid #5cd3b4;

}

.signup-form form {

color: #999;

border-radius: 3px;

margin-bottom: 15px;

background: #fff;

box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3);

padding: 30px;

}

.signup-form .form-group row {

margin-bottom: 20px;

}

.signup-form label {

font-weight: normal;

font-size: 14px;

line-height: 2;

}

.signup-form input[type="checkbox"] {

position: relative;

top: 1px;

}

.signup-form .btn {

font-size: 16px;

font-weight: bold;

background: #5cd3b4;

border: none;

margin-top: 20px;

min-width: 140px;

}

.signup-form .btn:hover, .signup-form .btn:focus {

background: #41cba9;

outline: none !important;

}

.signup-form a {

color: #5cd3b4;

text-decoration: underline;

}

.signup-form a:hover {

text-decoration: none;

}

.signup-form form a {

color: #5cd3b4;

text-decoration: none;

}

.signup-form form a:hover {

text-decoration: underline;

}

</style>

</head>

<body>

</div>

</div>

<label class="col-form-label col-4">Email</label>

</div>

<label class="col-form-label col-4">Mobile</label>

</div>

<label class="col-form-label col-4">Department</label>

</div>

<button type="submit" name="submit" class="btn btn-primary btn-lg">Submit</button>

</div>

</form>

</div>

</body>

</html>

PHP-PostgreSQL Data Insertion Script (Download Source Code)

Size: 311 KB

Version: V 1

Download Script !

How to insert data using PostgreSQL and PHP

You may also like...

PHP-PostgreSQL Tutorials

How to insert data using PostgreSQL and PHP

You may also like...

User Registration and Login using PHP and PostgreSQL

How to delete data from PostgreSQL using PHP

How to update the Data in PostgreSQL using PHP

How to fetch data from PostgreSQL using PHP

How to connect Postgre SQL with PHP

How to Enable PostgreSQL to Work with PHP

PHP-PostgreSQL Tutorials