PHP activation script

[hellomrmonkey]

Hi guys I am working on a user system for my site. I want users to be email verified before being able to login. The system only shows activated when the url is e.g. "http://example.com/activate.php?user=test&code=" If anything is after the code then it wont allow it.

 

<?php
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());


$user = $_GET['user'];
$activationid = $_GET['code'];

$result = mysql_query("SELECT * FROM users WHERE username='$user'") or die(mysql_error());  

if ( $row['activation'] == $activationid ) {
echo "Activated!<br />";
}

?>

NOTE: At signup the user is generated a random string. This is saved in MYSQL andsent via email with the url at start e.g. example.com/activate.php?user=USER&code=CODE

 

Thanks

[Maq]

What's your question?  Is there something in particular that's not working?  Do you get errors?

 

You're in the wrong section, this doesn't seem to have anything to do with math...

 

Use code tags.

[DarkSuperHero]

I see you have not declared your $row variblae.. but you are checking its value...you should have something like this...

<?php
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());


$user = $_GET['user'];
$activationid = $_GET['code'];

$result = mysql_query("SELECT * FROM users WHERE username='$user'") or die(mysql_error());  
while($row = mysql_fetch_array($result))
{
if ( $row['activation'] == $activationid ) {
echo "Activated!<br />";
}
} 

 

 

PS UNTESTED CODE........but hope you understand what your missing.. :-)