Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $get_layanan = $db->getRow("select ly.nama_layanan,ly.id_layanan,ly.prefix_suara,ly_sb.nama_sub_layanan,ly_sb.id_layanan_sub,ly_sb.prefix_suara as suara_sb,ly_sb.durasi as durasi_sb,ly.durasi as durasi_ly
- from tr_layanan_loket as lk
- inner join ms_layanan as ly
- on ly.id_layanan=lk.id_layanan
- left outer join ms_layanan_sub as ly_sb
- on ly_sb.id_layanan_sub = lk.id_layanan_sub
- where lk.LOKET='".$_SESSION['loket']."'");
- if(!empty($get_layanan['nama_sub_layanan'])){
- $layanan = (!empty($get_layanan['nama_sub_layanan']) ? $get_layanan['nama_sub_layanan'] : '');
- $id_layanan = (!empty($get_layanan['id_layanan_sub']) ? $get_layanan['id_layanan_sub'] : '');
- $suara = (!empty($get_layanan['suara_sb']) ? $get_layanan['suara_sb'] : '');
- $durasi_total = (!empty($get_layanan['durasi_sb']) ? $get_layanan['durasi_sb'] : '0');
- }
- else {
- $layanan = (!empty($get_layanan['nama_layanan']) ? $get_layanan['nama_layanan'] : '');
- $id_layanan = (!empty($get_layanan['id_layanan']) ? $get_layanan['id_layanan'] : '');
- $suara = (!empty($get_layanan['prefix_suara']) ? $get_layanan['prefix_suara'] : '');
- $durasi_total = (!empty($get_layanan['durasi']) ? $get_layanan['durasi'] : '0');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement