fetch.php

<?php
include "../../config/koneksi.php";
include "../../function/function.php";

$query="select*from beli";
$statement=$dbh->prepare($query);
$statement->execute();
$result=$statement->fetchAll();
$total_row=$statement->rowCount();
$output = '
    <table class="table table-striped table-bordered">
        <tr>
            <th>Kode Transaksi</th>
            <th>Tanggal</th>
            <th>Nama Supplier</th>
            <th>Keterangan</th>
            <th>Total</th>
            <th>Bayar</th>
            <th>Edit</th>
            <th>Delete</th>
        </tr>
';
if($total_row>0){
    foreach($result as $row){
        $carinama="select*from supplier where idsupp='".$row['idsupp']."'";
        $nama=$dbh->prepare($carinama);
        $nama->execute();
        $tampil=$nama->fetchAll();
        foreach($tampil as $hasil){
            $namasupp=$hasil['namasupp'];
        }
        $output .= '
            <tr>
                <td width="40%">'.$row["kdtransaksi"].'</td>
                <td width="40%">'.tanggalIndo($row["tanggal"]).'</td>
                <td width="40%">'.$namasupp.'</td>
                <td width="40%">'.$row["keterangan"]." dari ".$namasupp.'</td>
                <td width="40%">'.$row["total"].'</td>
                <td width="40%">'.$row["bayar"].'</td>
                <td width="10%"><button type="button" name="edit" class="btn btn-primary btn-xs edit" id="'.$row["idbeli"].'">Edit</button></td>
                <td width="10%"><button type="button" name="delete" class="btn btn-danger btn-xs delete" id="'.$row["idbeli"].'">Delete</button></td>
            </tr>
        ';
    }
}else{
    $output.='
        <tr>
            <td colspan="8" align="center">Data tidak ditemukan</td>
        </tr>
    ';
}
$output.='</table>';
echo $output;
?>