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.
1. Database
MySQL admin table columns id, username, passcode.
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(30) UNIQUE,
passcode VARCHAR(30)
);
2. Config.php
Database configuration file.
$mysql_hostname = “localhost“;
$mysql_user = “user“;
$mysql_password = “password“;
$mysql_database = “db“;
$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“);
3. Login.php
Contains PHP and HTML code.
include(“config.php“);
session_start();
if($_SERVER[“REQUEST_METHOD“] == “POST“)
{
$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($count==1)
{
session_register(“myusername”);
$_SESSION[‘login_user‘]=$myusername;
header(“location: welcome.php”);
}
else
{
$error=”Your Login Name or Password is invalid“;
}
}
4. lock.php
Session verification. If no session value page redirect to login.php
include(‘config.php‘);
session_start();
$user_check=$_SESSION[‘login_user‘];
$ses_sql=mysql_query(“select username from admin where username=’$user_check’“);
$row=mysql_fetch_array($ses_sql);
$login_session=$row[‘username‘];
if(!isset($login_session))
{
header(“Location: login.php“);
}
5. welcome.php
include(‘lock.php‘);
<h1>Welcome <?php echo $login_session; ?></h1>
6. logout.php
SignOut Destroy the session value.
session_start();
if(session_destroy())
{
header(“Location: login.php“);
}
Related Posts
Create a Date With PHP Javascript Periodic Table of the Elements