Postingan lainnya
source code proses login error
<?php
include "koneksi.php";
$username = $_POST['user'];
$password = $_POST['pass'];
$query = mysqli_query("SELECT COUNT(username) AS jumlah FROM admin
WHERE username='$username' AND password='$password'");
$data = mysqli_fetch_array($query);
if ($data['jumlah'] >= 1){
session_start();
$_SESSION['username'] = $username;
//$_SESSION['password'] = $password;
echo "<script>alert('Selamat datang $username'); window.location = 'admin/tambah.php'</script>";
} else {
echo "<script>alert('Username dan Password tidak valid.'); window.location = 'index.html'</script>";
}
?>
ada keterangan error : - warning : mysqli_query() expects t least 2 parameters, - warning : mysqli_fetch_array() expects parameter 1 to be mysqli_result, mohon bantuannya ^_^
0
3 Jawaban:
// silahkan di coba gan. variabel $koneksi itu dari include koneksi.php
$query = mysqli_query($koneksi, "SELECT * FROM admin WHERE username='$username' AND password='$password'");
$data = mysqli_fetch_assoc($query);
1
Tanggapan
cara nulis masukin koneksi.php ke $koneksi gimana gan
mysqli_query harus 2 parameter, 1.Syntak SQL 2.koneksi, jadi koneksi ke databasenya di simpen di variable lalu di selipin. . Jadi: .
mysqli("kode SQL",$conn)
0