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 :(

avatar randishady25
@randishady25

15 Kontribusi 1 Poin

Diperbarui 4 tahun yang lalu

4 Jawaban:

coba ganti <pre> if(isset($_POST['username']) && ($_POST['password'])) </pre> jadi <pre> if(isset($_POST['login'])) </pre>

avatar kanganjay08
@kanganjay08

41 Kontribusi 13 Poin

Dipost 5 tahun yang lalu

<pre>

if(isset($_POST['login'])){

 $username = mysqli_real_escape_string($_POST[&#039;username&#039;]);
 $password = mysqli_real_escape_string($_POST[&#039;password&#039;]);
 $sql = &quot;select * from user where username = &#039;$username&#039; AND password = &#039;$password&#039;&quot;;
 $result = $conn-&amp;gt;query($sql) or die(&#039;Terjadi Kesalahan : &#039;.$conn-&amp;gt;mysqli_error);

if ($result-&amp;gt;mysqli_num_rows &amp;gt; 0){
      $row = $result-&amp;gt;mysqli_fetch_array();
	  
			$_SESSION[&#039;login&#039;] = true;
      $_SESSION[&#039;username&#039;] = $row[&#039;username&#039;];
      $_SESSION[&#039;nama&#039;] = $row[&#039;nama&#039;];
      $_SESSION[&#039;level&#039;] = $row[&#039;level&#039;];
      $_SESSION[&#039;id_user&#039;] = $row[&#039;id_user&#039;];
      header(&quot;location:index.php&quot;);
			echo &quot;&amp;lt;script&amp;gt;alert(&#039;Selamat Datang...&#039;);location.href=&#039;index.php&#039;&amp;lt;/script&amp;gt;&quot;;
}else{
      echo &quot;&amp;lt;script&amp;gt;alert(&#039;Maaf, username atau password salah..&#039;);location.href=&#039;login.php&#039;&amp;lt;/script&amp;gt;&quot;;
}

}else{ echo "&lt;script&gt;alert('Maaf, username atau password salah..');location.href='login.php'&lt;/script&gt;"; }

</pre>

avatar zakkiaz
@zakkiaz

10 Kontribusi 2 Poin

Dipost 5 tahun yang lalu

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[&quot;password&quot;];
  
  $email  = $_POST[&quot;email&quot;];




// cek email
$result = mysqli_query($conn,&quot;SELECT * FROM user 
  WHERE email =&#039;$email&#039;&quot;);

if(mysqli_num_rows($result) === 1){


  //cek passwoed
  $row = mysqli_fetch_assoc($result);
  if(password_verify($password, $row[&quot;password&quot;])){



   //if($password = password_hash($password, PASSWORD_DEFAULT));{

    //set session
    $_SESSION[&quot;login&quot;] = true;

    header(&quot;location: lapor_banjir.php&quot;);
    exit;

}
  }

permasalahan saya sama gan. tapi saya gagal di passwordnya.

padahal kayaknya gak ada yg salah. mhn pencerahannya

avatar eben2512
@eben2512

17 Kontribusi 4 Poin

Dipost 4 tahun yang lalu

<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[&quot;password&quot;];
  
  $email  = $_POST[&quot;email&quot;];




// cek email
$result = mysqli_query($conn,&quot;SELECT * FROM user 
  WHERE email =&#039;$email&#039;&quot;);

if(mysqli_num_rows($result) === 1){


  //cek passwoed
  $row = mysqli_fetch_assoc($result);
  if(password_verify($password, $row[&quot;password&quot;])){



   //if($password = password_hash($password, PASSWORD_DEFAULT));{

    //set session
    $_SESSION[&quot;login&quot;] = true;

    header(&quot;location: lapor_banjir.php&quot;);
    exit;

}
  }

</pre>

permasalahan saya sama gan. tapi saya gagal di passwordnya.

padahal kayaknya gak ada yg salah. mhn pencerahannya

avatar eben2512
@eben2512

17 Kontribusi 4 Poin

Dipost 4 tahun yang lalu

Login untuk ikut Jawaban