SURAT MASUK

<?php $koneksi = new mysqli ("localhost","root","","kominfo") ?>
<h2 class="text-center"> <b> DATA SURAT MASUK</b></h2>
<div class="row">
        <div class="col-xs-12">
          <div class="box">

          <div class="box">
            <div class="box-header">

            </div>
            <!-- /.box-header -->
            <div class="box-body no-padding">
              <table class="table table-condensed">
            <thead>
            <tr>
               <center> <th> No Agenda </th>
                <th> Nomor Surat </th>
                <th> Asal Surat </th>
                <th> Isi Surat </th>
                <th> Tanggal Surat </th>
                <th> Tempat Pelaksanaan </th>
                <th> Tanggal Pelaksanaan </th>
                <th> Keterangan </th>
                <th> Tindakan </th></center>
            </tr>
        </thead>
        <tbody>
         <?php $ambil = $koneksi->query(" SELECT * FROM tbl_surat_masuk");?>
         <?php while ($tampil = $ambil->fetch_assoc()) {?>
            <tr>
                <td><?php echo $tampil['no_agenda'] ?></td>
                <td><?php echo $tampil['no_surat'] ?></td>
                <td><?php echo $tampil['asal_surat'] ?></td>
                <td><?php echo $tampil['isi'] ?></td>
                <td><?php echo $tampil['tujuan'] ?></td>
                <td><?php echo $tampil ['tgl_surat'] ?></td>
                <td><?php echo $tampil ['tgl_terima'] ?></td>
                <td><?php echo $tampil['keterangan'] ?></td>


                <td>
                    <a href="" class="btn btn-info"> Ubah </a>
                    <a href="" onclick="return confirm ('Apakah Anda Yakin InginMenghapus Ini ??')" class='btn btn-danger'> Hapus</a>
                    <a href="" class="btn btn-info"> Cetak </a>
                </td>
            </tr>
        </tbody>
    <?php }?>
 </table>
 <br>
 <br>
<center> <a href="index.php?halaman=tambah_suratmasuk" class="btn btn-primary"> <b> [+] TAMBAH DATA</b> </a></center>





(TAMBAH DATA BARU  )
<?php
 $koneksi = new mysqli ("localhost","root","","kominfo") ?>
<h2 class="text-center"> <b> TAMBAH DATA SURAT MASUK</b></h2>
<form   action=""   method="POST" enctype="multipart/form-data"></form>

             <div class="tab-pane" id="settings">
                <form class="form-horizontal">

                  <div class="form-group">
                    <label for="no_agenda" class="col-sm-2 control-label">No Agenda</label>
                    <div class="col-sm-10">
                      <input type="number" class="form-control" name="no_agenda" >
                    </div>
                  </div>

                  <div class="form-group">
                    <label for="no_surat" class="col-sm-2 control-label">No Surat</label>
                    <div class="col-sm-10">
                      <input type="text" class="form-control" name="no_surat" >
                    </div>
                  </div>

                  <div class="form-group">
                    <label for="asal_surat" class="col-sm-2 control-label">Asal Surat</label>
                    <div class="col-sm-10">
                      <input type="text" class="form-control" name="asal_surat" >
                    </div>
                  </div>

                  <div class="form-group">
                    <label for="isi" class="col-sm-2 control-label">Isi Surat</label>
                    <div class="col-sm-10">
                      <textarea type="text" class="form-control" name="isi" ></textarea>
                    </div>
                  </div>

                  <div class="form-group">
                    <label for="tujuan" class="col-sm-2 control-label">Tempat Pelaksanaan</label>
                    <div class="col-sm-10">
                      <textarea  type="text" class="form-control" name="tujuan" ></textarea>
                    </div>
                  </div>

                  <div class="form-group">
                    <label for="tgl_surat" class="col-sm-2 control-label">Tanggal Surat</label>
                    <div class="col-sm-10">
                      <input type="date" class="form-control" name="tgl_surat" >
                    </div>
                  </div>

                  <div class="form-group">
                    <label for="tgl_terima" class="col-sm-2 control-label">Tanggal Pelaksanaan</label>
                    <div class="col-sm-10">
                      <input type="date" class="form-control" name="tgl_terima" >
                    </div>
                  </div>

                    <div class="form-group">
                    <label for="keterangan" class="col-sm-2 control-label"> Keterangan</label>

                    <div class="col-sm-10">
                      <textarea class="form-control" name="keterangan" ></textarea>
                    </div>
                     <br>
                    <br>
                    <br>

                  <div class="form-group">
                    <div class="col-sm-offset-2 col-sm-10">
                     <center> <button   class="btn btn-primary" name="simpan">Simpan</button>
                    <a href="index.php?halaman_suratmasuk" class="btn btn-warning"> Kembali </a></center>
                    </div>
                  </div>
              </div>
                </form>
<?php


if(isset($_POST['simpan'])){
   $no_agenda = $_POST['no_agenda'];
  $no_surat = $_POST['no_surat'];
  $asal_surat = $_POST['asal_surat'];
  $isi = $_POST['isi'];
  $tujuan= $_POST['tujuan'];
  $tgl_surat = $_POST['tgl_surat'];
  $tgl_terima = $_POST['tgl_terima'];
  $keterangan = $_POST['keterangan'];
   $id_user = $_POST['id_user'];

 $simpan-> query("INSERT INTO tbl_surat_masuk (no_agenda,no_surat,asal_surat,isi,tujuan,tgl_surat,tgl_terima,keterangan)
    values ('','$no_agenda','$no_surat','$asal_surat','$isi','$tujuan','$tgl_surat','$tgl_terima','$keterangan)");
    if($simpan){ //jika simpan berhasil maka muncul pesan dan menuju ke halaman produk
        echo "<script>alert('Data Produk Berhasil disimpan ke database');document.location='index.php?suratmasuk.php'</script>";
    }else{  //jika simpan gagal maka muncul pesan
       }
}?>