How can INSERT/DELETE operations be executed directly on the main page in PHP and then update the results without opening a new page?

To execute INSERT/DELETE operations directly on the main page in PHP without refreshing the page, you can use AJAX to send requests to the server asynchronously. This allows you to update the results on the page without the need to open a new page. By using AJAX, you can interact with the server in the background and dynamically update the content on the main page. 

```php
<!-- HTML code for the main page -->
<!DOCTYPE html>
<html>
<head>
    <title>AJAX Example</title>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
</head>
<body>
    <div id="results">
        <!-- Display the results here -->
    </div>
    
    <button id="insertBtn">Insert Data</button>
    <button id="deleteBtn">Delete Data</button>

    <script>
        $(document).ready(function(){
            $("#insertBtn").click(function(){
                $.ajax({
                    url: 'insert.php',
                    type: 'POST',
                    success: function(response){
                        $('#results').html(response);
                    }
                });
            });

            $("#deleteBtn").click(function(){
                $.ajax({
                    url: 'delete.php',
                    type: 'POST',
                    success: function(response){
                        $('#results').html(response);
                    }
                });
            });
        });
    </script>
</body>
</html>
```

In this code snippet, we have HTML elements for displaying results and buttons for inserting and deleting data. When a button is clicked, an AJAX request is sent to the server to execute the corresponding operation (insert or delete). The server-side scripts 'insert.php' and 'delete.php' handle the database operations and return the updated results, which are then displayed on the main page without refreshing it.

Keywords

PHP AJAX jQuery MySQL DOM manipulation

Related Questions