Postingan lainnya
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Tidak bisa login padahal username dengan password sudah benar
proseslogin.php
<?php
include "koneksi.php";
if(isset($_POST['username']) && ($_POST['password'])){
$username = mysqli_real_escape_string($_POST['username']);
$password = mysqli_real_escape_string($_POST['password']);
$sql = "select * from user where username = '$username' AND password = '$password'";
$result = $conn->query($sql) or die('Terjadi Kesalahan : '.$conn->mysqli_error);
if ($result->mysqli_num_rows > 0){
$row = $result->mysqli_fetch_array();
$_SESSION['login'] = true;
$_SESSION['username'] = $row['username'];
$_SESSION['nama'] = $row['nama'];
$_SESSION['level'] = $row['level'];
$_SESSION['id_user'] = $row['id_user'];
header("location:index.php");
echo "<script>alert('Selamat Datang...');location.href='index.php'</script>";
}else{
echo "<script>alert('Maaf, username atau password salah..');location.href='login.php'</script>";
}
}else{
echo "<script>alert('Maaf, username atau password salah..');location.href='login.php'</script>";
}
?>
login.php
<html>
<head>
<title>Halaman Login</title>
<link rel="stylesheet" type="text/css" href="css/login.css">
</head>
<body>
<div class="login-box">
<img src="image/login.jpg" class="avatar">
<form action="proseslogin.php" method="POST">
<h1>Masuk</h1>
<input name="username" type="text" placeholder="Masukan Nama Pengguna Disini">
<input name="password" type="password" placeholder="Masukan Kata Sandi Disini">
<input name="login" value="Login" type="submit">
<input name="reset" value="Batal" type="reset">
<p>Belum Punya akun ?</P><a href="daftar.php"><b>DAFTAR</b></a>
</form>
</div>
</body>
</html>
index.php
<?php
include "koneksi.php";
$nama = $_SESSION['nama'];
?>
<html>
<head>
<title>Tampilan Utama</title>
<link rel="stylesheet" type="text/css" href="css/index.css">
</head>
<body>
<?php
include "header.php";
?>
<div id="content">
</div>
<div id="footer">
</div>
</body>
salahnya dimna yah gan ? pdhl username sama password di database sudah benar. sengaja gak saya kasih hash dll jd seharusnya menurut saya sih udh bisa login. tp nyatanya engga :(
4 Jawaban:
coba ganti <pre> if(isset($_POST['username']) && ($_POST['password'])) </pre> jadi <pre> if(isset($_POST['login'])) </pre>
<pre>
if(isset($_POST['login'])){
$username = mysqli_real_escape_string($_POST['username']);
$password = mysqli_real_escape_string($_POST['password']);
$sql = "select * from user where username = '$username' AND password = '$password'";
$result = $conn-&gt;query($sql) or die('Terjadi Kesalahan : '.$conn-&gt;mysqli_error);
if ($result-&gt;mysqli_num_rows &gt; 0){
$row = $result-&gt;mysqli_fetch_array();
$_SESSION['login'] = true;
$_SESSION['username'] = $row['username'];
$_SESSION['nama'] = $row['nama'];
$_SESSION['level'] = $row['level'];
$_SESSION['id_user'] = $row['id_user'];
header("location:index.php");
echo "&lt;script&gt;alert('Selamat Datang...');location.href='index.php'&lt;/script&gt;";
}else{
echo "&lt;script&gt;alert('Maaf, username atau password salah..');location.href='login.php'&lt;/script&gt;";
}
}else{ echo "<script>alert('Maaf, username atau password salah..');location.href='login.php'</script>"; }
</pre>
session_start();
if(isset($_SESSION['login'])){ header('location: lapor_banjir.php'); } include 'templates/header.php';
$conn = mysqli_connect("localhost","root","","pupr");
if(isset($_POST["login"])){
$password = $_POST["password"];
$email = $_POST["email"];
// cek email
$result = mysqli_query($conn,"SELECT * FROM user
WHERE email ='$email'");
if(mysqli_num_rows($result) === 1){
//cek passwoed
$row = mysqli_fetch_assoc($result);
if(password_verify($password, $row["password"])){
//if($password = password_hash($password, PASSWORD_DEFAULT));{
//set session
$_SESSION["login"] = true;
header("location: lapor_banjir.php");
exit;
}
}
permasalahan saya sama gan. tapi saya gagal di passwordnya.
padahal kayaknya gak ada yg salah. mhn pencerahannya
<pre> session_start();
if(isset($_SESSION['login'])){ header('location: lapor_banjir.php'); } include 'templates/header.php';
$conn = mysqli_connect("localhost","root","","pupr");
if(isset($_POST["login"])){
$password = $_POST["password"];
$email = $_POST["email"];
// cek email
$result = mysqli_query($conn,"SELECT * FROM user
WHERE email ='$email'");
if(mysqli_num_rows($result) === 1){
//cek passwoed
$row = mysqli_fetch_assoc($result);
if(password_verify($password, $row["password"])){
//if($password = password_hash($password, PASSWORD_DEFAULT));{
//set session
$_SESSION["login"] = true;
header("location: lapor_banjir.php");
exit;
}
}
</pre>
permasalahan saya sama gan. tapi saya gagal di passwordnya.
padahal kayaknya gak ada yg salah. mhn pencerahannya