Käynnissä

Need small addition to PHP script to check for duplicate emails. Will pay $25 right away!

I need this script to check for duplicate emails. This is a very simple script that is part of a larger script that allows someone to sign up for a newsletter. Just need to check to see if the email address they are inputing is already in database. If it is, print message like "Sorry, email is already in our list".

Will pay $25 right away to someone that can do this immediately.

Here is the code:

if ($type=="SIGNUP")

{

global $page,$email_address,$email_name;

if (isset($email_address))

{

$pos=strpos (strtoupper($email_address), '@');

$pos2=strpos (strtoupper($email_address), '.');

if ($pos===false || $pos2===false)

{

$ret="The email address is not valid!<BR>";

$ret="<form>$content1<input type=hidden name=page value=$page>Your Email : <input type=text name=email_address></><br>";

$ret.="Your name : <input type=text name=email_name value='$email_name'><br><input type=submit value='Sign Up'><br>$content2</form>";

}

else

{

$ret="Thank you for signing up!";

$sql="INSERT INTO sb_email (email,email_name) VALUES('$email_address','$email_name')";

$result=$db->query($sql);

// ADD email in database

}

}else

{

$ret="<form>$content1<input type=hidden name=page value=$page>Your Email : <input type=text name=email_address></><br>";

$ret.="Your name : <input type=text name=email_name value='$email_name'><br><input type=submit value='Sign Up'><br>$content2</form>";

}

}

Taidot: PHP

Näytä lisää: pos in php code, email is not valid, email address not valid, email address is not valid, sql script , php pos, php db, email form php script, code signing, pos sql, sql pos, php check input type, need small, message away, php script sql, insert php code form, php email check, php sql add, quot email address quot, query email, form hidden submit, php script signup, email page print page, script form address, script message

Tietoa työnantajasta:
( 15 arvostelua ) Cincinnati, United States

Projektin tunnus: #405810

Myönnetty käyttäjälle:

e3d

Hello, can do it right now. Thanks

30 $ USD 0 päivässä
(54 arvostelua)
7.7

5 freelanceria on tarjonnut keskimäärin 30 $ tähän työhön

youspaze

////////// hello sir, PLEASE CHECK MY PM //////////////

30 $ USD 1 päivässä
(27 arvostelua)
5.6
agriz

Hi, Please check PM

30 $ USD 0 päivässä
(44 arvostelua)
4.4
python0java

let me take this task instantly

30 $ USD 0 päivässä
(2 arvostelua)
2.9
rajuworld

i am ready to do this..

30 $ USD 0 päivässä
(7 arvostelua)
2.4