Postingan lainnya

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();

php ajax database

@stefanuspn

250 Kontribusi 69 Poin

Dipost 6 tahun yang lalu

Belum ada Jawaban. Jadi yang pertama Jawaban