Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Course Of The Month
4 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
JavaScript confirm msgbox delete records from MySQL database
Posted on 2008-06-18
Hi,
I have implemented a JavaScript function that should allow the user to confirm if they want to delete a record or not. This is the code I have:
if(isset($_POST['delete'])
<script type="text/javascript">
<!--
function confirmation() {
var answer = confirm("Are you sure you want to delete?")
if (answer){
<?php
mysql_query("DELETE FROM tblgbs WHERE gbID = $gbID") or die(mysql_error());
mysql_query("DELETE FROM tblgb WHERE gbID = $gbID") or die(mysql_error());
$success_msg = '<div class="errormsg">Deleted</
?>
}
else{
<?php
$success_msg = '<div class="errormsg">Not Deleted</div>';
?>
}
}
//-->
</script>
The problem is that the first time I enter the delete page, I do not get the confirm box, it just deletes the record. The second problem I have is that even if I select Cancel, it still deletes the record.
I am using the following submit button to trigger the function:
<input class="subbtn" type="submit" name="delete" value="Delete" onclick="confirmation()" />
Please can someone have a look at this and tell me where I am going wrong.
Many thanks,
John
I have implemented a JavaScript function that should allow the user to confirm if they want to delete a record or not. This is the code I have:
if(isset($_POST['delete'])
<script type="text/javascript">
<!--
function confirmation() {
var answer = confirm("Are you sure you want to delete?")
if (answer){
<?php
mysql_query("DELETE FROM tblgbs WHERE gbID = $gbID") or die(mysql_error());
mysql_query("DELETE FROM tblgb WHERE gbID = $gbID") or die(mysql_error());
$success_msg = '<div class="errormsg">Deleted</
?>
}
else{
<?php
$success_msg = '<div class="errormsg">Not Deleted</div>';
?>
}
}
//-->
</script>
The problem is that the first time I enter the delete page, I do not get the confirm box, it just deletes the record. The second problem I have is that even if I select Cancel, it still deletes the record.
I am using the following submit button to trigger the function:
<input class="subbtn" type="submit" name="delete" value="Delete" onclick="confirmation()" />
Please can someone have a look at this and tell me where I am going wrong.
Many thanks,
John
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
6 Comments
You have misunderstood the way PHP operates in conjunction with HTML and Javascript.
PHP is a server-side language, which means all of the code is processed on the server. This is done before any output (HTML and Javascript) is sent to the user's browser. Therefore, in your script, the PHP portion is processed first, deleting the record, and then the Javascript and HTML is passed on to the user.
Your script is expecting that the code is processed in the following order:
Some Javascript
Some PHP
Some more Javascript
Some HTML
This is not correct.
You will need to alter your document to send the required HTML and Javascript, receive the user's answer, and then call another script with the request to delete the record.
PHP is a server-side language, which means all of the code is processed on the server. This is done before any output (HTML and Javascript) is sent to the user's browser. Therefore, in your script, the PHP portion is processed first, deleting the record, and then the Javascript and HTML is passed on to the user.
Your script is expecting that the code is processed in the following order:
Some Javascript
Some PHP
Some more Javascript
Some HTML
This is not correct.
You will need to alter your document to send the required HTML and Javascript, receive the user's answer, and then call another script with the request to delete the record.
Active 3 days ago
better have client java script confirm delete function.. .upon click .. call server side page to do the deletion ..,
look at this example and modify your code,
http://www.dmxzone.com/ShowDetail.asp?NewsId=3459
look at this example and modify your code,
http://www.dmxzone.com/ShowDetail.asp?NewsId=3459
Hi,
Thanks for the comments. I have decided to do it using PHP by displaying an additional 2 submit buttons if user selects delete. Then using an If....Elseif statement to determine the course of action.
Thanks,
John
Thanks for the comments. I have decided to do it using PHP by displaying an additional 2 submit buttons if user selects delete. Then using an If....Elseif statement to determine the course of action.
Thanks,
John
You can certainly do that, but keep in mind that the PHP will not be executed after the Javascript. You will need to make a new request to the server to allow PHP to run an if... statement.
Yes, I post the user Id number the first time, grab it and store in a hidden field. When the user selects either Yes or No, I post the variable again and carry out the action. It seems to be working really well.
Featured Post
Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption. Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month4 days, 11 hours left to enroll
687 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.