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 1 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 1 tahun yang lalu

Login untuk ikut Jawaban