Postingan lainnya
cara menampilkan data pinjaman sesuai user yang login
disini saya ingin menampilkan data barang yang di pinjaman berdasarkan user yang login
berikut struktur tabel yang saya miliki
'tabel users'
id_users
nama_user
username
password
role
'tabel peminjaman'
id_peminjaman
id (berelasi ketabel barang)
users (berelasi ketabel users)
jumlah_pinjaman
tgl_pinjaman
// berikut untuk loginnya
function login_cek($user)
{
global $conn;
$user = escape($user);
$query = "SELECT * FROM users 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 users 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 redirec_login($user)
{
$_SESSION['user'] = $user;
header('Location:./?view=dashboard');
}
function cek_status($user)
{
global $conn;
$user = escape($user);
$query = "SELECT role FROM users WHERE username='$user'";
$result = mysqli_query($conn, $query);
$role = mysqli_fetch_assoc($result)['role'];
// die($role);
if ($role == 0) {
$_SESSION['user'] = $user;
$_SESSION['id_user'] = $role;
}
if ($role == 1) {
$_SESSION['user'] = $user;
$_SESSION['id_user'] = $role;
}
if ($role == 2) {
$_SESSION['user'] = $user;
$_SESSION['id_user'] = $role;
}
return $role;
// if ($role == 0) return true;
// return $role;
}
berikut untuk query menampilkan data pinjaman
$pinjaman = pinjaman("SELECT * FROM tb_pinjaman AS a
LEFT JOIN tb_sarpases AS b ON a.id=b.id");
2 Jawaban:
<div>jika ditable terdapat row user, <br>mungkin bisa di tambah where<br><br></div><pre>$pinjaman = pinjaman("SELECT * FROM tb_pinjaman AS a LEFT JOIN tb_sarpases AS b ON a.id=b.id WHERE user=$user");</pre>
<div>coba kek gini, kalo mau namipilin berikut data usernya tinggal join ke tabel user kalo kode di bawah cuma nampilin data berdasarkan id user aja<br>sebelumnya di login set session id_usernya dulu, yg gw liat itu lu set id user isiny role bukan id user harusnya di isi id user dari data user yg dicek, kalo role buat sesson baru aja<br><br><br></div><pre>$pinjaman = pinjaman("SELECT * FROM tb_pinjaman AS a LEFT JOIN tb_sarpases AS b ON a.id=b.id WHERE a.users = $_SESSION['id_user']");</pre><div><br></div>