Header Ads

PHP Login Page Example

This post for PHP beginners Login Page Example. I want to explain creating database, posting form values, storing the session value and destroy the session. It's is very useful and simple.

Database
MySQL admin table columns id, username, passcode.



CREATE TABLE admin
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(30) UNIQUE,
passcode VARCHAR(30)
);



Config.php
Database configuration file.


$mysql_hostname = "hostname";
$mysql_user = "username";
$mysql_password = "password";
$mysql_database = "database";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)
or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");
?>



Login.php
Contains PHP and HTML code.

include("config.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST")
{
// username and password sent from Form
$myusername=addslashes($_POST['username']);
$mypassword=addslashes($_POST['password']);

$sql="SELECT id FROM admin WHERE username='$myusername' and passcode='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$active=$row['active'];
$count=mysql_num_rows($result);


// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
session_register("myusername");
$_SESSION['login_user']=$myusername;

header("location: welcome.php");
}
else
{
$error="Your Login Name or Password is invalid";
}
}
?>












welcome.php


include('lock.php');
?>

Welcome






logout.php
SignOut Destroy the session value.



session_start();
if(session_destroy())
{
header("Location: login.php");
}
?>

No comments:

Powered by Blogger.