This is very Simple User Registration & Login Script in PHP
and MySQL, in this tutorial user can register, login, access member secure area
and logout.
Steps to Creating Simple User Registration & Login Script in
PHP and MySQL
6.
Authenticate Logged in User
1.
Create Index Page
3. Creating a Registration Form
<!DOCTYPE html>
4. Creating a Login Form
<!DOCTYPE html>
5. Connect to the Database
<?php
6. Authenticate Logged in User
7. Creating Index Page
Create a page with name index.php and paste the below code in
it.
<?php include("auth.php");
//include auth.php file on all secure pages ?>
8. Creating Dashboard Page
<?php include("auth.php");
//include auth.php file on all secure pages ?>
9. Creating a Log Out
<?php
10. Creating a CSS File
body
{font-family:Arial, Sans-Serif;}
Note: In the above tutorial CSS file is placed in css/style.css
folder. So make sure that you also placed CSS file in css folder.
This is very Simple User Registration & Login Script in PHP
and MySQL, in this tutorial user can register, login, access member secure area
and logout.
Steps to Creating Simple User Registration & Login Script in
PHP and MySQL
1.
Create a Database
2.
Create a Database Table with Five Fields
·
id
·
username
·
email
·
password
·
trn_date
3.
Create a Registration Form
4.
Create a Login Form
5.
Connect to the Database by using PHP
6.
Authenticate Logged in User
1.
Create Index Page
2.
Create Dashboard Page
3.
Create a Log Out
4.
Create a CSS File
1. Create a Database
For create a database, login to phpmyadmin, click on
database tab, enter your desired database name and click on create
database button or simply execute the below query. Here i created database with
name register.
1 CREATE DATABASE register;
2. Creating a Database Table
Execute the below query in SQL
CREATE TABLE IF
NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username`
varchar(50) NOT NULL,
`email`
varchar(50) NOT NULL,
`password`
varchar(50) NOT NULL,
`trn_date`
datetime NOT NULL,
PRIMARY KEY (`id`)
);
3. Creating a Registration Form
Create a page with name registration.php and paste the
below code in it.
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Registration</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<?php
require('db.php');
// If form
submitted, insert values into the database.
if
(isset($_POST['username'])){
$username =
$_POST['username'];
$email =
$_POST['email'];
$password =
$_POST['password'];
$username =
stripslashes($username);
$username =
mysql_real_escape_string($username);
$email =
stripslashes($email);
$email =
mysql_real_escape_string($email);
$password =
stripslashes($password);
$password =
mysql_real_escape_string($password);
$trn_date =
date("Y-m-d H:i:s");
$query =
"INSERT into `users` (username, password, email, trn_date) VALUES
('$username', '".md5($password)."', '$email', '$trn_date')";
$result =
mysql_query($query);
if($result){
echo
"<div class='form'><h3>You are registered
successfully.</h3><br/>Click here to <a href='login.php'>Login</a></div>";
}
}else{
?>
<div class="form">
<h1>Registration</h1>
<form name="registration" action="" method="post">
<input type="text" name="username" placeholder="Username" required
/>
<input type="email" name="email" placeholder="Email" required
/>
<input type="password" name="password" placeholder="Password" required
/>
<input type="submit" name="submit" value="Register" />
</form>
</div>
<?php }
?>
</body>
</html>
4. Creating a Login Form
Create a page with name login.php and paste the below code in
it.
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Login</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<?php
require('db.php');
session_start();
// If form
submitted, insert values into the database.
if
(isset($_POST['username'])){
$username =
$_POST['username'];
$password =
$_POST['password'];
$username =
stripslashes($username);
$username = mysql_real_escape_string($username);
$password =
stripslashes($password);
$password =
mysql_real_escape_string($password);
//Checking is
user existing in the database or not
$query =
"SELECT * FROM `users` WHERE username='$username' and password='".md5($password)."'";
$result =
mysql_query($query) or die(mysql_error());
$rows =
mysql_num_rows($result);
if($rows==1){
$_SESSION['username']
= $username;
header("Location:
index.php"); // Redirect user to index.php
}else{
echo
"<div class='form'>
<h3>Username/password is
incorrect.</h3><br/>Click here to <a href='login.php'>Login</a></div>";
}
}else{
?>
<div class="form">
<h1>Log
In</h1>
<input type="text" name="username" placeholder="Username" required
/>
<input type="password" name="password" placeholder="Password" required
/>
<input name="submit" type="submit" value="Login" />
</form>
<p>Not
registered yet? <a href='registration.php'>Register Here</a></p>
</div>
<?php }
?>
</body>
</html>
5. Connect to the Database
Create a page with name db.php and paste the below code in it.
<?php
$connection =
mysql_connect('localhost', 'root', '');
if (!$connection){
die("Database
Connection Failed" . mysql_error());
}
$select_db =
mysql_select_db('register');
if (!$select_db){
die("Database
Selection Failed" . mysql_error());
}
?>
6. Authenticate Logged in User
Create a page with name auth.php and paste the below code in it.
<?php
session_start();
if(!isset($_SESSION["username"])){
header("Location:
login.php");
exit(); }
?>
7. Creating Index Page
Create a page with name index.php and paste the below code in
it.
<?php include("auth.php");
//include auth.php file on all secure pages ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Welcome
Home</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<div class="form">
<p>Welcome
<?php echo $_SESSION['username']; ?>!</p>
<p>This is
secure area.</p>
<p><a href="dashboard.php">Dashboard</a></p>
<a href="logout.php">Logout</a>
</div>
</body>
</html>
8. Creating Dashboard Page
Create a page with name dashboard.php and paste the below code in
it.
<?php include("auth.php");
//include auth.php file on all secure pages ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Dashboard</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<div class="form">
<p>This is
another secured page.</p>
<p><a href="index.php">Home</a></p>
<a href="logout.php">Logout</a>
</div>
</body>
</html>
9. Creating a Log Out
Create a page with name logout.php and paste the below code in
it.
<?php
session_start();
if(session_destroy())
// Destroying All Sessions
{
header("Location:
login.php"); // Redirecting To Home Page
}
?>
10. Creating a CSS File
Create a page with name style.css and paste the below code in
it.
body
{font-family:Arial, Sans-Serif;}
.clearfix:before,
.clearfix:after { content: ""; display: table; }
.clearfix:after {
clear: both; }
a {color:#78b941;
text-decoration:none;}
a:hover
{text-decoration:underline;}
.form{width: 300px;
margin: 0 auto;}
input[type='text'],
input[type='email'], input[type='password'] {width: 200px; border-radius:
2px;border: 1px solid #CCC; padding: 10px; color: #333; font-size: 14px;
margin-top: 10px;}
input[type='submit']{padding:
10px 25px 8px; color: #fff; background-color: #78b941; text-shadow:
rgba(0,0,0,0.24) 0 1px 0; font-size: 16px; box-shadow: rgba(255,255,255,0.24) 0 2px 0 0 inset,#fff 0 1px 0 0;
border: 1px solid #6faf38; border-radius: 2px; margin-top: 10px;
cursor:pointer;}
input[type='submit']:hover
{background-color: #80c248;}
Note: In the above tutorial CSS file is placed in css/style.css
folder. So make sure that you also placed CSS file in css folder.
Real Translator Jobs - New Top Offer! - $100 Bonus To New Affiliates! (view mobile)
No comments :
Post a Comment