Fatal error: uncaught error: call to undefined method mysqli::mysqli_query()

<?php
session_start();
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->mysqli_query($sql) or die('Terjadi Kesalahan : '.$conn->mysqli_error);

    if ($result->mysqli_num_rows > 0){
          $row = $result->mysqli_fetch_assoc();

          $_SESSION['username'] = $row['username'];
          $_SESSION['nama'] = $row['nama'];
          $_SESSION['level'] = $row['administrator' or 'manajemen' or 'peminjam'];
          $_SESSION['id_user'] = $row['id_user'];
          header("location:index.php");
          $_SESSION['pesan'] = '<p><div class="alert alert-success">Selamat datang <b>'.$_SESSION['nama'].'</b></div></p>';

    }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>";
}
$level_a=$_SESSION['level'] == 'administrator';
$level_m=$_SESSION['level'] == 'manajemen';
$level_p=$_SESSION['level'] == 'peminjam';
?>

pagi gan maaf mau tanya ini salahnya dimana yah?

avatar randishady25
@randishady25

15 Kontribusi 1 Poin

Diperbarui 5 tahun yang lalu

1 Jawaban:

Jawaban Terpilih

<pre> &lt;?php session_start(); 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-&gt;query($sql) or die('Terjadi Kesalahan : '.$conn-&gt;mysqli_error);

if ($result-&amp;gt;mysqli_num_rows &amp;gt; 0){
      $row = $result-&amp;gt;mysqli_fetch_assoc();

      $_SESSION[&#039;username&#039;] = $row[&#039;username&#039;];
      $_SESSION[&#039;nama&#039;] = $row[&#039;nama&#039;];
      $_SESSION[&#039;level&#039;] = $row[&#039;administrator&#039; or &#039;manajemen&#039; or &#039;peminjam&#039;];
      $_SESSION[&#039;id_user&#039;] = $row[&#039;id_user&#039;];
      header(&quot;location:index.php&quot;);
      $_SESSION[&#039;pesan&#039;] = &#039;&amp;lt;p&amp;gt;&amp;lt;div class=&quot;alert alert-success&quot;&amp;gt;Selamat datang &amp;lt;b&amp;gt;&#039;.$_SESSION[&#039;nama&#039;].&#039;&amp;lt;/b&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;/p&amp;gt;&#039;;

}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;"; } $level_a=$_SESSION['level'] == 'administrator'; $level_m=$_SESSION['level'] == 'manajemen'; $level_p=$_SESSION['level'] == 'peminjam'; ?&gt; </pre>

avatar stefanuspn
@stefanuspn

250 Kontribusi 69 Poin

Dipost 5 tahun yang lalu

Login untuk ikut Jawaban