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
Versi terdahulu adalah berdasarkan LED, di mana resolusi paparan adalah terhad kepada hanya sebilangan kecil piksel.
