Advertisement
rizkyhap

Untitled

Sep 15th, 2017
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.69 KB | None | 0 0
  1. <?php
  2.    $server = "localhost";
  3.    $user = "root";
  4.    $pass = "";
  5.    $db = "login";
  6.  
  7.    $database = new mysqli($server, $user, $pass, $db);
  8.    /*********************************************************/
  9.    
  10.    $option = '<option value=""> - Data leased Line - </option>';
  11.    
  12.    $jk = isset($_GET['jk']) ?  $_GET['jk'] :'';
  13.    $sql = "SELECT id_sm,id_pekerjaan,nm_sm,nm_pekerjaan FROM `tswisma` INNER join pekerjaan on tswisma.id_sm=pekerjaan.id_sm where id_sm='".$jk."'";
  14.    if($res = $database->query($sql)) {
  15.       while ($row = $res->fetch_assoc()) {
  16.          $option .= "<option value='".$row['id_pekerjaan']."'>".$row['nm_pekerjaan']."</option>";
  17.       }
  18.    }
  19.    echo $option;
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement