delete in javascript.
Posted: Mon Jan 02, 2012 5:08 am
how can i delete a row in mysql database using a javascript..? can anyone show me a example?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<a href="?mode=delete&record_id=[your record id]" onclick="return rem()">delete</a>
Setup your java script:
function rem(){
if(confirm('Are you sure you want to delete this record?\nNo going back!')){
return true;
}else{
return false;
}
}Code: Select all
if(isset($_GET['mode']) && $_GET['mode']=="delete"){
$id = (int) $_GET['record_id'];
mysql_query("DELETE FROM table_name WHERE id = " . $id . " LIMIT 1");
mysql_query("OPTIMIZE TABLE table_name");
echo "Record deleted successfully!";
}