How to update the Data in PostgreSQL using PHP

In this tutorial, we will learn how to update the record or data in PostgreSQL using PHP.

File structure for this tutorial

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

read.php: This is used for HTML Table and we will also put the PHP code here for data fetch/read.

edit.php: This file is sued to update the particular record on the basis of the row id.

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;

}

Read / Fetch the particular record (read.php)

create read.php file. For fetching a record we have to get the row id of that record and store in $empid. We access the $_GET[‘id’] variable to do it.
Code for gets a record based on the given id.

     <table class="table table-striped mt-4">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Name</th>
                        <th>Email Id</th>
                        <th>Mobile No</th>
                        <th>Department</th>
                        <th>Creation Date</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
<?php $query= pg_query($conn,"select * from tblemployee");
$cnt=1;
while($row=pg_fetch_array($query)){
?>

                    <tr>
                        <td><?php echo $cnt;?></td>
                        <td><?php echo $row['empname'];?></td>
                        <td><?php echo $row['empemailid'];?></td>
                        <td><?php echo $row['empmobileno'];?></td>
                        <td><?php echo $row['empdepartment'];?></td>
                        <td><?php echo $row['creationdate'];?></td>
                        <td><a href="edit.php?id=<?php echo $row['id'];?>" class="btn btn-info btn-sm">Edit</td>
                    </tr>
                <?php $cnt++;} ?>
                     
                </tbody>
            </table>

<thead>

<tr>

<th>Email Id</th>

<th>Mobile No</th>

<th>Department</th>

<th>Creation Date</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php $query= pg_query($conn,"select * from tblemployee");

$cnt=1;

while($row=pg_fetch_array($query)){

<tr>

<td><a href="edit.php?id=<?php echo $row['id'];?>" class="btn btn-info btn-sm">Edit</td>

</tr>

<?php $cnt++;} ?>

</tbody>

</table>

Now Fetch the data in the HTML Form.

create edit.php file. For updating a record we have to get the row id of that record and store in $empid. We access the $_GET[‘id’] variable to do it.
Code for gets a record based on the given id. Through this way, we can get data autofill-data in HTML Form.

<form method="post" class="form-horizontal">
<?php 
$empid=$_GET['id'];
$query= pg_query($conn,"select * from tblemployee where id='$empid'");
$cnt=1;
while($row=pg_fetch_array($query)){
?>


        <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" value="<?php echo $row['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" value="<?php echo $row['empemailid'];?>" 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" value="<?php echo $row['empmobileno'];?>" 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" value="<?php echo $row['empdepartment'];?>" required="required">
            </div>        	
        </div>

<div class="form-group row">
<label class="col-form-label col-4">Creation Date</label>
<div class="col-8">
 <input type="text" class="form-control" name="cdate" value="<?php echo $row['creationdate'];?>" readonly>
  </div>        	
   </div>
   <?php } ?>
		
<div class="form-group row">
<div class="col-8 offset-4">
<button type="submit" name="update" class="btn btn-primary btn-lg">Update</button>
</div>  
</div>	
 </form>

<?php

$empid=$_GET['id'];

$query= pg_query($conn,"select * from tblemployee where id='$empid'");

$cnt=1;

while($row=pg_fetch_array($query)){

<input type="text" class="form-control" name="empname" value="<?php echo $row['empname'];?>" required="required">

</div>

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

<input type="email" class="form-control" name="empemail" value="<?php echo $row['empemailid'];?>" required="required">

</div>

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

<input type="text" class="form-control" name="empmobile" value="<?php echo $row['empmobileno'];?>" required="required">

</div>

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

<input type="text" class="form-control" name="empdept" value="<?php echo $row['empdepartment'];?>" required="required">

</div>

<label class="col-form-label col-4">Creation Date</label>

<input type="text" class="form-control" name="cdate" value="<?php echo $row['creationdate'];?>" readonly>

</div>

<?php } ?>

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

</div>

</form>

Code for update the particular record. Put this code on the top of the edit.php

<?php include_once('dbcon.php');
if(isset($_POST['update']))
{
$ename=$_POST['empname'];
$eemail=$_POST['empemail'];
$emobile=$_POST['empmobile'];
$edept=$_POST['empdept'];
$empid=$_GET['id'];
// Execute the query with parameters
$result = pg_query($conn, "update tblemployee set empname='$ename',empemailid='$eemail',empmobileno='$emobile',empdepartment='$edept' where id='$empid'");

if ($result) {
     echo '<script>alert("Employee Details updated successfully!")</script>';
    echo "<script type='text/javascript'> document.location = 'read.php'; </script>";
} else {
    echo "Error: " . pg_last_error($conn);
}
// Close the connection
pg_close($conn);
}
?>

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

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

{

$ename=$_POST['empname'];

$eemail=$_POST['empemail'];

$emobile=$_POST['empmobile'];

$edept=$_POST['empdept'];

$empid=$_GET['id'];

// Execute the query with parameters

$result = pg_query($conn, "update tblemployee set empname='$ename',empemailid='$eemail',empmobileno='$emobile',empdepartment='$edept' where id='$empid'");

if ($result) {

echo '<script>alert("Employee Details updated successfully!")</script>';

echo "<script type='text/javascript'> document.location = 'read.php'; </script>";

} else {

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

}

// Close the connection

pg_close($conn);

}

Here is the full code written in the edit.php

<?php include_once('dbcon.php');
if(isset($_POST['update']))
{
$ename=$_POST['empname'];
$eemail=$_POST['empemail'];
$emobile=$_POST['empmobile'];
$edept=$_POST['empdept'];
$empid=$_GET['id'];
// Execute the query with parameters
$result = pg_query($conn, "update tblemployee set empname='$ename',empemailid='$eemail',empmobileno='$emobile',empdepartment='$edept' where id='$empid'");

if ($result) {
     echo '<script>alert("Employee Details updated successfully!")</script>';
    echo "<script type='text/javascript'> document.location = 'read.php'; </script>";
} 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 Updation  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">

      	<div class="row">
        	<div class="col-12">
				<h2>Update Employee Data</h2>
			</div>	
      	</div>			
    <form method="post" class="form-horizontal">
<?php 
$empid=$_GET['id'];
$query= pg_query($conn,"select * from tblemployee where id='$empid'");
$cnt=1;
while($row=pg_fetch_array($query)){
?>


        <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" value="<?php echo $row['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" value="<?php echo $row['empemailid'];?>" 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" value="<?php echo $row['empmobileno'];?>" 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" value="<?php echo $row['empdepartment'];?>" required="required">
            </div>        	
        </div>

        	<div class="form-group row">
			<label class="col-form-label col-4">Creation Date</label>
			<div class="col-8">
                <input type="text" class="form-control" name="cdate" value="<?php echo $row['creationdate'];?>" readonly>
            </div>        	
        </div>
    <?php } ?>
		<div class="form-group row">
			<div class="col-8 offset-4">

				<button type="submit" name="update" class="btn btn-primary btn-lg">Update</button>
			</div>  
		</div>	
 </form>
		<div class="form-group row">
			<div class="col-8">
    <a href="read.php" style="color:red">View Data</a>
            </div>        	
        </div>


</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

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

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

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

{

$ename=$_POST['empname'];

$eemail=$_POST['empemail'];

$emobile=$_POST['empmobile'];

$edept=$_POST['empdept'];

$empid=$_GET['id'];

// Execute the query with parameters

$result = pg_query($conn, "update tblemployee set empname='$ename',empemailid='$eemail',empmobileno='$emobile',empdepartment='$edept' where id='$empid'");

if ($result) {

echo '<script>alert("Employee Details updated successfully!")</script>';

echo "<script type='text/javascript'> document.location = 'read.php'; </script>";

} else {

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

}

// Close the connection

pg_close($conn);

}

<!DOCTYPE html>

<head>

<title>Data Updation 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>

<h2>Update Employee Data</h2>

</div>

<?php

$empid=$_GET['id'];

$query= pg_query($conn,"select * from tblemployee where id='$empid'");

$cnt=1;

while($row=pg_fetch_array($query)){

<input type="text" class="form-control" name="empname" value="<?php echo $row['empname'];?>" required="required">

</div>

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

<input type="email" class="form-control" name="empemail" value="<?php echo $row['empemailid'];?>" required="required">

</div>

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

<input type="text" class="form-control" name="empmobile" value="<?php echo $row['empmobileno'];?>" required="required">

</div>

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

<input type="text" class="form-control" name="empdept" value="<?php echo $row['empdepartment'];?>" required="required">

</div>

<label class="col-form-label col-4">Creation Date</label>

<input type="text" class="form-control" name="cdate" value="<?php echo $row['creationdate'];?>" readonly>

</div>

<?php } ?>

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

</div>

</form>

</div>

</body>

</html>

PHP-PostgreSQL Data Update/Edit Script (Download Source Code)

Size: 314 KB

Version: V 1.0

Download Now!

How to update the Data in PostgreSQL using PHP

Recommended Tutorials for you

You may also like...

PHP-PostgreSQL Tutorials

How to update the Data in PostgreSQL using PHP

Recommended Tutorials for you

You may also like...

How to fetch data from PostgreSQL using PHP

How to delete data from PostgreSQL using PHP

How to connect Postgre SQL with PHP

PHP-PostgreSQL Tutorials