Deleting records in Ajax based paging script.We have seen how Ajax can be used to create record breaking per page. Now we will add delete record facility to this Ajax code so users can click a delete button to remove that particular record.
You are advised to first read the basic Ajax based paging script before continuing with this tutorial.
From the student table you have seen each record has one unique id associated with each student. This unique ID we will pass to the PHP script using Ajax to delete that particular record. The passing of ID to the main PHP script is the only extra part added to the original Ajax based paging script.
We have added messaging part to the script so we can communicate better with the visitors. After deletion of record a message is returned by Server side script saying the status of the operation.
Ajax & PHP scripts Creating XMLHttp object in different browsers Sample Code: Get Method of Ajax form submission Server Clock:: Display real-time date and time of server Dependant drop down list box using Ajax & PHP Email validation using Ajax in a form Getting customer details by entering customer id using Ajax Progress Bar using Ajax Progress Bar using MySQL PHP & Ajax Displaying Message at client side using Ajax & PHP Web page HTML form validation using Ajax and PHP Form validation with onBlur event using Ajax and PHP
Json support in PHP json_encode to generate Json string from PHP Array data Json Data formatting to return database records to main script Searching MySql database as we type using Ajax Displaying all records based on selection of a drop down list box