I want to delete value from database using PHP.
Using a table row and placed a button like "Delete" and I create a function like onClick='window.location='page.php?action=del&id=1' and in PHP for delete.
if($_REQUEST['action'] == 'del'){
$req_id = $_REQUEST['id'];
$del_query = mysql_query("DELETE FROM table WHERE id='$req_id'");
}
It's working well but, I don't want to refresh the page. Please tell me how can I do it without page refresh?
<button id='delete'>Click Me To Delete</button>
$('#delete').on('click',function(){
$.ajax({
type:'POST',
url:'page.php',
data:'action=del&id=1',
success:function(result){
//Deleted
}
});
});
Try this:
<a href="javascript:void(0);" onclick="if('Are you sure you want to delete?'){delData(this,1);}">delete</a>
<script type="text/javascript">
function delData(control,id){
$.ajax({type:'POST', url:'page.php?action=del&id='+id, success:function(result){
//alert('deleted');
$(control).parents('table').eq(0).remove();
}
});
}
<script>
NOTE:
Update: Note that now the 'this' is passed as a reference of this control to the method delData.
page.php?action=del&id=1, page.php?action=del&id=2. POST is for sending (hence 'post') data and should be used to modify data. GET is to retrieve (hence 'get') data.
$_REQUESTis bad as well,$_REQUESTcontains information from cookie, post and get. It's best to be specific: use$_POSTor$_GET, depending on what you're expecting; stackoverflow.com/questions/1924939/php-request-vs-get-and-post