Postingan lainnya
menampilkan data berdasarkan user yang login
hai...
disini saya ingin penampilkan data barang yang di pinjam berdasarkan user yang sedang login.
berikut data base yang saya miliki
1. tb_member ( id_member username password, nama_member, notlp, alamat, keterangan)
2. tb_barang (id_barang, nama_barang, jumlah, satuan)
3. tb_peminjam (id_peminjam, id_member(berelasi ke tb_member), id_barang(berelasi ke tb_barang), jmlpinjaman, tglpinjam, tglkembali, ket)
Berikut script loginnya
function login_cek($user)
{
global $conn;
$user = escape($user);
$query = "SELECT * FROM tb_member WHERE username = '$user'";
if ($result = mysqli_query($conn, $query)) {
if (mysqli_num_rows($result) != 0) return true;
else return false;
}
}
function cek_login($user, $pass)
{
global $conn;
$user = escape($user);
$pass = escape($pass);
$query = "SELECT password FROM tb_member WHERE username = '$user'";
$result = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($result)['password'];
// print_r($result);
if (password_verify($pass, $result)) {
return true;
} else {
return false;
}
}
function escape($data)
{
global $conn;
return mysqli_real_escape_string($conn, $data);
}
function redirec_login($user)
{
$_SESSION['user'] = $user;
header('Location:home?member=dashboard');
}
query untuk menampilkan data
$query = mysqli_query($conn, "SELECT * FROM tb_pinjaman AS a
LEFT JOIN tb_barang AS b ON a.id_barang=b.id_barang");
1 Jawaban:
Jawaban Terpilih
<div>Coba pada bagian </div><pre>function cek_login()</pre><div>tambahkan script seperti berikut</div><pre> function cek_login($user, $pass) { global $conn; $user = escape($user); $pass = escape($pass);
$query = "SELECT id_member, password FROM tb_member WHERE username = '$user'"; // tambahkan id_member
$result = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($result);
// print_r($result);
if (password_verify($pass, $result['password'])) {
<em>// Simpan id user di session untuk digunakan nanti</em> $_SESSION['id_member'] = $result['id_member']; return true; } else { return false; } } </pre><div>untuk query tampil data gunakan scrip berikut</div><pre> $query = mysqli_query($conn, "SELECT * FROM tb_pinjaman AS a LEFT JOIN tb_sarpases AS b ON a.id=b.id WHERE id_member='" . $_SESSION['id_member'] . "' "); </pre>