data04.php

<script src="assets/lib/datatables/jquery.dataTables.js"></script>
<link rel="stylesheet" href="assets/lib/datatables/jquery.dataTables.css">
<table id="permintaan" class="table table-hover table-stripped">
    <thead>
        <tr>
            <th>No</th>
            <th>Identitas</th>
            <th>Nama Kegiatan</th>
            <th>Kegiatan</th>
            <th>Banyak</th>
            <th>Tanggal</th>
            <th>Status</th>
        </tr>
    </thead>
     <?php
        $userSql = "SELECT * FROM tbl_permintaan INNER JOIN tbl_kegiatan ON id_kegiatan = id_k INNER JOIN tbl_souvenir ON id_souvenir = id_s INNER JOIN tbl_loker ON id_loker = pt_pengirim  WHERE id_us = '$_SESSION[id]' ORDER BY id_permintaan DESC";
        $userQry = mysql_query($userSql, $koneksidb)  or die ("Query user salah : ".mysql_error());
        $nomor  = 0;
        while ($userRow = mysql_fetch_array($userQry)) {
        $nomor++;
        $Kode = $userRow['id_permintaan'];
        $banyak = $userRow['banyak']+$userRow['bkedua']+$userRow['bketiga']+$userRow['bkeempat']+$userRow['bkelima'];
    ?>
    <tbody>
        <tr>
            <td><?php echo $nomor; ?></td>
            <td><small>Nama <b><?php echo $userRow['nama_pengirim']; ?></b>, dari <b><?php echo $userRow['nama_loker']; ?></b></small></td>
            <td><small><?php echo $userRow['nama_kegiatan']; ?></small></td>
            <td><small>Kegiatan <?php echo $userRow['nm_kegiatan']; ?></small></td>
            <td><small><?php echo $banyak; ?></small></td>
            <td><small><?php echo $userRow["tgl"];?></small></td>
            <td><small><?php
            if($userRow['stts']==1){
                echo '<span class="label label-info">Pending</span>';
            }elseif($userRow['stts']==2)
            {
                echo '<span class="label label-success">Diterima</span>';
            }elseif ($userRow['stts']==0) {
                echo '<span class="label label-danger">Ditolak</span>';
            }
            ?></small></td>
        </tr>
    </tbody>
    <?php
        }
    ?>
</table>
<script>
$(document).ready(function() {
    $('#permintaan').dataTable( {
        "pagingType": "full_numbers"
    } );
} );
</script>