Jump to content

PHP activation script


hellomrmonkey

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/143933-php-activation-script/
Share on other sites

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.. :-)

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.