PHP Inline Deleting Data using jQuery AJAX

Submitted by alpha_luna on Tuesday, September 6, 2016 - 14:59.

In the previous tutorial, we have done for the tutorials of Inline Editing Data and Inline Adding Data. This simple tutorial, we are going to perform the Delete function. This kind of simple tutorial suited for the beginners who want to learn delete function You can also check the live demo of this simple tutorial, so you can get an idea and you can try this out, let's start coding.

DELETE Statement Use this simple Delete Statement to delete the data in the database. Copy and paste this into your editor and save it as "delete.php".

<?php
require_once("database.php");
$result_query = new DeleteInlineForm();
 
if(!empty($_POST['id'])) {
        $id = $_POST['id'];
        $query = "DELETE FROM  tbl_products_inline WHERE id = '$id' ";
        $result_query->executeQuery($query);
}
?>

Create HTML Content This simple source code shows the simple content that we have where the user can delete data in the table.

<table class="tbl-qa">
  <thead>
        <tr>
          <th class="table-header">Product Name</th>
          <th class="table-header">Product Quantity</th>
          <th class="table-header">Action</th>
        </tr>
  </thead>
  <tbody id="table-body">
        <?php
        if(!empty($row_product)) { 
        foreach($row_product as $k=>$v) {
          ?>
          <tr class="table-row" id="table-row-<?php echo $row_product[$k]["id"]; ?>">
                <td contenteditable="true" onBlur="saveToDatabase(this,'product_name','<?php echo $row_product[$k]["id"]; ?>')" onClick="editRow(this);">
                        <?php echo $row_product[$k]["product_name"]; ?>
                </td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'product_qty','<?php echo $row_product[$k]["id"]; ?>')" onClick="editRow(this);">
                        <?php echo $row_product[$k]["product_qty"]; ?>
                </td>
                <td>
                        <a class="ajax-action-links" onclick="deleteRecord(<?php echo $row_product[$k]["id"]; ?>);">
                                Delete
                        </a>
                </td>
          </tr>
          <?php
        }
        }
        ?>
  </tbody>
</table>
<div class="add-data-style" id="add-more" onClick="createNew();">Add More</div>

Output

Read Also:

Inline Editing Data
Inline Adding Data

For the full source code, kindly click the "Download Code" button below. If you try all the examples, you will learn a lot about PHP, in a very short time! Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.