list update in php after delete data using ajax

Here is my code. I am trying to delete selected data from the database using AJAX, and after successfully deleting the data, I am thinking about how to update and refresh the data in #memo_list. I’ve tried several approaches but am having difficulty, so I am posting this question. Does anyone know a solution to this?

PHP:

<form id="deleteForm">
    <table class="memo_list">
        <thead>
            <tr>
                <th>memo</th>
                <th>select </th>
            </tr>
        </thead>
        <tbody>
<?
    $sql = " select * from TABLE where member_id = 'member_id' order by datetime ";
    $result = sql_query($sql);

    for($i = 0; $row = sql_fetch_array($result); $i++) { 
?>

            <tr >
                <td><?=$row['memo']?></td>
                <td><input type="checkbox" name="id" value="<?=$row['id']?>"></td>
            </tr>
        </tbody>
    </table>

    <button type="button" id="deleteBtn">Delete Selected</button>
    </form>

...

<script>
        document.getElementById("deleteBtn").addEventListener("click", function() {
            // collect selected items
            
            });

            // 
            if (selectedItems.length === 0) {
                // nothing
                return;
            }

            // AJAX 
            var jsonString = JSON.stringify(selectedItems);
            $.ajax({
                    type: "POST",
                    url: "./_ajax.delete_call.php",
                    data: {data : jsonString}, 
                    cache: false,

                    success: function(){
                        alert("OK");
                    }
                });
        });
    </script>

AJAX(_ajax.delete_call.php) :

<?
include_once("./_common.php");

    $data = json_decode(stripslashes($_POST['data']));
    
    // here i would like use foreach:
    foreach($data as $d){
        sql_query("delete from TABLE where id = '{$d}'");
    }
    $msg = "";

?>

You need to sign in to view this answers