list_penggajian.php

<div class="col-md-12">
                    <div class="card">
                        <div class="card-header">
                            <strong class="card-title">Tambah penggajian</strong>
                        </div>
                    <div class="card-body">
                    <a class="btn btn-primary" href="?target=penggajian&action=form"> Tambah</a>
                    <br>
                    <br>
                  <table id="bootstrap-data-table" class="table table-striped table-bordered">
                    <thead>
                      <tr>
                        <th>No</th>
                        <th>nip</th>
                         <th>nm_pegawai</th>
                         <th>jabatan</th>
                        <th>gaji_pokok</th>

                           <th>aksi</th>
                      </tr>
                    </thead>
                    <tbody>
<?php
                    $uri = $_SERVER['REQUEST_URI'];
                    $uri = explode("/", $uri);
                    include "$_SERVER[DOCUMENT_ROOT]/$uri[1]/conf/connection.php";
// include "conf/connection.php";
$q = $db->query("SELECT * FROM tb_penggajian       LEFT JOIN tb_pegawai ON tb_penggajian.id_pegawai=tb_pegawai.id_pegawai
                                                   LEFT JOIN tb_jabatan ON tb_penggajian.id_jabatan=tb_jabatan.id_jabatan");

$no = 1;
while($r = $q->fetch_array()){
  $id_penggajian = $r['id_penggajian'];


   ?>
                      <tr>
                        <td><?php echo $no; ?></td>
                         <td><?php echo $r['nip']; ?></td>
                        <td><?php echo $r['nm_pegawai']; ?></td>
                        <td><?php echo $r['jabatan']; ?></td>

                       <td>
                                <?php echo "Rp. " . number_format($r['gaji_pokok'],0,',','.'); ?>
                            </td >


                        <td>

                          <a class="btn btn-success" href="admin.php?target=penggajian&action=edit&id=<?php echo $id_penggajian; ?>" ><i class='fa fa-edit'></i></a>
                          <a class="btn btn-danger" href="admin.php?target=penggajian&action=delete&id=<?php echo $id_penggajian; ?>"><i class='fa fa-trash'></i></a>
                        </td>
                      </tr>
            <?php
            $no++;
            }
           ?>
                    </tbody>
                  </table>
                        </div>
                    </div>
                </div>