mpsn Posted May 26, 2011 Share Posted May 26, 2011 Hi, ppl, my problem is that whenever the DELETE link is clicked, a javascript confirm box pops up and it should only delete the record with the ID from the $_GET global array if the user clicks the OK button, otherwise it should just redirect to the table of entries WITHOUT DELETION, but somehow it IS DELETING even when CANCEL button of javascript confirm box clicked. Here's my code below: <html> <head><title> </title> </head> <body> <?php require "bellConnect.inc.php"; $ID=$_GET['ID']; $result=mysql_query("SELECT * FROM bellProducts WHERE ID=$ID"); $row=mysql_fetch_assoc($result); $name=$row['Name']; $manufacturer=$row['Manufacturer']; print "Value of ID is $ID"; ?> <script type='text/javascript'> var confirmDelete=confirm("Are you sure you want to delete <?php echo "$name $manufacturer"?> ?"); if(confirmDelete) { <?php $deletedResult=mysql_query("DELETE FROM bellProducts WHERE ID=$ID"); ?> alert("<?php echo "$name $manufacturer" ?> has been deleted successfully."); window.location="http://localhost/index.php"; } else if(!confirmDelete) { window.location="http://localhost/index.php"; } </script> </body> </html> **Plz help me someone!!! Thx Quote Link to comment https://forums.phpfreaks.com/topic/237564-problem-with-delete-sql-function/ Share on other sites More sharing options...
fugix Posted May 26, 2011 Share Posted May 26, 2011 you are trying to mix php and js together which normally doesnt work since js is client side and php is server side. I suggest using pure php for this. Quote Link to comment https://forums.phpfreaks.com/topic/237564-problem-with-delete-sql-function/#findComment-1220787 Share on other sites More sharing options...
Maq Posted May 26, 2011 Share Posted May 26, 2011 @mx760, In the future, please place tags around your code. Quote Link to comment https://forums.phpfreaks.com/topic/237564-problem-with-delete-sql-function/#findComment-1220790 Share on other sites More sharing options...
mpsn Posted May 26, 2011 Author Share Posted May 26, 2011 I forgot that JS is client side and PHP is server side, thx for the reply all! Quote Link to comment https://forums.phpfreaks.com/topic/237564-problem-with-delete-sql-function/#findComment-1220798 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.