Are you looking for PHP login script, in this post I want to discuss how to create a simple PHP login with welcome page using MySQL database. This will explain you creating admin_login tables, posting form values and storing and destroying the session values. If you are a PHP beginner download script and take a quick look at this live demo with Username : admin Password : admin. This post has been updated with mysqli.
Database
MySQL admin table columns id, loginid and password.
CREATE TABLE IF NOT EXISTS `admin_login` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`loginid` varchar(30) DEFAULT NULL,
`password` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `loginid` (`loginid`)
)
dbconfig.php
Database configuration file.
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'database');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>
index.php (login form page)
Contains PHP, HTML and CSS code.
<?php
include("dbconfig.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST")
{
// loginid and password sent from form
$loginid=mysqli_real_escape_string($db,$_POST['loginid']);
$password=mysqli_real_escape_string($db,$_POST['password']);
$sql="SELECT id FROM admin_login WHERE loginid='$loginid' and password='$password'";
$result=mysqli_query($db,$sql);
$count=mysqli_num_rows($result);
// If result matched $loginid and $password, table row must be 1 row
if($count==1)
{
$row=mysqli_fetch_array($result,MYSQLI_ASSOC);
$active=$row['id'];
session_register("loginid");
$_SESSION['login_name']=$loginid;
header("location: welcome.php");
}
else
{
$error="Your Login Name or Password is invalid";
}
}
?>
<?php
if(isset($error))
{
echo '<div style="font-size:11px; color:#FF0000; margin-top:10px">'.$error.'</div>';
}
?>
<!--CSS CODE-->
<style type="text/css">
body {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:14px;
}
label {
font-weight:bold;
width:100px;
font-size:14px;
}
.box {
border:#666666 solid 1px;
}
.btn {
font-weight:bold;
color:#FFFFFF;
background:#0033FF;
border-radius:3px;
border:none;
}
</style>
<!--HTML CODE-->
<form action="" method="post">
<label>Login ID : </label>
<input type="text" name="loginid" class="box"/>
<br />
<br />
<label>Password : </label>
<input type="password" name="password" class="box" />
<br/>
<br />
<input type="submit" value=" Submit " class="btn"/>
<br />
</form>
lock.php
Session verification. If no session value page redirect to index.php (login page)
<?php
include('dbconfig.php');
session_start();
$user_check=$_SESSION['login_name'];
$ses_sql=mysqli_query($db,"select loginid from admin_login where loginid='$user_check' ");
$row=mysqli_fetch_array($ses_sql,MYSQLI_ASSOC);
$login_session=$row['loginid'];
if(!isset($login_session))
{
header("Location: index.php");
}
?>
welcome.php
<?php
include('lock.php');
?>
<body>
<h1>Welcome <?php echo $login_session; ?></h1>
</body>
logout.php
SignOut Destroy the session value.
<?php
session_start();
if(session_destroy())
{
header("Location: index.php");
}
?>
