Login PHP Mysql
Tambah Script Pada File Koneksi
PHP
<?php session_start(); ?>
Script File Login
<?php require_once('koneksi.php'); ?>
<!-- Fungsi -->
<?php
function run($query){
global $link;
if (mysqli_query($link, $query)) return true;
else return false;
}
function escape($data){
global $link;
return mysqli_real_escape_string($link, $data);
}
?>
<!-- Login -->
<?php
function cek_login($username, $password){
$username = escape($username);
$password = escape($password);
$password = md5($password);
$query = "SELECT * FROM admin WHERE username='$username' AND password='$password'";
global $link;
if ($result = mysqli_query($link, $query)) {
if(mysqli_num_rows($result) != 0){
return true;
}else{
return false;
}
}
}
function session_id_admin($username){
global $link;
$query = "SELECT * FROM admin WHERE username = '$username'";
$result = mysqli_query($link, $query) or die('Gagal Menampilakan Data');
if(mysqli_num_rows($result) > 0){
$row = mysqli_fetch_assoc($result);
$id_user = $row['id_admin'];
return $id_user;
}
}
?>
<?php
if(isset($_SESSION['admin'])){
echo("<script>location.href = 'login.php';</script>");
}else{
$error = '';
if(isset($_POST['Login'])) {
$username = $_POST['username'];
$password = $_POST['password'];
if(!empty(trim($username)) && !empty(trim($password))){
if(cek_login($username, $password)){
$_SESSION['admin'] = $username;
$_SESSION['id_admin'] = session_id_admin($username);
echo("<script>location.href = 'index.php';</script>");
}else{
$error = 'Username Atau Password Salah';
}
}else{
$error = 'Username dan Password Harus Diisi';
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Halaman Login Rental Mobil</title>
<style>
body{
font-family: arial;
font-size: 14px;
background-color: #AAA;
}
#box-judul{
width: 300px;
margin: 0 auto;
margin-top: 12%;
}
#judul{
padding: 15px;
text-align: center;
color: #ffffff;
font-size: 20px;
background-color: #66CCFF;
border-top-right-radius: 10px;
border-top-left-radius: 10px;
border-bottom: 3px solid #00aaFF;
}
#box-form{
background-color: #ffffff;
padding: 20px;
border-bottom-right-radius: 10px;
border-bottom-left-radius: 10px;
}
input{
padding: 10px;
border: 0;
}
.iuser, .ipass{
width: 240px;
}
.iuser:hover, .ipass:hover{
border: 2px solid #00aaFF;
}
.btnlogin{
background-color: #66CCFF;
color: #ffffff;
border-radius: 5px;
width: 260px;
}
.btnlogin:hover{
background-color: #00aaFF;
cursor: pointer;
transition: 1.5s;
}
</style>
</head>
<body>
<div id="box-judul">
<div id="judul"><br> Halaman Login</div>
<div id="box-form">
<form action="" method="post">
<div>
<input type="text" name="username" placeholder="Username" class="iuser">
<div style="margin-top: 10px;"></div>
<input type="password" name="password" placeholder="Password" class="ipass">
<div style="margin-top: 10px;"></div>
<div id="error"><?php echo $error ?></div>
<input type="submit" name="Login" value="Login" class="btnlogin">
</div>
</form>
</div>
</div>
</body>
</html>
<?php } ?>
Script File logout
<?php require_once('koneksi.php'); ?>
<?php
unset($_SESSION['login']);
session_destroy();
echo("<script>location.href = 'login.php';</script>");
?>
Script Untuk tidak boleh masuk sebelum login
<?php
if(!$_SESSION['admin']){
echo("<script>location.href = 'login.php';</script>");
}
?>
0 Response to "Login PHP Mysql"
Posting Komentar