Connect .php

<?php

mysql_connect(“localhost”, “root”, “”);  //connects to the server

mysql_select_db(“users”);  //selects the database

?>

In the first line you are connecting to your server. I am provided with the default credentials. If you have changed them to your needs then you need to alter them.

Now lets create the file where you are gonna allow the users to register.

Register.php

Register

<form action = “register.php” method = “post”>

Username : <input type = “text” name = “username”>

Password : <input type = “password” name = “password”>

Email : <input type = “email” name = “mail”>

<input type = “submit” value = “Register”>

</form>

<?php

include ‘connect.php’;

$username = $_POST['username'];

$password = md5($_POST['password']);

$email = $_POST['mail'];

$userexists = mysql_num_rows(mysql_query(“SELECT username FROM users WHERE username = ‘$username’”));

if(empty($username) || empty($password) || empty($email){

echo “All Fields are mandatory”;

}
else if($userexists == 1){

echo “The user already exists”;

exit();

}

mysql_query(“INSERT INTO `users`.`users` (`id` ,`username` ,`password` ,`email`) VALUES (NULL , ‘$username’, ‘$password’, ‘$email’);”);
?>

Now here comes the important part of it. You need to create a file called as main.php which starts a session and it controls whether the user is logged in or not.

Main.php

<?php

session_start();

?>

Lets get started with creating the login file.

Login.php

<form action = “login.php” method = “post”>

Username : <input type = “text” name = “username”>

Password : <input type = “password” name = “password”>

<input type = “submit” value = “Login”>

</form>

You need to create the login PHP script. Add the following in your file.

<?php

include ‘main.php’;

include ‘connect.php’;

$username = $_POST['username'];

$password = md5($_POST['password']);

$query = mysql_query(“SELECT id,username, password FROM users WHERE username = ‘$username’”);

if(!$query)

echo “There is no such user with the entered username”;

else{

$details = mysql_fetch_assoc($query);

$usr = $details['username'];

$pass = $details['password'];

$id = $details['id'];

if($pass == $password){

$_SESSION['id'] = $id;

header(“Location: loggedin.html”);

}

else

echo “The username and password combination does not match”;

}

?>

And now you need to create a page where you need to redirect the user after he logs in. I have named the page as loggedin.php which contains a message “Welcome user” and the logout link.

Loggedin.php

<?php

include ‘main.php’;

if(!isset($_SESSION['id']))

echo “You need to login to view this page”;

else{

echo “Welcome User”;

echo “<a href = ‘logout.php’>Logout</a>”;

}

?>

Here comes the final part of the tut. You are now about to create the logout page. Thats pretty simple. Lets see on how to do that.

Logout.php

<?php

session_start();

session_destroy();

header(“Location: login.php”);

?>

Thats it ! You have completed creating the login register system using php. Post your doubts as comments. Stay tuned for more such tuts on PHP.