我有一个带有mysql数据的表,我添加了一个垃圾桶按钮,我想用ajax函数单击垃圾桶按钮时删除每一行,这是我的html:
$sql ="SELECT * FROM music";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_object($result)){
echo '
'.$row->file_name.''.$row->composer.''.$row->lyric.''.$row->music_thumb.''.'جذف کردن
'.'
';}
?>
和我的ajax功能在这里:
$(function(){
$('.trash').click(function(){
var del_id= $(this).attr('id');
var $ele = $(this).parent().parent();
$.ajax({
type:'POST',
url:'delete.php',
data:del_id,
success: function(data){
if(data=="YES"){
$ele.fadeOut().remove();
}else{
alert("can't delete the row")
}
}
})
})
});
还有我的“ delete.php”页面:
include('../db_inc.php');
$music_number = "POST['del_id']";
echo '$music_number';
$qry = "DELETE FROM music WHERE msuic_id ='$music_number'";
$result=mysql_query($qry);
?>
我认为我的问题是ajax函数;谢谢