??? if (submit)

troinfo

how do i prevent my php code from running until the submit button is hit?

i tried using this as a simple test :

$submit = "submit"; --this is the name of my submit button

if ($submit) {

$msg = "starting";

}

however this did not work.

I'm trying to check the database to see if a username already exists without have to send the user back from another page.

this is my code for checking the the db:

if ($submit) {

$db_name = "******";

$table_name = "******";

$connection = @mysql_connect("***", "", "***") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "select from ***** where username ='$username'";

$result = @($sql,$connection) or die("Couldn't execute query 1.");

if (mysql_num_rows($result) > 0) {

$msg = "Name exists.";
}

}

Any help would be great.

Anon

I generally use a variable

in the form tag you have the action="somephpfile.php4?action=go"

or a hidden filed named action value go

then its a simple

if($action)

and it won't work until the user hits submit.

Does your submit button look like this
<input type="submit" name="Submit" value="Submit"> if so then after a POST submission you WILL have an if($submit) return true.

Your confirm username code looks fine to me

troinfo

Thanks Mike,

I tried the if($action) and that worked as far not running the code till the submit button was hit awesome 🙂.

2 things though:

my code did not stop me from adding a user with the same name.
is it possible to hide that "signup?action=go" from the browser address line?

#2 it not that important.

Thank again Mike.

Anon

mike's second solution (look to see if $submit has a value) is better.

If you do want to stick with the first, and hide that action=go bit, use a hidden form field instead of sticking it straight into the URL. But really it's no different from mike's second solution, except that it means an entire extra field that is otherwise useless.

As far as your problem 1 goes - take off those @ (shouldn't go on until you've finished debugging or know that the error messages they're hiding aren't important), echo $sql before running the query, and see what information (including the query string being sent to the database) you get back says and whether it looks right.

troinfo

I'm getting the correct value back.

troinfo

i think i got it guys.

Thank you so much 🙂