Step 1 : Create database
You should already create database name. then create table name Users
You can create from phpmysql or other tools.
Sql Code
CREATE TABLE `users` (
`ID` int(2) NOT NULL AUTO_INCREMENT,
`Fullname` varchar(32) NOT NULL,
`Username` varchar(32) NOT NULL,
`Password` varchar(32) NOT NULL,
PRIMARY KEY (`ID`)
)
Step 2 : Create php file
Create file name
database.php,
login.php and
login_success.php on your directory
Step 3 : php code database connection
database.php
<?php
$dbhost = "localhost";
$dbuser = "root"; //your username database
$dbpass = ""; //Your password database
$dbname = "test"; //Your database name
$dblink = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
?>
Step 4 : login code and html form
<?php
session_start();
include("database.php");
if(isset($_POST['login'])){
$username = $_POST['username'];
$password = $_POST['password'];
if(!empty($username) && !empty($password)){ //Username and password must filled
$sql_login ="SELECT `ID`, `Fullname`, `Username`, `Password` FROM `users` WHERE `Username`='".$username."' AND `Password`='".$password."'";
$result = mysql_query($sql_login,$dblink);//execute the sql command
$rows = mysql_fetch_assoc($result);
if($rows['Username'] == $username && $rows['Password'] == $password){
$_SESSION['fullname'] = $rows['Fullname'];
header('Location: login_success.php');
}else{ //Wrong username or password
echo "<script>alert('invalid username or password please try again')</script>";
}
mysql_close();
}else{
echo "<font color=\"red\">Username and Password field are required</font>";
}
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Login</title>
</head>
<body>
<div style="width:350px;margin:0 auto;background-color:#0099FF;margin-top:50px;padding:5px;border:1px solid #666">
<h2>Login</h2>
<center>
<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
<p>Username
<input type="text" name="username" maxlength="32" />
</p>
<p>Password
<input type="password" name="password" maxlength="32" />
</p>
<p><input type="submit" name="login" value="LOGIN" /></p>
</form>
</center>
</div>
</body>
</html>
Step 5 : login_success.php and logout.php code
login_success.php
<?php
session_start();
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Login Successful</title>
</head>
<body>
<h2>Login Successful</h2>
<p>Hello <b><?php echo $_SESSION["fullname"] ?></b> <a href="logout.php">[LOGOUT]</a></p>
</body>
</html>
now create new file name logout.php
logout.php code
<?php
session_start();
session_destroy();
header('Location: login.php'); #redirect to login page
?>
Finish now its time to test
before that you need to insert user on your database.
for example
Login form
login successful
