Advertisement
Bedhoel

Untitled

Feb 3rd, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.22 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $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
  4.             from tr_layanan_loket as lk
  5.             inner join  ms_layanan as ly
  6.                 on ly.id_layanan=lk.id_layanan
  7.             left outer join  ms_layanan_sub as ly_sb
  8.                 on ly_sb.id_layanan_sub = lk.id_layanan_sub
  9.             where lk.LOKET='".$_SESSION['loket']."'");
  10. if(!empty($get_layanan['nama_sub_layanan'])){
  11.     $layanan = (!empty($get_layanan['nama_sub_layanan']) ? $get_layanan['nama_sub_layanan'] : '');
  12.     $id_layanan = (!empty($get_layanan['id_layanan_sub']) ? $get_layanan['id_layanan_sub'] : '');
  13.     $suara = (!empty($get_layanan['suara_sb']) ? $get_layanan['suara_sb'] : '');
  14.     $durasi_total = (!empty($get_layanan['durasi_sb']) ? $get_layanan['durasi_sb'] : '0');
  15. }
  16. else {
  17.     $layanan = (!empty($get_layanan['nama_layanan']) ? $get_layanan['nama_layanan'] : '');
  18.     $id_layanan = (!empty($get_layanan['id_layanan']) ? $get_layanan['id_layanan'] : '');
  19.     $suara = (!empty($get_layanan['prefix_suara']) ? $get_layanan['prefix_suara'] : '');
  20.     $durasi_total = (!empty($get_layanan['durasi']) ? $get_layanan['durasi'] : '0');
  21. }  
  22. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement