<?php //koneksi cukup iki ae

        $host = "localhost";
        $user = "root";
        $pass = "";
        $db   = "db_panco";
        $conn = mysqli_connect($host, $user, $pass, $db);

        if(mysqli_connect_errno()){
          echo "Database Not Connected".mysqli_connect_error();
        };
?>
<h3>Form Penilaian Petani</h3>
<form class="form-horizontal" action="hitung.php" method="POST" >
<table width="240" border="0">
  <tr>
      <td>Username</td>
      <td>:</td>
      <td><select name="username" style="width:146px">
      <option align="center">&#160&#160&#160&#160-- Pilih Nama --</option>
      <?php
        $sql = mysqli_query($conn, "SELECT * FROM tb_admin");
        while($row = mysqli_fetch_array($sql)){
      ?>
        <option value="<?php echo$row['nip']; ?>"><?php echo $row['username'];?></option>
      <?php  } ?>
    </select></td>
  </tr>
  <tr>
      <td>Industri</td>
      <td>:</td>
      <td><select name="industri" style="width:146px">
      <option align="center">&#160&#160&#160&#160-- Pilih Nama --</option>
      <?php
        $sql = mysqli_query($conn, "SELECT * FROM tb_industri");
        while($row = mysqli_fetch_array($sql)){
      ?>
        <option value="<?php echo$row['id']; ?>"><?php echo $row['nama_industri'];?></option>
      <?php  } ?>
    </select></td>
  </tr>
</table>
</form>