Mohon suhu cara untuk koneksikan ke database belum bisa

Dibuat 5 Tahun lalu | 2018-07-10 16:23:54 WIB,

Telah Dilihat 1220 Kali

Sultan Account

Nian Dwi Christianto SW Mengatakan : Sultan Account

Assalamualaikum Warahmatullahi Wabarakatuh...
berikut syntax dan gambar inputan data yang tertera di bawah ini : 
 
kegiatan_insert.php
 
<?php
include'../koneksi.php';
    if (isset($_POST['simpan'])){
            $noreg_simper = $_POST[ra]."-".$_POST[rb]."-".$_POST[rc]."-".$_POST[rd];
            $tgl_pengajuan = $_POST[ta]."-".$_POST[tb]."-".$_POST[tc];
			$masa_simper = $_POST[td]."-".$_POST[te]."-".$_POST[tf];
            mysql_query("INSERT INTO data_karyawan VALUES('$noreg_simper','$_POST[nik]','$_POST[nama]','$tgl_pengajuan',                        '$masasimper','$_POST[jabatan]','$_POST[departemen]')");
        $nik = mysql_insert_id();                             
                        echo "<script>document.location='index.php?view=kegiatan&act=edit&nik=".$nik."';</script>";
    }
?>
<?php
$data = mysql_query("select * from data_karyawan order by nik DESC LIMIT 0,1");
$i= mysql_fetch_array($data) ;
// ID OTOMATIS//***************************************************
$kodeawal=substr($i['nomor'],3,4);
if($kodeawal<10){
  $kode='005'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
  $kode='1100'.$kodeawal;
}else{
  $kode='11000'.$kodeawal;
}
 ?>
 
<form action='' class="form-horizontal" method="POST" data-validate="parsley" enctype='multipart/form-data'>
            <h4 style='padding-top:15px'>Tambah Data Karyawan</h4>
            <!-- Basic Data Tables Example -->
            <div class="col-md-12">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <strong></strong> 
                    <br>
                </div>
                <div class="panel-body">   
                  <div class="form-group"><b>                     <i>No. Reg Simper :</i></b> 
 
  <input type="text" name="ra" value="<?php echo $kode ;?>" size="8" maxlength="4"/> 
  <strong>/</strong><strong>
  <input type="text" name="rb" readonly value="BUMA-BMO" size="8" maxlength="8"/>
  /</strong>
  <input type="text" name="rc" size="4" value="<?php
    $array_bulan = array(1=>"I","II","III", "IV", "V","VI","VII","VIII","IX","X", "XI","XII");
    $bulan = $array_bulan[date('n')];
 
    echo  "$bulan";
?>"maxlength="4"/> 
  <strong>/</strong>
  <input type="text" name="rd" value="<?php
    $tahun_sekarang = date('Y');
    $tahun = substr($tahun_sekarang, -2);
 
    echo "$tahun";
?>"size="4" maxlength="2"/>
</div>
 
</div>
 
                            <div class="form-group">
                            <label class="col-lg-2 control-label">NIK : </label>
                                <div class="col-lg-3">
                                <input type="text" name="nik" placeholder="" class="bg-focus form-control" data-required="true"><span id="pesan"></span>
                                </div>
                            </div>
 
                            <div class="form-group">
                            <label class="col-lg-2 control-label">Nama : </label>
                                <div class="col-lg-3">
                                <input type="text" name="nama" placeholder="" class="bg-focus form-control">
                                </div>
                            </div>
 
                            <div class="form-group">
                              <div class="col-lg-2"></div>
                            </div>
 
                            <div class="form-group">
                              <div class="col-lg-8"></div>
                            </div>
 
                            <div class="form-group">
                                <label class="col-lg-2 control-label">Tanggal Pengajuan :</label>
                                <div class="col-lg-8">
                                <span class="combodate">
                                  <select name='ta' class="day form-control" style="width: auto;">
                                    <?php 
                                      echo "<option value='".date("d")."' selected>".date("d")."</option>";
                                      for($n=1; $n<=31; $n++){
                                        echo "<option value='$n'>$n</option>";
                                      }
                                    ?>
                                  </select>  
                                  <select name='tb' class="month form-control" style="width: auto;"><option value=""></option>
                                    <?php 
                                      $bln = array('','Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
                                      echo "<option value='".date("n")."' selected>".$bln[date("n")]."</option>";
                                      for($n=2; $n<=12; $n++){
                                        echo "<option value='$n'>$bln[$n]</option>";
                                      }
                                    ?>
                                  </select>  
                                  <select name='tc' class="year form-control" style="width: auto;">
                                    <?php
                                      echo "<option value='".date("Y")."' selected>".date("Y")."</option>";
                                      for($n=2015; $n<=date("Y"); $n++){ 
                                        echo "<option value='$n'>$n</option>";
                                      } 
                                    ?>
                                  </select>
                                </span>
                                </div>
                            </div>
 
                            <div class="form-group">
                                <label class="col-lg-2 control-label">Masa Simper :</label> 
 
                                <div class="col-lg-8">
                                <span class="combodate">
                                  <select name='td' class="day form-control" style="width: auto;">
                                    <?php 
                                      echo "<option value='".date("d")."' selected>".date("d")."</option>";
                                      for($n=1; $n<=31; $n++){
                                        echo "<option value='$n'>$n</option>";
                                      }
                                    ?>
                                  </select>  
                                  <select name='te' class="month form-control" style="width: auto;"><option value=""></option>
                                    <?php 
                                      $bln = array('','Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
                                      echo "<option value='".date("n")."' selected>".$bln[date("n")]."</option>";
                                      for($n=1; $n<=12; $n++){
                                        echo "<option value='$n'>$bln[$n]</option>";
                                      }
                                    ?>
                                  </select>  
                                  <select name='tf' class="year form-control" style="width: auto;">
                                    <?php
                                      echo "<option value='".date("Y")."' selected>".date("Y")."</option>";
                                      for($n=2013; $n<=date("Y"); $n++){ 
                                        echo "<option value='$n'>$n</option>";
                                      } 
                                    ?>
                                  </select>
                                </span>
                                </div>
 
 <div class="form-group">
   <div class="col-lg-8"></div>
</div>
 
 
<div class="form-group">
                                <label class="col-lg-2 control-label">Jabatan : </label>
                                <div class="col-lg-5">
                               <select class="form-control" name="jabatan" type="text" id="jabatan">
<option value="">-SILAHKAN PILIH-</option>
<?php
 
//mengambil nama-nama departemen yang ada di database
$function= mysql_query("SELECT * FROM departemen ORDER BY position");
while($p=mysql_fetch_array($function)){
echo "<option value=\"$p[id]\">$p[position]</option>\n";
}
?>
 
</select>
                                </div>
</div>
 
                            <div class="form-group">
                                <p>
                                  <label class="col-lg-2 control-label">Departemen : </label>
<div class="col-lg-5">
                                  <select class="form-control" name="departemen" type="text" id="departemen">
                                    <option value="">-SILAHKAN PILIH-</option>
                                    <?php
 
//mengambil nama-nama departemen yang ada di database
$function= mysql_query("SELECT * FROM function ORDER BY function");
while($p=mysql_fetch_array($function)){
echo "<option value=\"$p[id]\">$p[function]</option>\n";
}
?>
</select>
</div>
</p>
</div>
</select>
                                  <div class="form-group">
                                </p>
<p>
                                  <label class="col-lg-2 control-label">Foto KTP : </label>
</p>
<div class="col-lg-5"><form action="upload_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" size="50" />
<br />
<input type="submit" value="Upload" />
 </form>
 
</p>   
</div>                                 
                                  </select>                             
                                  <div class="form-group">
                                </p>
<p>
</p>
</div>
                                  <label class="col-lg-2 control-label">Upload Simper 2 : </label>
</p>
<div class="col-lg-5"><form action="upload_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" size="50" />
<br />
<input type="submit" value="Upload" />
</form>
 
</p>   
</div>                                 
                                  </select>
                                  <div class="form-group">
                                </p>
                                </div>
 
                                <label class="col-lg-2 control-label">Upload Simper 3 : </label>
<div class="col-lg-5"><form action="upload_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" size="50" />
<br />
<input type="submit" value="Upload" />
</form>
 
</p>   
</div>                                 
                                  </select>
                                  <div class="form-group">
                                </p>
                                </div>
                                <label class="col-lg-2 control-label">Upload Simper 4 : </label>
<div class="col-lg-5"><form action="upload_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" size="50" />
<br />
<input type="submit" value="Upload" />
</form>
 
</p>   
</div>                                 
                                  </select>
                                  <div class="form-group">
                                </p>
   </div>
                                  <label class="col-lg-2 control-label">Upload Simper 5 : </label>
</p>
<div class="col-lg-5"><form action="upload_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" size="50" />
<br />
<input type="submit" value="Upload" />
</form>
 
 
                    <br><br>
                </div>
</p>   
</div>                                 
 
        <div class="form-group">
  <div class="col-lg-10 pull-right">    
                            <button type="submit" name='simpan' class="btn btn-info">Simpan Data</button>                  
                            <button type="reset" class="btn btn-default">Reset</button>
 
  </div>
</div>                          
</div>
 
        <footer id="footer"> 
                <div class="text-center clearfix">
                    <p><small>&copy 2018 - Developed by IT Binsua </small>
                        <br />
          </div> 
        </footer>
 
        <p>
</p>
</div>
 
                </div>
</form>
 
    <?php 
        if (isset($_POST['simpan'])){
            mysql_query("INSERT INTO data_karyawan VALUES('$noreg_simper','$_POST[nik]','$_POST[nama]','tgl_pengajuan',
                                '$masa_simper','$_POST[jabatan]','$_POST[departemen]')");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&nik=".$_POST['nik']."';</script>";
        }
 
        if (isset($_GET[deletedasar])){
            mysql_query("DELETE FROM phpmu_dasar where id_dasar='$_GET[deletedasar]'");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
        }
 
        if (isset($_POST[simpanpelaksana])){
            mysql_query("INSERT INTO phpmu_pelaksana VALUES('','$_POST[a]','$_POST[id]','$_POST[b]')");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
        }
 
        if (isset($_GET[deletepelaksana])){
            mysql_query("DELETE FROM phpmu_pelaksana where id_pelaksana='$_GET[deletepelaksana]'");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
        }
 
        if (isset($_POST[simpan])){
            mysql_query("INSERT INTO phpmu_biaya VALUES('','$_POST[id]','$_POST[a]','$_POST[b]','$_POST[c]')");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
        }
 
        if (isset($_GET[deletebiaya])){
            mysql_query("DELETE FROM phpmu_biaya where id_biaya='$_GET[deletebiaya]'");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
        }
 
        if (isset($_POST[simpanpengikut])){
            mysql_query("INSERT INTO phpmu_pengikut VALUES('','$_POST[a]','$_POST[b]','$_POST[c]','$_POST[d]')");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
        }
 
        if (isset($_GET[deletepengikut])){
            mysql_query("DELETE FROM phpmu_pengikut where id_pengikut='$_GET[deletepengikut]'");
            echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
        }
    ?>
 
<div class="modal fade" id="tambahdasar" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div style='margin:0px; padding-top:0px' class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="myModalLabel">Tambahkan Data Dasar</h4>
          </div>
          <div class="modal-body">
              <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
                <div class="form-group">
                  <label class="col-sm-3 control-label">Keterangan</label>
                  <div class="col-sm-8">
                    <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
                    <textarea rows='10' class="form-control" name="a" required></textarea>
                  </div>
                </div>
 
          </div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpandasar' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>
 
<div class="modal fade" id="tambahpelaksana" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div style='margin:0px; padding-top:0px' class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="myModalLabel">Tambahkan Data Pelaksana</h4>
          </div>
          <div class="modal-body">
              <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Pelaksana</label>
                  <div class="col-sm-8">
                    <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
                    <select class="form-control" name="a">
                        <option value='0'>- Pilih -</option>
                        <?php 
                            $pelaksana = mysql_query("SELECT * FROM phpmu_karyawan ORDER BY nama_karyawan");
                            while ($p = mysql_fetch_array($pelaksana)){
                                echo "<option value='$p[id_karyawan]'> $p[nip_karyawan] - $p[nama_karyawan]</option>";
                            }
                        ?>
                    </select>
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Keterangan</label>
                  <div class="col-sm-8">
                    <textarea rows='10' class="form-control" name="b" required></textarea>
                  </div>
                </div>
 
          </div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpanpelaksana' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>
 
<div class="modal fade" id="tambahbiaya" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div style='margin:0px; padding-top:0px' class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="myModalLabel">Tambahkan Data Biaya</h4>
          </div>
          <div class="modal-body">
              <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Rincan Biaya</label>
                  <div class="col-sm-8">
                    <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
                    <input type="text" class="form-control" name="a">
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Jumlah</label>
                  <div class="col-sm-4">
                    <input type="text" class="form-control" name="b">
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Keterangan</label>
                  <div class="col-sm-8">
                    <textarea rows='5' class="form-control" name="c" required></textarea>
                  </div>
                </div>
 
          </div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpanbiaya' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>
 
 
<div class="modal fade" id="tambahpengikut" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div style='margin:0px; padding-top:0px' class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="myModalLabel">Tambahkan Data Pengikut</h4>
          </div>
          <div class="modal-body">
              <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Dari Karyawan</label>
                  <div class="col-sm-8">
                    <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
                    <input type='hidden' id='bookId' name='a'>
                    <select class="form-control" name="b">
                        <option value='0'>- Pilih -</option>
                        <?php 
                            $pelaksana = mysql_query("SELECT * FROM phpmu_karyawan ORDER BY nama_karyawan");
                            while ($p = mysql_fetch_array($pelaksana)){
                                echo "<option value='$p[id_karyawan]'> $p[nip_karyawan] - $p[nama_karyawan]</option>";
                            }
                        ?>
                    </select>
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Nama Pengikut</label>
                  <div class="col-sm-8">
                    <input type="text" class="form-control" name="c" placeholder='Tulis Nama Pengikut, Jika Bukan dari Karyawan...'>
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Keterangan</label>
                  <div class="col-sm-8">
                    <textarea rows='5' class="form-control" name="d"></textarea>
                  </div>
                </div>
 
          </div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpanpengikut' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>

Ada 1 File Kiriman :

1. gambar_form_input.JPG (39 KB)

Ada 6 Jawaban

Nian Dwi Christianto SW commented on 10 Jul 2018 16:38:02 Sultan Account

	Assalam,.. Ini sambungan gambar untuk menyesuaikan dengan database. Terdapat 1 File dilampirkan : 1. database_mysql.JPG (134 KB)

PHPMU.COM Support
commented on 11 Jul 2018 06:12:22 Sultan Account

Assalam,.. itu masalahnya bukan koneksi ke database mas,..
tapi query insertnya salah, jika menggunakan query insert seperti ini :
mysql_query("INSERT INTO data_karyawan VALUES('$noreg_simper','$_POST[nik]','$_POST[nama]','$tgl_pengajuan',                        '$masasimper','$_POST[jabatan]','$_POST[departemen]')");
 
maka jumlah values harus sama dengan jumlah kolom/field di database table data_karyawan, 
jika tidak maka data tidak akan bisa masuk ke table data karyawan..
harusnya jumlahnya gini :
mysql_query("INSERT INTO data_karyawan VALUES('$noreg_simper','$_POST[nik]','$_POST[nama]','$tgl_pengajuan','$masasimper','0000-00-00','$_POST[jabatan]','$_POST[departemen]','','','','','')");

Nian Dwi Christianto SW commented on 11 Jul 2018 06:41:55 Sultan Account

	Assalam,.. Sudah di coba namun tampilan tahun, jabatan, dan departemen masih salah. Mohon bantuan mas robby Terdapat 1 File dilampirkan : 1. hasil_dari_inputan_data.JPG (34 KB)

PHPMU.COM Support
commented on 11 Jul 2018 07:31:46 Sultan Account

Assalam,.. berarti insert data sudah berhasil..
pertanyaan di atas sudah terjawab ya mas, sekarang pertanyaan barunya :
tahun, jabatan, dan departemen masih salah?
 
sebenarnya tidak salah, harusnya data yang masuk memang id_departemen dan id_jabatan
jadi ada relasi antar table data karyawan, departemen dan jabatan seharusnya.
pahami dulu normalisasi database, modulnya ada kita share, cari disini : https://members.phpmu.com/files
 
tapi jika memang mau insert text/nama jabatan dan departemen langsung ke data_karyawan
bisa ubah script berikut pada inputan/combobox departemen dan jabatan dari :
echo "<option value=\"$p[id]\">$p[position]</option>\n";
echo "<option value=\"$p[id]\">$p[function]</option>\n";
 
menjadi seperti ini :
echo "<option value=\"$p[position]\">$p[position]</option>\n";
echo "<option value=\"$p[function]\">$p[function]</option>\n";

Nian Dwi Christianto SW
commented on 12 Jul 2018 06:55:55 Sultan Account

Assalam,.. 
 
Tombol simpan data masih kendala mas Robby, 
bisa tolong bantu ya? 
 
</div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpanpelaksana' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>
 
<div class="modal fade" id="tambahbiaya" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div style='margin:0px; padding-top:0px' class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="myModalLabel">Tambahkan Data Biaya</h4>
          </div>
          <div class="modal-body">
              <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Rincan Biaya</label>
                  <div class="col-sm-8">
                    <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
                    <input type="text" class="form-control" name="a">
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Jumlah</label>
                  <div class="col-sm-4">
                    <input type="text" class="form-control" name="b">
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Keterangan</label>
                  <div class="col-sm-8">
                    <textarea rows='5' class="form-control" name="c" required></textarea>
                  </div>
                </div>
 
          </div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpanbiaya' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>
 
 
<div class="modal fade" id="tambahpengikut" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div style='margin:0px; padding-top:0px' class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="myModalLabel">Tambahkan Data Pengikut</h4>
          </div>
          <div class="modal-body">
              <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Dari Karyawan</label>
                  <div class="col-sm-8">
                    <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
                    <input type='hidden' id='bookId' name='a'>
                    <select class="form-control" name="b">
                        <option value='0'>- Pilih -</option>
                        <?php 
                            $pelaksana = mysql_query("SELECT * FROM phpmu_karyawan ORDER BY nama_karyawan");
                            while ($p = mysql_fetch_array($pelaksana)){
                                echo "<option value='$p[id_karyawan]'> $p[nip_karyawan] - $p[nama_karyawan]</option>";
                            }
                        ?>
                    </select>
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Nama Pengikut</label>
                  <div class="col-sm-8">
                    <input type="text" class="form-control" name="c" placeholder='Tulis Nama Pengikut, Jika Bukan dari Karyawan...'>
                  </div>
                </div>
 
                <div class="form-group">
                  <label class="col-sm-3 control-label">Keterangan</label>
                  <div class="col-sm-8">
                    <textarea rows='5' class="form-control" name="d"></textarea>
                  </div>
                </div>
 
          </div>
          <div style='clear:both' class="modal-footer">
            <button type="submit" name='simpanpengikut' class="btn btn-info btn-sm">Tambahkan</button>
            <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
          </div>
          </form>
        </div>
      </div>
</div>

Terdapat 1 File dilampirkan :

1. tombol_simpan_data.JPG (24 KB)

Bukhori Muslim commented on 13 Jul 2018 09:36:37 Sultan Account

	Assalam,.. Tombol simpan data kendala/masalahnya bagaimana mas?

Maaf, Untuk Memberikan Komentar Anda Harus Login !!!

	BSI - Bank Syariah Indonesia (451)

	ROBBY PRIHANDAYA
	1043-5665-19


	Bank Muamalat (147)
	ROBBY PRIHANDAYA
	4220-0174-81

Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67504 Members, 783 Products, 5291 Topic, 12956 Comments)

Mohon suhu cara untuk koneksikan ke database belum bisa

Ada 6 Jawaban

Projects Remote

Hot Questions

Tentang Kami

Jam Layanan

Knowledgebase