How can I use an alert box that allows user to either continue or kill the form submission?

Posted on 2014-09-10
Medium Priority
Last Modified: 2014-09-10
Here's my PHP:

$amber = "select id from students where first_name='$first_name' and last_name='$last_name'";
$amber_query=mysqli_query($cxn, $amber)
or die("Amber didn't make it.");
	//you've got someone with the same first and last name, check to see if the family_id select box was utilitzed
		//they chose a last name, so that means they're getting ready to duplicate somebody

        RIGHT HERE - I want to put a Javascript alert box that tells the user they're getting ready to potentially add a duplicate entry. It may not be, so I want to give the user to either continue with the submission, or kill it. How?


Open in new window

Question by:brucegust
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
LVL 111

Assisted Solution

by:Ray Paseur
Ray Paseur earned 1100 total points
ID: 40314968
JavaScript has confirm()
LVL 82

Assisted Solution

leakim971 earned 500 total points
ID: 40314973
add this in your form :

<form onsubmit="return check()"

with the following javascript :
function check() {
   return confirm("do you want to continue?");

Open in new window

LVL 58

Assisted Solution

Gary earned 400 total points
ID: 40314978
For that to work you would need to go back to the browser, you cannot execute javascript in a PHP page and then continue with the PHP
WordPress Tutorial 1: Installation & Setup

WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.

LVL 111

Accepted Solution

Ray Paseur earned 1100 total points
ID: 40314991
But here's the issue... PHP is a server-side script.  It runs for the purpose of preparing HTML, CSS and JavaScript.  These three things are client-side scripts.  When you visit a web page you make a request to the server.  The server prepares a response consisting of HTML, CSS and JavaScript.  It sends that response, then it disconnects from the client machine.  This is called a "stateless" protocol because the server no longer knows anything about the client.  Only after the server has run and produced the response document does the client machine start its work.

As a result of this, you may have to think about using AJAX if you want to change the natural order of HTTP client/server processes.  The JavaScript Alert/Confirm is possible, but it's a lot of work since you're going to have to do this sort of thing:

1. Make an AJAX request to test the "amber" query
2. Get the AJAX response and use alert/confirm as needed
3. Take the (human) client response and verify whether to update anyway
4. If the confirm is "no" skip the update
5. If the confirm is "yes" make an AJAX request to force the update.

I think I might omit the JavaScript from the design and just use regular HTTP page loads.  You can keep the intermediate data in the session between scripts.

Author Comment

ID: 40315060
Ray, I think I'm going to go with your wisdom, although the other suggestions are things that I'll stash away for other situations.

The problem is that the alert, while it would normally be cut and dry, has to have the ability to communicate with the server like you pointed out. Hence, I'm going to punt this approach and go with something else.

LVL 111

Expert Comment

by:Ray Paseur
ID: 40315104
I think you'll get better results faster that way!

Featured Post

WordPress Tutorial 2: Terminology

An important part of learning any new piece of software is understanding the terminology it uses. Thankfully WordPress uses fairly simple names for everything that make it easy to start using the software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to implement server side field validation and display customized error messages to the client.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
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…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question