首先,所有ID均不应重复,而应使用类选择器。您也可以使用自定义数据属性来存储文章的ID。
尝试
<h4>Select an Article to Delete:</h4>
<div id="message"></div>
<?PHP foreach ($articles as $article) { ?>
<span><?PHP echo $article['article_title']; ?></span>
<a href="#" class="link" data-artid="<?PHP echo $article['article_id']; ?>">Delete</a><br />
<?PHP } ?>
脚本
<script type="text/javascript">
$(function(){
$('.link').click(function(){
var elem = $(this);
$.ajax({
type: "GET",
url: "deleteAtc.PHP",
data: "id="+elem.attr('data-artid'),
dataType:"json",
success: function(data) {
if(data.success){
elem.hide();
$('#message').html(data.message);
}
}
});
return false;
});
});
</script>
而在服务器端
<?PHP
session_start();
include_once('../includes/connection.PHP');
if (isset($_SESSION['logged_in'])) {
if (isset($_GET['id'])) {
$id = $_GET['id'];
$query = $pdo->prepare('DELETE FROM articles WHERE article_id = ?');
$query->bindValue(1, $id);
$query->execute();
//Also try to handle false conditions or failure
echo json_encode(array('success'=>TRUE,'message'=>"Article deleted"));
}
}
?>