PHP Login Page Example.(USING SESSION)
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.
Config.php
Database configuration file.
Login.php
Contains PHP and HTML code.
welcome.php
logout.php
SignOut Destroy the session value.
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: