Retrieve data from database and display in php form

As we already see “how to insert data in mysql using php form“. But if want to edit some information in that form how will I do that? Should I directly update form without seeing the previous data? Or should I check my previous data first and then update specific data?

Answer is obvious that first I have to look at previous data then I will update that. But how to get data and display in form

Don’t worry in this post I am going to show how to retrieve data from database and display in php form.

I am taking my previous example of insert data. In that post I created a form with title and content field only. So this time I am not going to create database and table because i already created both of them in my previous post. Now let’s start

Create database connection:


<?php 
$host = "localhost";
$user = "root";
$pass = "";
$db = "demo";
 
$conn = mysqli_connect($host,$user,$pass, $db);
if(!$conn)
{
die("Connection failed: " . mysqli_connect_error());
}
?>

<?php

$host = "localhost";

$user = "root";

$pass = "";

$db = "demo";

$conn = mysqli_connect($host,$user,$pass, $db);

if(!$conn)

{

die("Connection failed: " . mysqli_connect_error());

}

Retrieve Data from Database:


<?php 
	$sql = "select * from posts where id = 1";
	$rs = mysqli_query($conn, $sql);

	$fetchRow = mysqli_fetch_assoc($rs);
?>

<?php

$sql = "select * from posts where id = 1";

$rs = mysqli_query($conn, $sql);

$fetchRow = mysqli_fetch_assoc($rs);

In above php code I get the row which id is 1. mysqli_fetch_assoc() function will return that specific row as an array (which holds title and content) and I store that array in $fetchRow variable.

FORM HTML:

Now I get the row from the database it’s time to show each column data into its respective fields.


<div class="container">
	<h3>Add Post</h3>
	<form action="" method="post">
		<input type="text" name="title" value="<?php echo $fetchRow['post_title']?>" required>
		<textarea cols="40" placeholder="Post Content" rows="8" name="post_content" required><?php echo $fetchRow['post_content']?></textarea>
		<button type="submit" name="submit">Submit</button>
	</form>
</div>

<input type="text" name="title" value="<?php echo $fetchRow['post_title']?>" required>

<button type="submit" name="submit">Submit</button>

</form>

</div>

After that above changes your form will look like this.

Apply CSS:


body{font-family:verdana;}
.container{width:500px;margin: 0 auto;}
h3{line-height:20px;font-size:20px;}
input{display:block;width:350px;height:20px;margin:10px 0;}
textarea{display:block;width:350px;margin:10px 0;}
button{background:green; border:1px solid green;width:70px;height:30px;color:#ffffff}

body{font-family:verdana;}

.container{width:500px;margin: 0 auto;}

h3{line-height:20px;font-size:20px;}

input{display:block;width:350px;height:20px;margin:10px 0;}

textarea{display:block;width:350px;margin:10px 0;}

button{background:green; border:1px solid green;width:70px;height:30px;color:#ffffff}

All Together


<?php 
$host = "localhost";
$user = "root";
$pass = "";
$db = "demo";

$conn = mysqli_connect($host,$user,$pass, $db);
if(!$conn)
{
	die("Connection failed: " . mysqli_connect_error());
}

?>

<?php 
	$sql = "select * from posts where id = 1";
	$rs = mysqli_query($conn, $sql);
	//get row
	$fetchRow = mysqli_fetch_assoc($rs);
?> 



<!DOCTYPE html>
<html>
<head>	
<title> Retrieve data from database and display in php form</title>

<style>
	body{
		font-family:verdana;
	}
	.container{width:500px;margin: 0 auto;}
	h3{line-height:20px;font-size:20px;}
	input{display:block;width:350px;height:20px;margin:10px 0;}
	textarea{display:block;width:350px;margin:10px 0;}
	button{background:green; border:1px solid green;width:70px;height:30px;color:#ffffff}
</style>


</head>	
<body>

	
	
	<div class="container">
	<h3>Edit Post</h3>
	<form action="" method="post">
	<input type="text" name="title" value="<?php echo $fetchRow['post_title']?>" required>
	<textarea cols="40" placeholder="Post Content" rows="8" name="post_content" required><?php echo $fetchRow['post_content']?></textarea>
	<button type="submit" name="submit">Submit</button>
	</form>
	</div> 


</body>
</html>

<?php

$host = "localhost";

$user = "root";

$pass = "";

$db = "demo";

$conn = mysqli_connect($host,$user,$pass, $db);

if(!$conn)

{

die("Connection failed: " . mysqli_connect_error());

}

<?php

$sql = "select * from posts where id = 1";

$rs = mysqli_query($conn, $sql);

//get row

$fetchRow = mysqli_fetch_assoc($rs);

<!DOCTYPE html>

<html>

<head>

<title> Retrieve data from database and display in php form</title>

<style>

body{

font-family:verdana;

}

.container{width:500px;margin: 0 auto;}

h3{line-height:20px;font-size:20px;}

input{display:block;width:350px;height:20px;margin:10px 0;}

textarea{display:block;width:350px;margin:10px 0;}

button{background:green; border:1px solid green;width:70px;height:30px;color:#ffffff}

</style>

</head>

<body>

<input type="text" name="title" value="<?php echo $fetchRow['post_title']?>" required>

<button type="submit" name="submit">Submit</button>

</form>

</div>

</body>

</html>

Retrieve data from database and display in php form

Create database connection:

Retrieve Data from Database:

FORM HTML:

Apply CSS:

All Together

More from WDB24.com

Published by Ahsan Zameer

Leave a Reply Cancel reply