same email cant register (ibwf)

[shakil420]

hi all wapmasters...have a nice day... i just tried to add a new thing in lavalair register form..when some one try to register it will automatic chek users email address...if they provide unique email then it will succees otherwise it will exit();

here is the php code ///////////

//////////////////ibwf reg page

$dupemail=mysql_fetch_array(mysql_query("SELECT email FROM ibwf_users where email ='$email'"));

if ($_REQUEST['email'] !=$dupemail[0])

{ 
echo"regiter ok";
/////////////register process

}else{

echo"this email is already used try another";
exit();
} 

note: i cant run it....what is the problem in this code??
any1 recode it..

//////////////////////
///////
//
/

[khan]

Try This One:

$email = htmlspecialchars(mysql_real_escape_string($_POST['email']));
$results = mysql_query("select count(*) email from ibwf_user where email = '$email'");
$count = mysql_fetch_assoc($results);
if ($count['email'] > 0) {echo "This Email <b>$email</b> Already Registered.Try Another Valid email.<br>";}else {echo "Register Ok.<br>";} 

[something else]

note: i cant run it....what is the problem in this code??

$dupemail=mysql_fetch_array(mysql_query("SELECT email FROM ibwf_users where email ='".htmlspecialchars(mysql_real_escape_string($_REQUEST['email']) ."'")); 

Try This One:

$email = htmlspecialchars(mysql_real_escape_string($_POST['email']));
$results = mysql_query("select count(*) email from ibwf_user where email = '$email'");
$count = mysql_fetch_assoc($results);
if ($count['email'] > 0) {echo "This Email <b>$email</b> Already Registered.Try Another Valid email.<br>";}else {echo "Register Ok.<br>";} 

does it need to be:

$count = mysql_fetch_assoc($results[0]); 

[subzero]

$email = htmlspecialchars(mysql_real_escape_string($_POST['email']));
$results = mysql_query("select count(*) email from ibwf_user where email = '$email'");
$count = mysql_fetch_assoc($results);
if($email>$count[email])
{
$error = true;
$errmessage = "Same email you can't use it!";
}

[i_love_php_mysql]

$email = htmlspecialchars(mysql_real_escape_string($_POST['email']));
$results = mysql_query("select count(*) email from ibwf_user where email = '$email'");
$count = mysql_fetch_assoc($results);
if($email>$count[email])
{
$error = true;
$errmessage = "Same email you can't use it!";
}

how to use it? please share

[shakil420]

100% working thanx @khan 89

[metulj]

$checkemail = mysql_query("SELECT email FROM users WHERE email = '$email'") or die(mysql_error());
$showresultemail = mysql_num_rows($checkemail);
if($showresultemail != 0)
{
echo "<br/>$email <br/>is already in use !<br/><a href=\"registration_page.php\">Try again=></a>";
die(mysql_error());
}
else
{
echo "OK... or whatever...";
} 

[i_love_php_mysql]

$checkemail = mysql_query("SELECT email FROM users WHERE email = '$email'") or die(mysql_error());
$showresultemail = mysql_num_rows($checkemail);
if($showresultemail != 0)
{
echo "<br/>$email <br/>is already in use !<br/><a href=\"registration_page.php\">Try again=></a>";
die(mysql_error());
}
else
{
echo "OK... or whatever...";
} 

but lavalair register form not like this? error message show from core.php how to use with lavalair tell please

[metulj]

but lavalair register form not like this?
error message show from core.php how to use with lavalair tell please

code is meant for general usage...
so anyone can modify it for any script...

[shakil420]

@@i_love_php_mysql "how to use it? please share"

/////welll open ur register.php page then add the code .may b its still not clear to u ! explore coding-talk learn more

[i_love_php_mysql]

very confusing script it is.

[something else]

only one minor update to change it to lavalair ???
change:
$checkemail = mysql_query("SELECT email FROM users WHERE email = '$email'") or die(mysql_error());
to:
$checkemail = mysql_query("SELECT email FROM ibwf_users WHERE email = '$email'") or die(mysql_error());

confusing?????

if u still cant get it working there is a pre-scripted one for lavalair somewhere in forum :P

Added after 8 minutes:

or another alternative if you still cant do it is to open up your database and enter this in your sql box:

ALTER TABLE `ibwf_users` ADD UNIQUE (`email`) 

[i_love_php_mysql]

that is a good idea but then how would i print error message using those switch case from core.php and print it on regsiter.php that email already registered etc?

[something else]

iv already posted a complete version of this for lavalair somewhere in this forum (not to long ago).... so i cant be bothered to code it again :P
use this:

http://coding-talk.com/search.php

[i_love_php_mysql]

tell the name or how will i know which script? i see soo many i do not know which one to use.