Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
login dengan php mysql ajax
assalamualaikum saya mau nanya saya coba login dengan ajax tapi kok malah begini ya ? padahal datanya gak ada yg salah dan saya coba cek di console log gak ada yg error
skrip index.php
<!Doctype html>
<html>
<head>
<script src="assets/js/jquery.min.js"></script>
<script src="asset/js/sweetalert.min.js"></script>
<script src= "assets/js/bootstrap.min.js"></script>
<link href="assets/css/bootstrap.min.css">
<link href="assets/css/sweetalert.min.css" rel="stylesheet">
<link href="assets/css/animate.css" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Montserrat|Baloo+Thambi" rel="stylesheet" media="screen">
</head>
<body>
<div class="login-box">
<div class="login-logo animated rollIn" style="color:black;">
kodingpedia
</div>
<!-- /.login-logo -->
<div class="alert alert-danger" role="alert"> </div>
<div class="panel panel-primary animated bounceInLeft" style="">
<div class="panel-heading"><b><p class="login-box-msg">Login Form</p></b></div>
<div class="panel-body">
<div class="login-box-body">
<form class="login-form" >
<div class="input-group">
<div class="input-group-addon"><i class="glyphicon glyphicon-user"></i></div>
<input type="text" name="user" placeholder="Username" autofocus class="form-control">
</div><br/>
<div class="input-group">
<div class="input-group-addon"><i class="glyphicon glyphicon-lock"></i></div>
<input type="password" name="pass" placeholder="password" autofocus class="form-control">
</div><br/>
<button name="login" class="btn btn-primary pull-right login-button" >
<i class="glyphicon glyphicon-log-in"></i> Login Admin
</button><br/>
</form>
<br>
<a href="#" data-target="#registerform" data-toggle="modal"><i class="fa fa-users"></i> Register new User</a>
</div>
</div>
</div>
<!-- /.login-box-body -->
</div>
<script type="text/javascript">
$(function(){
$('.alert').hide();
$('.login-form').submit(function(){
$('.alert').hide();
if($('input[name=user]').val() == ""){
swal('Oops!', 'Sorry Gan user masih kosong!.', 'error'); setTimeout(1000);
}else if($('input[name=pass]').val() == ""){
swal('Oops!', 'Sorry Gan password kosong!.', 'error'); setTimeout(1000);
}else{
$.ajax({
type : "POST",
url : "ceklogin.php",
data : $(this).serialize(),
success : function(data){
if(data == "ok") {
window.location = "home.php";
}
else {
$('.alert').fadeIn().html(data);
}
}
});
}
return false;
});
});
</script>
<body>
</html>
skrip ceklogin.php
<?php
require_once"config.php";
date_default_timezone_Set("Asia/Jakarta");
// Mengambil waktu awal proses
if(isset($_POST['login']) ) {
$username = $_POST['username'];
$password = $_POST['password'];
$lib = $db->login_check($username);
$lib2 = $db->cek_data_admin($username,$password);
if(!empty(trim($username)) && !empty(trim($password)) ) {
if($lib) {
if($lib2) {
$_SESSION['admin_id'] = $username;
$_SESSION['nama'] = $username ;
$_SESSION['timeout'] = time()+1000;
$_SESSION['login'] = 1;
echo "ok";
}else {
echo"data ada yg salah";
}
}else{
echo"belum daftar";
}
}else{
echo"data gak boleh kosong";
}
}
?>
skrip config.php
class Kodingpedia
{
private $query;
function __construct()
{
$this->mysqli = new mysqli ("localhost","root","","kodingpedia");
}
/*function SQL*/
/* function Login */
function cek_data_admin($username,$password) {
$username = mysqli_real_escape_string($this->mysqli,$username);
$password = mysqli_real_escape_string($this->mysqli,$password);
$sql = "SELECT * FROM admin WHERE email = '$username' or username ='$username'";
$result = $this->mysqli->query($sql);
$hash = mysqli_fetch_assoc($result)['password'];
if(password_verify($password,$hash) ) {
return true;
}else {
return false;
}
}
function login_check($username) {
$username = mysqli_real_escape_string($this->mysqli,$username);
$sql = "SELECT * from admin where email ='$username' or username ='$username' ";
if($result = $this->mysqli->query($sql) ) {
if( $result->num_rows != 0 )
return true;
}else {
return false;
}
}
//membuat proses daftar
function register_admin($email, $nama, $username,$nohp, $password,$date,$foto_admin){
//mencegah sql injection
$email = mysqli_real_escape_string($this->mysqli,$email);
$nama = mysqli_real_escape_string($this->mysqli,$nama);
$username = mysqli_real_escape_string($this->mysqli,$username);
$nohp = mysqli_real_escape_string($this->mysqli,$nohp);
$password = mysqli_real_escape_string($this->mysqli,$password);
$foto_admin = mysqli_real_escape_string($this->mysqli,$_FILES['file']['name']);
//enkripsi password
$password = password_hash($password, PASSWORD_DEFAULT);
$query = "insert into admin(nama,email,username,nohp,password,date_register,foto_admin) values('$nama','$email','$username','$nohp','$password','".date("Y-m-d")."','$foto_admin')";
$sql = $this->mysqli->query($query);
if($sql) {
return true;
}else {
return false;
}
}
//mengecek ketersediaan email,no hp ,dan password
function register_cek($email, $nohp) {
$email = mysqli_real_escape_string($this->mysqli,$email);
$nohp = mysqli_real_escape_string($this->mysqli,$nohp);
$query = "SELECT * from admin where email ='$email' and nohp = '$nohp' ";
if($link = $this->mysqli->query($query)) {
if($link->num_rows == 0 )
return true;
else
return false;
}
}
}
$db= new Kodingpedia();
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban