Showing posts with label Programming. Show all posts
Showing posts with label Programming. Show all posts

Thursday, 1 August 2013

PHP simple login system with session

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
now create new file name logout.php
logout.php code

Finish now its time to test

before that you need to insert user on your database.
for example
Login form

login successful
 

Recent Posts

ping busuk

Pingje

There was an error in this gadget

Google+ Followers

HarryD Blog © 2013. All Rights Reserved | Back To Top