Diskon 50% terbatas! Masukkan kupon "programmer2025" di kelas apa saja

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");
avatar arifrohman
@arifrohman

21 Kontribusi 4 Poin

Diperbarui 4 tahun yang lalu

1 Jawaban:

Jawaban Terpilih

<div>Coba pada bagian &nbsp;</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 = &quot;SELECT id_member, password FROM tb_member WHERE username = &#039;$user&#039;&quot;; // tambahkan id_member
$result = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($result);
// print_r($result);
if (password_verify($pass, $result[&#039;password&#039;])) {

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

avatar ariffqu
@ariffqu

8 Kontribusi 11 Poin

Dipost 4 tahun yang lalu

Login untuk ikut Jawaban