how to popup on the same page not the post page?

jrahma

Hi,

I have a member.php page and within the member.php I have a <form> with;

In the insert.member.php I am checking if the user is exists in MySQL table.. If not, then I am INSERTING and then redirecting to another page but if exists I am displaying a popup dialog.

when the popup is shown, it will be shown in a blank page and the address on the browser address bar is insert_member.php

how can I let the popup message on the member.php?

bradgrafelman

jrahma;11032683 wrote:
In the insert.member.php I am checking if the user is exists in MySQL table.. If not, then I am INSERTING and then redirecting to another page but if exists I am displaying a popup dialog.

Assuming you've got a well-defined schema (i.e. you have UNIQUE/PRIMARY constraints on the appropriate column(s)), note that the first check is superfluous. It would be more efficient (and less code) to simply execute the INSERT statement and check if it fails due to duplicate data.

Regardless, this doesn't appear to be the source of your problem.

jrahma;11032683 wrote:
when the popup is shown, it will be shown in a blank page and the address on the browser address bar is insert_member.php

Right, because when you submit a form, your browser makes a new request (a POST one, in this case) in order to display a completely new document/page.

jrahma;11032683 wrote:
how can I let the popup message on the member.php?

Use AJAX (or something similar) to send a POST request to your server in the background without loading a new page; if it indicates an error, use Javascript to display the pop-up message. Otherwise, if it indicates a success, redirect the user to a new URL as appropriate.

jrahma

bradgrafelman;11032691 wrote:
Use AJAX (or something similar) to send a POST request to your server in the background without loading a new page; if it indicates an error, use Javascript to display the pop-up message. Otherwise, if it indicates a success, redirect the user to a new URL as appropriate.

but using javascipt or ajax on php means when I check if record is exists then my connection and query code will be exposed to user? right? please advise..

NogDog

No, the Javascript AJAX function will send a HTTP request to the web server just as a "normal" form submission would. The Javascript does not actually do any server-side processing (which will be done by the PHP script that the Javascript sends its request to). It then listens for the HTTP response back from the server, which it then uses to change the local display (if needed).