Skip to content

Instantly share code, notes, and snippets.

@imvkmark
Created August 15, 2013 09:25
Show Gist options
  • Save imvkmark/6239550 to your computer and use it in GitHub Desktop.
Save imvkmark/6239550 to your computer and use it in GitHub Desktop.
php:pdo-list tables
<?php
$db = new PDO('mysql:host=localhost;dbname=hdwiki', 'root', '');
$rs = $db->query("SHOW TABLES");
$all = $rs->fetchAll();
foreach($all as $item) {
echo ($item[0]) . "\n";
}
@ilhamdoanggg
Copy link

function ShowData($id_suratjalan){
$query="SELECT sppd_detail.id_suratjalan, karyawan.nama_karyawan, tbl_kota.kota, tbl_kota.ongkos, ".
"sppd_detail.description, sppd_detail.transportasi, sppd_detail.akomondasi, sppd_detail.uang_makan,".
" tbl_jabatan.uang_saku" .
"FROM sppd_detail " .
"INNER JOIN karyawan ON (sppd_detail.nik = karyawan.nik)" .
"INNER JOIN tbl_jabatan ON (karyawan.kode_jabatan = tbl_jabatan.kode_jabatan)" .
//"INNER JOIN tbl_kota ON (sppd_detail.kode_kota = tbl_kota.kode_kota) " .
"WHERE sppd_detail.id_suratjalan='{$id_suratjalan}'".
" GROUP BY karyawan.nik ORDER BY karyawan.nik";

    $statement = $this->connect->prepare($query); 
    $statement->execute();
    return $statement;
    }

but when i call with this
$statement = $sppd_detail->ShowData($sppd_detail->id_suratjalan);
while ($row = $statement->fetch(PDO::FETCH_ASSOC)){
extract($row);
echo "";
echo "" . $no . "";
echo "";
echo "" . $row['nama_karyawan'] . "";
echo "";

           }

table not showing
in phpMyadmin SQL sohw

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment