file.php (Auto Create New File header.php with login system,footer.php,index.php,login.php & Logout.php )
Please Save Old File. otherwise auto delete after url hits
SELECT * FROM `admin` WHERE `username` = '$username' AND `password` = '$password'
(Please change using this sql in header.php & login.php )
header.php
<?php
if(isset($_COOKIE["username"]) AND isset($_COOKIE["password"])){
include("dbcon.php");
$username = $_COOKIE["username"];
$password = $_COOKIE["password"];
$sql560 = "SELECT * FROM `admin` WHERE `username` = '$username' AND `password` = '$password'";
$run560 = mysqli_query($con,$sql560);
$total560 = mysqli_num_rows($run560);
if($total560===0){
header("location: login.php");
}
}else{
header("location: login.php");
}
?>
login.php
<?php include("dbcon.php"); ?>
Login
<?php if(isset($_REQUEST["smtbtn"])){
$username = $_REQUEST["username"];
$password = $_REQUEST["password"];
$sql = "SELECT * FROM `admin` WHERE `username` = '$username' AND `password` = '$password'";
$run = mysqli_query($con,$sql);
$total = mysqli_num_rows($run);
if($total===1){
setcookie("username",$username, time() + (86400 * 30), "/");
setcookie("password",$password, time() + (86400 * 30), "/");
header("location: index.php");
}else{
echo "Login Failed, Check Password ";
}
}
?>
logout.php
<?php
$username = $_COOKIE["username"];
$password = $_COOKIE["password"];
setcookie("username",$username, time() - (86400 * 30), "/");
setcookie("password",$password, time() - (86400 * 30), "/");
header("location: login.php");
?>
database
CREATE TABLE `admin` (
`id` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL
,
`date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `admin`
ADD PRIMARY KEY (`id`);
ALTER TABLE `admin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
INSERT INTO `admin`(`username`, `password`) VALUES ('test','1234')