Complete advanced login member system - PHP tutorial | ineedtutorials.com

Home > PHP > Complete advanced login member system – PHP tutorial

Complete advanced login member system – PHP tutorial

January 11th, 2008 Gertjan Leave a comment Go to comments

In this advanced tutorial i will teach you the steps required to create a custom build login/member system with PHP.

The system itself ofcourse has alot of room for improvements, also, it’s very easily expandable, i’ve chosen to work in a modular way, so that if you change something you only have to change it in 1 file. I’ve done this by using functions, this script is a good example of the real power of PHP.

Features:

Registration
Lost password
Various checks on passwords and usernames
users can change their password
Passwords are stored in a database with a seed added to it and they have sha1 encryption
Easy to adjust & use

Requirements:

Mysql database
a php & mysql enabled host
php mail() enabled host
ftp access to your website

Overview

Steps:

Creating the mysql table
Creating a db_connect.inc.php file
Creating the header.php file
Creating the footer.php file
Creating the index.php file
Creating the login.php file
Creating the logout.php file
Creating a function.inc.php file
Creating the mail.functions.inc.php file
Creating the display.functions.inc.php file
Creating the login.functions.inc.php file
Creating the user.functions.inc.php file
Creating the validation.functions.inc.php file
Creating the lostpassword.php file
Creating the changepassword.php file
Creating the register.php file
Creating the activate.php file

Step 1: Creating the mysql table

For this tutorials i presume you already know how to add tables to your database.

Table login (SQL code):

^?View Code SQL

CREATE TABLE  `login` (
  `loginid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL,
  `password` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `actcode` varchar(45) NOT NULL,
  `disabled` tinyint(1) NOT NULL default '0',
  `activated` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`loginid`)
);

Now let us add the administrator account:

username: admin
password: yourpasswordhere

** Change the text yourpassword here with the desired password.

** Change the text youremailhere with your email adress.

SQL query:

^?View Code SQL

1	insert into login (username,password,email,activated) value ('admin',sha1(concat('yourpasswordhere','0dAfghRqSTgx')),'youremailhere','1');

The table is now ready, and the administrator account has been added. let us move on to step 2.

Step 2: Creating a db_connect.inc.php file

This file will be used to manage the connection to the database.

File db_connect.inc.php:

^?View Code PHP

<?php
// Database settings
// database hostname or IP. default:localhost
// localhost will be correct for 99% of times
define("HOST", "localhost");
// Database user
define("DBUSER", "dbuser");
// Database password
define("PASS", "dbpass");
// Database name
define("DB", "dbname");
 
############## Make the mysql connection ###########
$conn = mysql_connect(HOST, DBUSER, PASS) or  die('Could not connect !<br />Please contact the site\'s administrator.');
 
$db = mysql_select_db(DB) or  die('Could not connect to database !<br />Please contact the site\'s administrator.');
 
?>

Let me explain:

HOST: this is the location for the database server it can be a hostname or an ip adress. it is usualy localhost.
DBUSER: this is the database user account used to access the database.
PASS: this is the password for the database user account.
DB: this is the name of the database used.

Step 3: Creating the header.php file

File header.php:

^?View Code PHP

<?php
error_reporting(0); // we don't want to see errors on screen
// Start a session
session_start();
require_once ('db_connect.inc.php'); // include the database connection
require_once ("functions.inc.php"); // include all the functions
$seed="0dAfghRqSTgx"; // the seed for the passwords
$domain =  "ineedtutorials.com"; // the domain name without http://www.
 
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Complete Member Login / System tutorial - <?php echo $domain; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>

Step 4: Creating the footer.php file

The footer file is included at the bottom of every page, it looks like this:

^?View Code PHP

<hr>
<div id='footer'>Copyright 2007-2008 &copy; <?php echo $domain; ?></div>
</body>
</html>

Step 5: Creating the index.php file

In this step we will create the homepage of the website, we’ll keep it very basic, only the login will be displayed.

File index.php:

^?View Code PHP

<?php 
 
 require_once "header.php"; 
 //content
 include "login.php";
 // more content
 require_once "footer.php";
 
?>

Step 6: Creating the login.php file

In this step we will make the actual login page, because we want to keep it readable we create some custom build functions that will handle the actual login. So basicly all this page will do is call the functions checkLogin(), show_loginform() and isLoggedIn()

^?View Code PHP

<?php
if (!isLoggedIn())
{
    // user is not logged in.
    if (isset($_POST['cmdlogin']))
    {
        // retrieve the username and password sent from login form & check the login.
        if (checkLogin($_POST['username'], $_POST['password']))
        {
            show_userbox();
        } else
        {
            echo "Incorrect Login information !";
            show_loginform();
        }
    } else
    {
        // User is not logged in and has not pressed the login button
        // so we show him the loginform
        show_loginform();
    }
 
} else
{
    // The user is already loggedin, so we show the userbox.
    show_userbox();
}
?>

Step 7: Creating the logout.php file

The logout file will destroy the session and it’s stored information. Afterwards it will redirect the user to the homepage.

File logout.php:

^?View Code PHP

<?php 
session_start();
if( session_unregister('loginid') == true && session_unregister('username')==true ) {
    session_destroy();
	header('Location: index.php');
  } else {
   unset($_SESSION['loginid']);
   unset($_SESSION['username']);
   session_destroy();
   header('Location: index.php');
}
?>

Step 8: Creating the function.inc.php file

Now we will create a file that will store all our functions, by including this file all our functions will be accessable.
It will help keep track of your functions.

File functions.inc.php:

^?View Code PHP

<?php
 
require_once("mail.functions.inc.php");
require_once("user.functions.inc.php");
require_once("display.functions.inc.php");
require_once("login.functions.inc.php");
require_once("validation.functions.inc.php");
 
 
function generate_code($length = 10)
{
 
    if ($length <= 0)
    {
        return false;
    }
 
    $code = "";
    $chars = "abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ123456789";
    srand((double)microtime() * 1000000);
    for ($i = 0; $i < $length; $i++)
    {
        $code = $code . substr($chars, rand() % strlen($chars), 1);
    }
    return $code;
 
}
 
?>

Step 9: Creating the mail.functions.inc.php file

This file will contain all functions that we use to send emails.

File mail.functions.inc.php:

^?View Code PHP

<?php
 
##### Mail functions #####

function sendLostPasswordEmail($username, $email, $newpassword)
{
 
    global $domain;
    $message = "
You have requested a new password on http://www.$domain/,
 
Your new password information:
 
username:  $username
password:  $newpassword
 
 
Regards
$domain Administration
";
 
    if (sendMail($email, "Your password has been reset.", $message, "no-reply@$domain"))
    {
        return true;
    } else
    {
        return false;
    }
 
 
}
 
function sendMail($to, $subject, $message, $from)
{
 
 
    $from_header = "From: $from";
 
    if (mail($to, $subject, $message, $from_header))
    {
        return true;
    } else
    {
        return false;
    }
    return false;
}
 
function sendActivationEmail($username, $password, $uid, $email, $actcode)
{
    global $domain;
    $link = "http://www.$domain/activate.php?uid=$uid&actcode=$actcode";
    $message = "
Thank you for registering on http://www.$domain/,
 
Your account information:
 
username:  $username
password:  $password
 
Please click the link below to activate your account.
 
$link
 
Regards
$domain Administration
";
 
    if (sendMail($email, "Please activate your account.", $message, "no-reply@$domain"))
    {
        return true;
    } else
    {
        return false;
    }
}
 
?>

Step 10: Creating the display.functions.inc.php file

This file will contain all functions that display a form or a userbox on the page.

For example: It contains the loginform, the HTML code for the userbox, the lostpassword form, …

file: display.functions.inc.php

^?View Code PHP

<?php
 
#### Display Functions ####

function show_userbox()
{
    // retrieve the session information
    $u = $_SESSION['username'];
    $uid = $_SESSION['loginid'];
    // display the user box
    echo "<div id='userbox'>
			Welcome $u
			<ul>
				<li><a href='./changepassword.php'>Change Password</a></li>
				<li><a href='./logout.php'>Logout</a></li>
			</ul>
		 </div>";
}
 
function show_changepassword_form(){
 
echo '<form action="./changepassword.php" method="post"> 
  <fieldset> 
  <legend>Change Password</legend> 
  <input type="hidden" value="'.$_SESSION['username'].'" name="username"> 
  <dl> 
    <dt> 
      <label for="oldpassword">Current Password:</label> 
    </dt> 
    <dd> 
      <input name="oldpassword" type="password" id="oldpassword" maxlength="15"> 
    </dd> 
  </dl> 
  <dl> 
    <dt> 
      <label for="password">New Password:</label> 
    </dt> 
    <dd> 
      <input name="password" type="password" id="password" maxlength="15"> 
    </dd> 
  </dl> 
  <dl> 
    <dt> 
      <label for="password2">Re-type new password:</label> 
    </dt> 
    <dd> 
      <input name="password2" type="password" id="password2" maxlength="15"> 
    </dd> 
  </dl> 
  <p> 
    <input name="reset" type="reset" value="Reset"> 
    <input name="change" type="submit" value="Reset Password"> 
  </p> 
  </fieldset> 
</form>
';
}
 
function show_loginform($disabled = false)
{
 
    echo '<form name="login-form" id="login-form" method="post" action="./index.php"> 
  <fieldset> 
  <legend>Please login</legend> 
  <dl> 
    <dt><label title="Username">Username: </label></dt> 
    <dd><input tabindex="1" accesskey="u" name="username" type="text" maxlength="30" id="username" /></dd> 
  </dl> 
  <dl> 
    <dt><label title="Password">Password: </label></dt> 
    <dd><input tabindex="2" accesskey="p" name="password" type="password" maxlength="15" id="password" /></dd> 
  </dl> 
  <ul> 
    <li><a href="./register.php" title="Register">Register</a></li> 
    <li><a href="./lostpassword.php" title="Lost Password">Lost password?</a></li> 
  </ul> 
  <p><input tabindex="3" accesskey="l" type="submit" name="cmdlogin" value="Login" ';
    if ($disabled == true)
    {
        echo 'disabled="disabled"';
    }
    echo ' /></p></fieldset></form>';
 
 
}
 
function show_lostpassword_form(){
 
	echo '<form action="./lostpassword.php" method="post"> 
	<fieldset><legend>Reset Password</legend>
  <dl> 
    <dt><label for="username">Username:</label></dt> 
    <dd><input name="username" type="text" id="username" maxlength="30">
    </dd> 
  </dl> 
   <dl> 
    <dt><label for="email">email:</label></dt> 
    <dd><input name="email" type="text" id="email" maxlength="255">
    </dd> 
  </dl> 
  <p> 
    <input name="reset" type="reset" value="Reset"> 
    <input name="lostpass" type="submit" value="Reset Password"> 
  </p> 
  </fieldset>
</form>';
 
}
 
function show_registration_form(){
 
	echo '<form action="./register.php" method="post"> 
	<fieldset><legend>Register</legend>
  <dl> 
    <dt><label for="username">Username:</label></dt> 
    <dd><input name="username" type="text" id="username" maxlength="30">
    </dd> 
  </dl> 
  <dl> 
    <dt><label for="password">Password:</label></dt> 
    <dd><input name="password" type="password" id="password" maxlength="15">
    </dd> 
  </dl> 
  <dl> 
    <dt><label for="password2">Re-type password:</label></dt> 
    <dd><input name="password2" type="password" id="password2" maxlength="15">
    </dd> 
  </dl> 
  <dl> 
    <dt><label for="email">email:</label></dt> 
    <dd><input name="email" type="text" id="email" maxlength="255">
    </dd> 
  </dl> 
  <p> 
    <input name="reset" type="reset" value="Reset"> 
    <input name="register" type="submit" value="Register"> 
  </p> 
  </fieldset>
</form>';
 
}
?>

Step 11: Creating the login.functions.inc.php file

This file will contain the login functions

file: login.functions.inc.php

^?View Code PHP

<?php
 
#### Login Functions #####

 
function isLoggedIn()
{
 
    if (session_is_registered('loginid') && session_is_registered('username'))
    {
        return true; // the user is loged in
    } else
    {
        return false; // not logged in
    }
 
    return false;
 
}
 
function checkLogin($u, $p)
{
global $seed; // global because $seed is declared in the header.php file
 
    if (!valid_username($u) || !valid_password($p) || !user_exists($u))
    {
        return false; // the name was not valid, or the password, or the username did not exist
    }
 
    //Now let us look for the user in the database.
    $query = sprintf("
		SELECT loginid 
		FROM login 
		WHERE 
		username = '%s' AND password = '%s' 
		AND disabled = 0 AND activated = 1 
		LIMIT 1;", mysql_real_escape_string($u), mysql_real_escape_string(sha1($p . $seed)));
    $result = mysql_query($query);
    // If the database returns a 0 as result we know the login information is incorrect.
    // If the database returns a 1 as result we know  the login was correct and we proceed.
    // If the database returns a result > 1 there are multple users
    // with the same username and password, so the login will fail.
    if (mysql_num_rows($result) != 1)
    {
        return false;
    } else
    {
        // Login was successfull
        $row = mysql_fetch_array($result);
        // Save the user ID for use later
        $_SESSION['loginid'] = $row['loginid'];
        // Save the username for use later
        $_SESSION['username'] = $u;
        // Now we show the userbox
        return true;
    }
    return false;
}
 
?>

Step 12: Creating the user.functions.inc.php file

This file will contain the user functions

file: user.functions.inc.php

^?View Code PHP

<?php
 
##### User Functions #####

function changePassword($username,$currentpassword,$newpassword,$newpassword2){
global $seed;	
	if (!valid_username($username) || !user_exists($username))
    {
        return false;
    }
    if (! valid_password($newpassword) || ($newpassword != $newpassword2)){
 
		return false;
	}
 
	// we get the current password from the database
    $query = sprintf("SELECT password FROM login WHERE username = '%s' LIMIT 1",
        mysql_real_escape_string($username));
 
    $result = mysql_query($query);
	$row= mysql_fetch_row($result);
 
	// compare it with the password the user entered, if they don't match, we return false, he needs to enter the correct password.
	if ($row[0] != sha1($currentpassword.$seed)){
 
		return false;	
	}
 
	// now we update the password in the database
    $query = sprintf("update login set password = '%s' where username = '%s'",
        mysql_real_escape_string(sha1($newpassword.$seed)), mysql_real_escape_string($username));
 
    if (mysql_query($query))
    {
		return true;
	}else {return false;}
	return false;
}
 
 
function user_exists($username)
{
    if (!valid_username($username))
    {
        return false;
    }
 
    $query = sprintf("SELECT loginid FROM login WHERE username = '%s' LIMIT 1",
        mysql_real_escape_string($username));
 
    $result = mysql_query($query);
 
    if (mysql_num_rows($result) > 0)
    {
        return true;
    } else
    {
        return false;
    }
 
    return false;
 
}
 
function activateUser($uid, $actcode)
{
 
    $query = sprintf("select activated from login where loginid = '%s' and actcode = '%s' and activated = 0  limit 1",
        mysql_real_escape_string($uid), mysql_real_escape_string($actcode));
 
    $result = mysql_query($query);
 
    if (mysql_num_rows($result) == 1)
    {
 
        $sql = sprintf("update login set activated = '1'  where loginid = '%s' and actcode = '%s'",
            mysql_real_escape_string($uid), mysql_real_escape_string($actcode));
 
        if (mysql_query($sql))
        {
            return true;
        } else
        {
            return false;
        }
 
    } else
    {
 
        return false;
 
    }
 
}
 
function registerNewUser($username, $password, $password2, $email)
{
 
    global $seed;
 
    if (!valid_username($username) || !valid_password($password) || 
        	!valid_email($email) || $password != $password2 || user_exists($username))
    {
        return false;
    }
 
 
    $code = generate_code(20);
    $sql = sprintf("insert into login (username,password,email,actcode) value ('%s','%s','%s','%s')",
        mysql_real_escape_string($username), mysql_real_escape_string(sha1($password . $seed))
		, mysql_real_escape_string($email), mysql_real_escape_string($code));
 
 
    if (mysql_query($sql))
    {
        $id = mysql_insert_id();
 
        if (sendActivationEmail($username, $password, $id, $email, $code))
        {
 
            return true;
        } else
        {
            return false;
        }
 
    } else
    {
        return false;
    }
    return false;
 
}
 
function lostPassword($username, $email)
{
 
	global $seed;
    if (!valid_username($username) || !user_exists($username) || !valid_email($email))
    {
 
        return false;
    }
 
    $query = sprintf("select loginid from login where username = '%s' and email = '%s' limit 1",
        $username, $email);
 
    $result = mysql_query($query);
 
    if (mysql_num_rows($result) != 1)
    {
 
        return false;
    }
 
 
    $newpass = generate_code(8);
 
    $query = sprintf("update login set password = '%s' where username = '%s'",
        mysql_real_escape_string(sha1($newpass.$seed)), mysql_real_escape_string($username));
 
    if (mysql_query($query))
    {
 
            if (sendLostPasswordEmail($username, $email, $newpass))
        {
            return true;
        } else
        {
            return false;
        }      
 
    } else
    {
        return false;
    }
 
    return false;
 
}
 
?>

Step 13: Creating the validation.functions.inc.php file

This file will contain the validation functions, these function will validate the user input to see if it’s valid and doesn’t contain any illegal characters.

file: validation.functions.inc.php

^?View Code PHP

<?php
 
#### Validation functions ####

function valid_email($email)
{
 
    // First, we check that there's one @ symbol, and that the lengths are right
    if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email))
    {
        // Email invalid because wrong number of characters in one section, or wrong number of @ symbols.
        return false;
    }
    // Split it into sections to make life easier
    $email_array = explode("@", $email);
    $local_array = explode(".", $email_array[0]);
    for ($i = 0; $i < sizeof($local_array); $i++)
    {
        if (!ereg("^(([A-Za-z0-9!#$%&#038;'*+/=?^_`{|}~-][A-Za-z0-9!#$%&#038;'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$",
            $local_array[$i]))
        {
            return false;
        }
    }
    if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1]))
    { // Check if domain is IP. If not, it should be valid domain name
        $domain_array = explode(".", $email_array[1]);
        if (sizeof($domain_array) < 2)
        {
            return false; // Not enough parts to domain
        }
        for ($i = 0; $i < sizeof($domain_array); $i++)
        {
            if (!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])|([A-Za-z0-9]+))$", $domain_array[$i]))
            {
                return false;
            }
        }
    }
    return true;
}
 
function valid_username($username, $minlength = 3, $maxlength = 30)
{
 
    $username = trim($username);
 
    if (empty($username))
    {
        return false; // it was empty
    }
    if (strlen($username) > $maxlength)
    {
        return false; // to long
    }
    if (strlen($username) < $minlength)
    {
 
        return false; //toshort
    }
 
    $result = ereg("^[A-Za-z0-9_\-]+$", $username); //only A-Z, a-z and 0-9 are allowed
 
    if ($result)
    {
        return true; // ok no invalid chars
    } else
    {
        return false; //invalid chars found
    }
 
    return false;
 
}
 
function valid_password($pass, $minlength = 6, $maxlength = 15)
{
    $pass = trim($pass);
 
    if (empty($pass))
    {
        return false;
    }
 
    if (strlen($pass) < $minlength)
    {
        return false;
    }
 
    if (strlen($pass) > $maxlength)
    {
        return false;
    }
 
    $result = ereg("^[A-Za-z0-9_\-]+$", $pass);
 
    if ($result)
    {
        return true;
    } else
    {
        return false;
    }
 
    return false;
 
}
 
?>

Step 14: Creating the lostpassword.php file

When the user lost his password he can request a new temporary password. He has to enter his username and his password, if they are correct his password will be reset to a radom generated password and an email will be sent containing this new password, the user can use this password to login and change its password.

file: lostpassword.php

^?View Code PHP

<?php
 
require_once "header.php"; 
 
if (isset($_POST['lostpass'])){
 
	if (lostPassword($_POST['username'], $_POST['email'])){
 
		echo "Your password has been reset, an email containing your new password has been sent to your inbox.<br />
		<a href='./index.php'>Click here to return to the homepage.</a>
		";
 
	}else {
 
		echo "Username or email was incorrect !";
		show_lostpassword_form();
 
	}
 
} else {
	//user has not pressed the button
	show_lostpassword_form();	
}
 
 require_once "footer.php";
?>

Step 15: Creating the changepassword.php file

On this page the user can change his password, ofcouse he has to be logged in first. He will also have to enter his old password.

file: changepassword.php

^?View Code PHP

<?php
 
require_once "header.php";
 
if (isLoggedIn() == true)
{
 
    if (isset($_POST['change']))
    {
 
        if (changePassword($_POST['username'], $_POST['oldpassword'], $_POST['password'],
            $_POST['password2']))
        {
            echo "Your password has been changed ! <br /> <a href='./index.php'>Return to homepage</a>";
 
        } else
        {
            echo "Password change failed! Please try again.";
            show_changepassword_form();
        }
 
    } else
    {
        show_changepassword_form();
    }
 
} else {
	// user is not loggedin
    show_loginform();
}
 
require_once "footer.php";
 
?>

Step 16: Creating the register.php file

On this page users can create an account.

file: register.php

^?View Code PHP

<?php
 
require_once "header.php"; 
 
if (isset($_POST['register'])){
 
	if (registerNewUser($_POST['username'], $_POST['password'], $_POST['password2'], $_POST['email'])){
 
		echo "Thank you for registering, an email has been sent to your inbox, Please activate your account.
		<a href='./index.php'>Click here to login.</a>
		";
 
	}else {
 
		echo "Registration failed! Please try again.";
		show_registration_form();
 
	}
 
} else {
// has not pressed the register button
	show_registration_form();	
}
 
 require_once "footer.php";
?>

Step 17: Creating the activate.php file

On this page users can activate their account.

file: activate.php

^?View Code PHP

<?php
 
require_once "header.php";
 
$uid = (int)htmlentities(strip_tags($_GET['uid']));
$actcode = htmlentities(strip_tags($_GET['actcode']));
 
if (activateUser($uid, $actcode) == true)
{
    echo "Thank you for activating your account, You can now login.
		<a href='./index.php'>Click here to login.</a>";
} else
{
    echo "Activation failed! Please try again.";
    echo "If problem presists please contact the webmaster.";
}
 
require_once "footer.php";
?>

Categories: PHP Tags: advanced tutorials, content management, database, databases, functions, howto, login, members, mysql, PHP, php5, script, tutorial

Comments (256) Trackbacks (3) Leave a comment Trackback

Lane

June 1st, 2008 at 22:32 | #1

Reply | Quote

well, all i really want to know is…
on my site i have a members area and a n on members are, all i mwant to kno reallyu is how can i say on this sertain page, you must be a member and logged in to see this page?
Kerry

June 9th, 2008 at 01:21 | #2

Reply | Quote

Can register just fine and see it in MySQL database but when I login in it gives
me an error of incorrect information. Any suggestions of where to look to fix this?
Also I’m not receiving anything in my email when I try to reset password.
Lane

June 9th, 2008 at 02:38 | #3

Reply | Quote

its a nice tutorial, i was wondering if you can ass some sections in on it. like a section so that when you log into your ccount you can make a profile as a member about location age intrests and maybe be able to paist a pic of yourself at the top like the social networks on your scripts and let any user be able to see the profiles by clikcing one link to all gathered members profiles.. also add a section to that if a non member or a member not signed into the system will regect it to a givin page that needs you to be logged onto the account
Lane

June 9th, 2008 at 04:30 | #4

Reply | Quote

same problem as kerry, i resset my pw and idk the pw and no email was sent to my main XD
MTF95

June 16th, 2008 at 16:10 | #5

Reply | Quote

All pages are just blank :S
JD

June 18th, 2008 at 23:19 | #6

Reply | Quote

I hate to ask what seems like a very stupid question but where do I put my website information so that it will be displayed once logged in? I am new to this and any help would be appreciated.
mit

July 8th, 2008 at 05:05 | #7

Reply | Quote

Could not connect !
Please contact the site’s administrator.

when i try to log in to the system by local host i get this error!!! can any one help me?
Muffy

July 15th, 2008 at 19:32 | #8

Reply | Quote

Excellent article. Very impressed. I had never used php or mysql before and this has saved me hours of work developing a member log-in web site. For help try and Google ‘php tutorial’, or ‘html tutorial’ for the equally excellent w3schools site.
dhfola

August 15th, 2008 at 11:15 | #9

Reply | Quote

Just an blank screen =[ pllllzzzzzz can someone help if u want i will
send u all my files for that i get the same error when i go 2 login.php
email me at admin@dhfolam.co.cc plz help or u can use my daily email vmkrightpoint@gmail.com
thx kennn
styljola

August 15th, 2008 at 22:02 | #10

Reply | Quote

Hi,

Creating the mysql table – How name creation table?
dhfola

August 16th, 2008 at 02:45 | #11

Reply | Quote

i think i know what u mean if u got phpmyadmin go to the database u want the tables to be in then u go to import choose the sql file .sql u can copy the tables

CREATE TABLE `login` (
`loginid` int(10) unsigned NOT NULL auto_increment,
`username` varchar(30) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(255) NOT NULL,
`actcode` varchar(45) NOT NULL,
`disabled` tinyint(1) NOT NULL default ’0′,
`activated` tinyint(1) NOT NULL default ’0′,
PRIMARY KEY (`loginid`)
);

into notepad then u put .sql at the end of the file type
so its tables.sql then u click ok or upload or import then it should work
then u do the same for the admin but your inserting it into that why it got

insert into login (username,password,email,activated) value (‘admin’,sha1(concat(‘yourpasswordhere’,’0dAfghRqSTgx’)),’youremailhere’,’1′);

i hope that is what u mean…
styljola

August 17th, 2008 at 11:32 | #12

Reply | Quote

Yes I do it but I have info:
Could not connect !
Please contact the site’s administrator.
styljola

August 17th, 2008 at 11:50 | #13

Reply | Quote

In my serwer
register_globals is off

For this script it must be on?
magicbydave

August 21st, 2008 at 18:16 | #14

Reply | Quote

OS window server 2003 -iis 6

PHP and mysql installed and working properly.

almost everything works for me. I can load the pages and the admin login works but when I register a new user it says registration failed. It does create the user in the DB but no email goes out because I do not have a php mail() enabled host will this cause this to happen or is it something else?

if any one can explain to me how to make my server a php mail() enabled host it would help greatly.

thanks
liam

August 26th, 2008 at 12:04 | #15

Reply | Quote

how do you put the login box on your homepage?
dhfola

August 26th, 2008 at 12:14 | #16

Reply | Quote

i did some looking threw the code on index.php there is

include “login.php”;
Alex

August 27th, 2008 at 08:25 | #17

Reply | Quote

Great script! Thank you for sharing this! It’s easy to understand and modify.
Thanks again!
Nick

August 29th, 2008 at 00:03 | #18

Reply | Quote

I am getting the following error. I have enter the database details in db_connect.inc.php

Could not connect !
Please contact the site’s administrator.

Any advice?
magicbydave

September 4th, 2008 at 20:10 | #19

Reply | Quote

I am having the same problem as Sharpie.

I cannot seem to get the e-mails to work. Whenever I register a name, I see it appears in the DB, but it still says “Registration failed! Please try again.” and doesn’t send the e-mail… so I am assuming that it fails b/c the e-mail is false. any help?
CHRIS

September 6th, 2008 at 14:01 | #20

Reply | Quote

I simply cannot get this to work, just a blank index page, but it does make a good connection to the database.
I am a newbie to php but am trying very hard to see if I can find a problem before requesting help from you good folk out there.
One question though, my web site host has told me, they do not allow register_globals to be set to ON but do support phpMail…

With register_globals set to OFF is it still possible for this program to work. ?? In item 66 it appears to suggest register_globals must be set to ON.

Can anyone help with a Zipped collection of all the different pages that have been corrected and known to be good working pages..
Your assistance will be greatly appreciated and I might have some hair left on my head afterall.
Sohn

September 8th, 2008 at 04:50 | #21

Reply | Quote

It’s doesn’t work! I try many time. I can’t log in as admin and can’t do anythings! index.php show me the form for log in but all function look doesn’t work. Plz help!
dhfola

September 8th, 2008 at 11:20 | #22

Reply | Quote

Hey dhfola again i found why it coming with a blank screen, i think
i’m no php expert or anything i havn’t tried this yet but i will after
ok
go to your header file (header.php)
go to line 2:
error_reporting(0); // we don’t want to see errors on screen
as you read it says we don’t want to see any errors and when i was
deleting files for it because i was going to find another tutorial but
i remove the main files that header includes and it came up with missing files
error so this might work find out your errors so you can fix them ou
can search on google for help for that error byes
ken
Dhfola

September 8th, 2008 at 11:36 | #23

Reply | Quote

Yay it works now! i’m creating a website where users can write tutorial and
stuff like codeproject
magicbydave

September 12th, 2008 at 13:08 | #24

Reply | Quote

I found an error in the function sendMail() there is a extra return false; at the end of the function. it will cause Whenever you register a name, you see it appears in the DB, but it still says “Registration failed! Please try again.” because the sendmail function is always false.
blackeagle

September 28th, 2008 at 22:18 | #25

Reply | Quote

haveing problem with the activation but everything else works fine although i can activate via mysql

thanks for this great tute btw
blackeagle

September 29th, 2008 at 09:33 | #26

Reply | Quote

sorry bout last post there was no probs with the acivate.php
it was the mail fuction not pointing to the folder that activate.php file was in
was in. so all sorted now works like a charm.

now i just need to work out how to css it.(lol)
Prabath

October 8th, 2008 at 08:44 | #27

Reply | Quote

I have found few errors/ mistakes here

1. Title of the section for functions.inc.php was written without a “s” at
the end of “function” so some one may take the php file name from the title
as “function.inc.php”. this is incorrect. so correct file name is
“functions.inc.php”

2. when you insert “admin” record at first using sql command give at least
6 letter password, otherwise you will not get into admin login page

After correcting these, I hope you will be able to login to the system
Robert

October 24th, 2008 at 01:19 | #28

Reply | Quote

What a wonderful tutorial! Very clear, helpful, and useful! I’m able to greatly customize it the way that it is needed, including placing the login and register script anywhere!

For those that want to know how to edit the custom error/success messages, locate them via login.php, logout.php, ect. Find something like:

echo “Sorry, but you are unable to login.”;

And change the ” to ‘s.

echo ‘Sorry, but you are unable to login.’;

Then you can add any html element between the ‘…’!
George

October 24th, 2008 at 15:55 | #29

Reply | Quote

hello
i did so but it semmed not to show anything on the pages
in login.php it was told “Call to undefined function isLoggedIn()”
i dont know if this work anywhere
need help
thanks
i use php latest version 5.5
swathi

October 31st, 2008 at 10:35 | #30

Reply | Quote

hello,

when i entered username and password it gives an error like “Incorrect Login information !”.
and also when i am getting registerd it gives an message as “Registration failed! Please try again.”

please help me.

thanq
cf329rn

November 3rd, 2008 at 20:39 | #31

Reply | Quote

hey ermm just a bit of questions y’know makin the admin acc… well what do i save that as?
spotless

November 4th, 2008 at 19:48 | #32

Reply | Quote

I am running MySQL ver. 5.0.45 and get to user.functions.inc.php and it stops. I get a blank screen when I run index.php. I put echo commands as a trace and find that it stops in user.functions.inc.php.

Any ideas?
dhfola

November 5th, 2008 at 03:19 | #33

Reply | Quote

Remove error_reporting(0); from header.php then the errors will display,
fix them then it works for me XD
Spotless

November 5th, 2008 at 04:26 | #34

Reply | Quote

I have tried removing error_reporting(0). I even put an echo in to trace the error. It gets stuck at user.functions.inc.php. There is no error message. I just get a blank screen.
HELP!!!

November 21st, 2008 at 02:08 | #35

Reply | Quote

I need help. no more blank page, but i get this
?php require_once(“mail.functions.inc.php”); require_once(“user.functions.inc.php”); require_once(“display.functions.inc.php”); require_once(“login.functions.inc.php”); require_once(“validation.functions.inc.php”); function generate_code($length = 10) { if ($length <= 0) { return false; } $code = “”; $chars = “abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ123456789″; srand((double)microtime() * 1000000); for ($i = 0; $i
Jerry

November 21st, 2008 at 02:09 | #36

Reply | Quote

?php require_once(“mail.functions.inc.php”); require_once(“user.functions.inc.php”); require_once(“display.functions.inc.php”); require_once(“login.functions.inc.php”); require_once(“validation.functions.inc.php”); function generate_code($length = 10) { if ($length <= 0) { return false; } $code = “”; $chars = “abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ123456789″; srand((double)microtime() * 1000000); for ($i = 0; $i
sujan das

November 25th, 2008 at 11:15 | #37

Reply | Quote

I got the problem with the blank index page. My MySql connection is correct but I got a problem with the index.php file I only se a white page and nothing else? can anyone help me?

Thinks I done:
I have checkt all the file names and there is no fauæt with those they are all correct.
sujan das

November 25th, 2008 at 11:16 | #38

Reply | Quote

I got the problem with the blank index page. My MySql connection is correct but I got a problem with the index.php file I only se a white page and nothing else? can anyone help me?

Thinks I done:
I have checkt all the file names and there is no fauæt with those they are all correct.

please hep me!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
fabian

December 18th, 2008 at 19:12 | #39

Reply | Quote

I got a problem with the activation code, I get the error 404 message if I click on the activation link in the email.
Mattia

December 18th, 2008 at 22:57 | #40

Reply | Quote

The login form doesn’t works. That’s because it can’t transform the md5 password format???
fabian

December 19th, 2008 at 14:02 | #41

Reply | Quote

insert into login ( username,password,email,activated) value (‘admin’,sha1(concat(‘yourpasswordhere’,’0dAfghRqSTgx’)),’youremailhere’,’1′);
i don’t know where i got to place this code… in a mysql table or the first table?
Mattia

December 23rd, 2008 at 04:35 | #42

Reply | Quote

I solved my problems, it was just a my little mistake done in login.functions.ic.php!
The script works fine. Good tut, now i’m gonna study it all for expand and opttimize it!
Jim

December 25th, 2008 at 17:02 | #43

Reply | Quote

Blank screens:

Change this:

echo ‘ // ” in stead of ‘, also below at the ‘a href’ commands
Welcome $u

Change Password
Logout

‘;
manu

January 2nd, 2009 at 17:15 | #44

Reply | Quote

insert into login (username,password,email,activated) value (‘admin’,sha1(concat(‘yourpasswordhere’,’0dAfghRqSTgx’)),’youremailhere’,’1′);

Could not connect !
Please contact the site’s administrator.

DONDE SE PONE ..NO ME PUEDO CONECTAR A LA BASE DE DATOS.
MEDA ESTE ERROR.

ME LO PUEDEN ALCLAR UN POCO MEJOR PORFAVOR.

mafey_fc@hotmail.com.
h

January 3rd, 2009 at 00:22 | #45

Reply | Quote

@manu
there’s an error… it is not activated it is actcode… Please make sure that you are connected. Which front-end are you using?
manu

January 4th, 2009 at 00:17 | #46

Reply | Quote

insert into login (username,password,email,activated) value (‘admin’,sha1(concat(‘yourpasswordhere’,’0dAfghRqSTgx’)),’youremailhere’,’1′);

:’( donde pongo esto me trae loco
ayuda por favor. gracias
manu

January 5th, 2009 at 12:00 | #47

Reply | Quote

HELP PLISS

Could not connect !
Please contact the site’s administrator.
Kai

January 9th, 2009 at 19:07 | #48

Reply | Quote

This system is working perfect, if you get blank screens change header.php.

It wants to include functions.inc.php, this needs to be changed to function.inc.php without the “s”.

Thanx for the tut.
manu

January 11th, 2009 at 19:35 | #49

Reply | Quote

This system is working perfect, if you get blank screens change header.php.

It wants to include functions.inc.php, this needs to be changed to function.inc.php without the “s”.
thank you kay
example pliss heer
manu

January 11th, 2009 at 20:23 | #50

Reply | Quote

insert into login (username,password,email,activated) value (‘admin’,sha1(concat(‘xxxxxxxxxxx’,’0dAfghRqSTgx’)),’mafey_fc@hottmail.com’,’1′);

Could not connect !
Please contact the site’s administrator.

they can help me, this goes within the data base (you) or where it is put I am not able to connect gives east error me. they prodian to me to put an example. or to put itself in contact with me my post office is, mafey_fc@hotmail.com

MySQL ha dicho: Documentación
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”,sha1(concat(XXXXXX)’mafey_fc@hotmail.com’,’1′);

‘,’0dAfghRqSTgx’)),’ at line 1

Comment pages

« Previous 1 2 3 4 ... 6 Next » 25

January 17th, 2008 at 22:00 | #1

Sistema de Login de Usuarios en PHP | HNKweb
February 5th, 2008 at 16:16 | #2

Complete advanced login member system – PHP tutorial « PHP Net
June 30th, 2008 at 10:36 | #3

Over 50 of The Best Tutorials from 2008 (so far) « NI-Limits Blog

The Concept Behind CSS Sending emails with php – php tutorial