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;

Code of index.php

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

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

0Shares

1 thought on “How To update Record In PHP And MYSQL Database?”

admit says:
November 25, 2018 at 6:08 pm
Heya i’m for the first time here. I found this
board and I find It truly useful & it helped me out much.
I hope to give something back and help others like you helped me.