Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
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