How To update Record In PHP And MYSQL Database?

In this tutorial, we will try to learn the about the updating records in the database table in PHP and MySQL.

Code of updating of records in the database table in PHP and MySQL.

We can have two pages;

index.php

update.php

Code of index.php by using MySQL and without MySQLi.

<?php
mysql_select_db('publisher',mysql_connect('localhost','root',''));
?>
<html><body>
<table border="1">
<?php
$books_query=mysql_query("select * from books");
while($books_rows=mysql_fetch_array($books_query)){
?>
<tr>
<td><?php echo $books_rows['BookID'] ; ?></td>
<td><?php echo $books_rows['BookTitleAttribute'] ; ?></td>
<td><a href="update.php<?php echo '?id='.$books_rows['BookID']; ?>">Edit</a></td>
</tr>
<?php }?>
</table>
</body></html>

<?php

mysql_select_db('publisher',mysql_connect('localhost','root',''));

<?php

$books_query=mysql_query("select * from books");

while($books_rows=mysql_fetch_array($books_query)){

<tr>

</tr>

<?php }?>

</table>

</body></html>

Code of update.php by using MySQL and without MySQLi.

<?php
mysql_select_db('publisher',mysql_connect('localhost','root','')); 
$id=$_GET['id'];
?>
<html><body>
<form method="post">
<table>
<?php $books_query=mysql_query("select * from books where BookID='$id'");
$books_rows=mysql_fetch_array($books_query);
?>
<tr><td>Title:</td><td><input type="text" name="TextBoxForTitle" value="<?php echo $books_rows['BookTitleAttribute'];  ?>"></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="save"></td></tr>
</table></form></body></html>
<?php 
if (isset($_POST['submit'])){
$TitleVariable=$_POST['TextBoxForTitle'];
 mysql_query("update books set BookTitleAttribute='$TitleVariable' where BookID='$id'");
header('location:index.php');
}
?>

<?php

mysql_select_db('publisher',mysql_connect('localhost','root',''));

$id=$_GET['id'];

<table>

<?php $books_query=mysql_query("select * from books where BookID='$id'");

$books_rows=mysql_fetch_array($books_query);

<tr><td>Title:</td><td><input type="text" name="TextBoxForTitle" value="<?php echo $books_rows['BookTitleAttribute']; ?>"></td></tr>

</table></form></body></html>

<?php

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

$TitleVariable=$_POST['TextBoxForTitle'];

mysql_query("update books set BookTitleAttribute='$TitleVariable' where BookID='$id'");

header('location:index.php');

}

Database

Code of index.php by using MySQLi.

<?php
$conn = mysqli_connect('localhost','root','','publisher');
?>
<html><body>
<table border="1">
<?php
$books_query=mysqli_query($conn, "select * from books");
while($books_rows=mysqli_fetch_array($books_query)){
?>
<tr>
<td><?php echo $books_rows['BookID'] ; ?></td>
<td><?php echo $books_rows['BookTitleAttribute'] ; ?></td>
<td><a href="update.php<?php echo '?id='.$books_rows['BookID']; ?>">Edit</a></td>
</tr>
<?php }?>
</table>
</body></html>

<?php

$conn = mysqli_connect('localhost','root','','publisher');

<?php

$books_query=mysqli_query($conn, "select * from books");

while($books_rows=mysqli_fetch_array($books_query)){

<tr>

</tr>

<?php }?>

</table>

</body></html>

Code of update.php by using MySQLi.

<?php
$conn = mysqli_connect('localhost','root','','publisher');
$id=$_GET['id'];
?>
<html><body>
<form method="post">
<table>
<?php $books_query=mysqli_query($conn,"select * from books where BookID='$id'");
$books_rows=mysqli_fetch_array($books_query);
?>
<tr><td>Title:</td><td><input type="text" name="TextBoxForTitle" value="<?php echo $books_rows['BookTitleAttribute'];  ?>"></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="save"></td></tr>
</table></form></body></html>
<?php 
if (isset($_POST['submit'])){
$TitleVariable=$_POST['TextBoxForTitle'];
 mysqli_query($conn,"update books set BookTitleAttribute='$TitleVariable' where BookID='$id'");
header('location:index.php');
}
?>

<?php

$conn = mysqli_connect('localhost','root','','publisher');

$id=$_GET['id'];

<table>

<?php $books_query=mysqli_query($conn,"select * from books where BookID='$id'");

$books_rows=mysqli_fetch_array($books_query);

<tr><td>Title:</td><td><input type="text" name="TextBoxForTitle" value="<?php echo $books_rows['BookTitleAttribute']; ?>"></td></tr>

</table></form></body></html>

<?php

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

$TitleVariable=$_POST['TextBoxForTitle'];

mysqli_query($conn,"update books set BookTitleAttribute='$TitleVariable' where BookID='$id'");

header('location:index.php');

}

Video Lecture

PHP updates the SQL database from the form.
PHP code for updating data in the MySQL database.
how to update data in PHP using form mysqli.
how to fetch and update data from the database in PHP.
update query in PHP MySQL ( with example).
how to edit data in PHP using the form.
PHP update MySQL with variables.
edit form in PHP with example.

Video Lecture

Related Posts: