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
Leave feedback about this