php form validation

Robert_Blackwel

Quick question here.

I have a website with a populated dbase, and then we are starting a new
offshoot service. However, I'd like use the same dbase for both, so you
could sign on on one and it would work on the other etc.

On our main site (we are using phpnuke) you can't register if the e-mail you
have provided is already registered. But, on our new one, we haev no
validation so duplicate values can exist.

I personally don't think this sounds like too difficult of an issue. Just
simple form validation right?

Or, am I wrong and it's really hard.

I know it's always easier said then done, but I'm not totally web iliterate.
Basically you have to validate against the dbase to make sure there isn't a duplicate value...I guess I just need to know how "hard" this is to do.

Are there any free scripts I could use as a guide line or maybe a tutorial somewhere?

Thanks

TheIceman5

pretty damn easy. just do a search of this forum and you will find many many examples

tekky

you mean validating against the dbase like if USERNAME exists... or on what level are you checking for duplicates? just 1 or 2 fields or ALL ?

Robert_Blackwel

I THINK we just need to validate against one cell in a table to make sure there aren't duplicate entries...

right now that cell is useremail

So, if someone tries to register using an e-mail that is already in our dbase, it would not let them register and would say, there is already an account registered to this e-mail and then I'd say something like, please double check for proper spelling or click here to have us e-mail you your password.

Actually, we'd probably validate against 2 fields, username and useremail.

But I suspect it'd be the same method for both.

What exactly should I search for?

tekky

do something like this on the validate page

$query = "SELECT username, useremail FROM $table WHERE username='$checkuser' OR useremail='$checkemail'";
$result = mysql_query($query);
if (mysql_num_rows($result))
{
     $row = mysql_fetch_assoc($result);
     if ($row['username']
          $erroruser = 1;
     if ($row['useremail']
          $erroremail = 1;
     $header = "Location: [url]http://www.mysite.com/yourscript.php?erroruser=[/url]$erroruser&erroremail=$erroremail";
header($header); //redirect to same page that called this one where it can now validate the erroruser erroremail variables in $_GET and say fix your damn username or email or both....
}
//rest of your code for a successful username/email entry here