Record insert, delete fetch and update through PHP coding with database connection at

[sneha billore]

How to insert, delete, update and fetch record in the database using PHP coding at same page with database connection.

[johny10151981]

You want people to write a book for you? better yet buy a book and start reading

[ayukawaa]

Use at the same time actions readed from the GET and POST.

First, look for the action in the $_GET (insert/update/delete) and show the form based in the action given (see below).

If the action does not exist, show a table with the LIST of the records from the database.

In each row, add the actions like this

<a href="index.php?action=update&id=<?php echo $row_id;?>">UPDATE</a> 
<a href="index.php?action=delete&id=<?php echo $row_id;?>">DELETE</a>

Next, you should look for an action in the $_POST (update/delete)

This is for example the form that should be show when getting an action=update from the GET (read above)

<form action="index.php?action=update" method="post" name="form1" id="form1">
<input type="hidden" name="action" value="update">
...
</form>

And of course, when detecting something from the $_POST, you should save it to the database...

if ((isset($_POST["action"])) && ($_POST["action"] == "update")) {
  $updateSQL = "UPDATE ....................
}

Hope that this helps....