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

Syntax untuk entry data mohon bantuan kendala dalam menyimpan data

Dibuat
Login Terakhir 5 Tahun lalu,
Telah Dilihat 948 Kali
Nian Dwi Christianto SW Mengatakan : Sultan Account
  1. Assalamualaikum Warahmatullahi Wabarakatuh...
  2.  
  3. <?php
  4. include'../koneksi.php';
  5. if (isset($_POST[tambah])){
  6. $noreg_simper = $_POST[ra]."-".$_POST[rb]."-".$_POST[rc]."-".$_POST[rd];
  7. $tgl_pengajuan = $_POST[ta]."-".$_POST[tb]."-".$_POST[tc];
  8. $masa_simper = $_POST[td]."-".$_POST[te]."-".$_POST[tf];
  9. mysql_query("INSERT INTO data_karyawan VALUES('$noreg_simper','$_POST[nik]','$_POST[nama]','$tgl_pengajuan', '$masasimper','$_POST[jabatan]','$_POST[departemen]')");
  10. $id = mysql_insert_id();
  11. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$id."';</script>";
  12. }
  13. ?>
  14. <?php
  15. $data = mysql_query("select * from data_karyawan order by nik DESC LIMIT 0,1");
  16. $i= mysql_fetch_array($data) ;
  17. // ID OTOMATIS//***************************************************
  18. $kodeawal=substr($i['nomor'],3,4);
  19. if($kodeawal<10){
  20. $kode='005'.$kodeawal;
  21. }elseif($kodeawal > 9 && $kodeawal <=99){
  22. $kode='1100'.$kodeawal;
  23. }else{
  24. $kode='11000'.$kodeawal;
  25. }
  26. ?>
  27.  
  28. <form action='' class="form-horizontal" method="POST" data-validate="parsley" enctype='multipart/form-data'>
  29. <h4 style='padding-top:15px'>Tambah Data Karyawan</h4>
  30. <!-- Basic Data Tables Example -->
  31. <div class="col-md-12">
  32. <div class="panel panel-default">
  33. <div class="panel-heading">
  34. <strong></strong>
  35. <br>
  36. </div>
  37. <div class="panel-body">
  38. <div class="form-group"><b>                     <i>No. Reg Simper :</i></b>
  39.  
  40. <input type="text" name="ra" value="<?php echo $kode ;?>" size="8" maxlength="4"/>
  41. <strong>/</strong><strong>
  42. <input type="text" name="rb" readonly value="BUMA-BMO" size="8" maxlength="8"/>
  43. /</strong>
  44. <input type="text" name="rc" size="4" value="<?php
  45. $array_bulan = array(1=>"I","II","III", "IV", "V","VI","VII","VIII","IX","X", "XI","XII");
  46. $bulan = $array_bulan[date('n')];
  47.  
  48. echo "$bulan";
  49. ?>"maxlength="4"/>
  50. <strong>/</strong>
  51. <input type="text" name="rd" value="<?php
  52. $tahun_sekarang = date('Y');
  53. $tahun = substr($tahun_sekarang, -2);
  54.  
  55. echo "$tahun";
  56. ?>"size="4" maxlength="2"/>
  57. </div>
  58.  
  59. </div>
  60.  
  61. <div class="form-group">
  62. <label class="col-lg-2 control-label">NIK : </label>
  63. <div class="col-lg-3">
  64. <input type="text" name="nik" placeholder="" class="bg-focus form-control" data-required="true"><span id="pesan"></span>
  65. </div>
  66. </div>
  67.  
  68. <div class="form-group">
  69. <label class="col-lg-2 control-label">Nama : </label>
  70. <div class="col-lg-3">
  71. <input type="text" name="nama" placeholder="" class="bg-focus form-control">
  72. </div>
  73. </div>
  74.  
  75. <div class="form-group">
  76. <div class="col-lg-2"></div>
  77. </div>
  78.  
  79. <div class="form-group">
  80. <div class="col-lg-8"></div>
  81. </div>
  82.  
  83. <div class="form-group">
  84. <label class="col-lg-2 control-label">Tanggal Pengajuan :</label>
  85. <div class="col-lg-8">
  86. <span class="combodate">
  87. <select name='ta' class="day form-control" style="width: auto;">
  88. <?php
  89. echo "<option value='".date("d")."' selected>".date("d")."</option>";
  90. for($n=1; $n<=31; $n++){
  91. echo "<option value='$n'>$n</option>";
  92. }
  93. ?>
  94. </select>  
  95. <select name='tb' class="month form-control" style="width: auto;"><option value=""></option>
  96. <?php
  97. $bln = array('','Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
  98. echo "<option value='".date("n")."' selected>".$bln[date("n")]."</option>";
  99. for($n=2; $n<=12; $n++){
  100. echo "<option value='$n'>$bln[$n]</option>";
  101. }
  102. ?>
  103. </select>  
  104. <select name='tc' class="year form-control" style="width: auto;">
  105. <?php
  106. echo "<option value='".date("Y")."' selected>".date("Y")."</option>";
  107. for($n=2015; $n<=date("Y"); $n++){
  108. echo "<option value='$n'>$n</option>";
  109. }
  110. ?>
  111. </select>
  112. </span>
  113. </div>
  114. </div>
  115.  
  116. <div class="form-group">
  117. <label class="col-lg-2 control-label">Masa Simper :</label>
  118.  
  119. <div class="col-lg-8">
  120. <span class="combodate">
  121. <select name='td' class="day form-control" style="width: auto;">
  122. <?php
  123. echo "<option value='".date("d")."' selected>".date("d")."</option>";
  124. for($n=1; $n<=31; $n++){
  125. echo "<option value='$n'>$n</option>";
  126. }
  127. ?>
  128. </select>  
  129. <select name='te' class="month form-control" style="width: auto;"><option value=""></option>
  130. <?php
  131. $bln = array('','Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
  132. echo "<option value='".date("n")."' selected>".$bln[date("n")]."</option>";
  133. for($n=1; $n<=12; $n++){
  134. echo "<option value='$n'>$bln[$n]</option>";
  135. }
  136. ?>
  137. </select>  
  138. <select name='tf' class="year form-control" style="width: auto;">
  139. <?php
  140. echo "<option value='".date("Y")."' selected>".date("Y")."</option>";
  141. for($n=2013; $n<=date("Y"); $n++){
  142. echo "<option value='$n'>$n</option>";
  143. }
  144. ?>
  145. </select>
  146. </span>
  147. </div>
  148.  
  149. <div class="form-group">
  150. <div class="col-lg-8"></div>
  151. </div>
  152.  
  153.  
  154. <div class="form-group">
  155. <label class="col-lg-2 control-label">Jabatan : </label>
  156. <div class="col-lg-5">
  157. <select class="form-control" name="jabatan" type="text" id="jabatan">
  158. <option value="">-SILAHKAN PILIH-</option>
  159. <?php
  160.  
  161. //mengambil nama-nama departemen yang ada di database
  162. $function= mysql_query("SELECT * FROM departemen ORDER BY position");
  163. while($p=mysql_fetch_array($function)){
  164. echo "<option value=\"$p[id]\">$p[position]</option>\n";
  165. }
  166. ?>
  167.  
  168. </select>
  169. </div>
  170. </div>
  171.  
  172. <div class="form-group">
  173. <label class="col-lg-2 control-label">Departemen : </label>
  174. <div class="col-lg-4">
  175. <select class="form-control" name="departemen" type="text" id="departemen">
  176. <option value="">-SILAHKAN PILIH-</option>
  177. <?php
  178.  
  179. //mengambil nama-nama departemen yang ada di database
  180. $function= mysql_query("SELECT * FROM function ORDER BY function");
  181. while($p=mysql_fetch_array($function)){
  182. echo "<option value=\"$p[id]\">$p[function]</option>\n";
  183. }
  184. ?>
  185.  
  186. </select>
  187. </div>
  188. </div>
  189.  
  190. <div class="form-group">
  191. <div class="col-lg-10 pull-right">
  192. <button type="submit" name='tambah' class="btn btn-info">Simpan Data</button>
  193. <button type="reset" class="btn btn-default">Reset</button>
  194.  
  195. </div>
  196. </div>
  197. </div>
  198. <br><br>
  199. </div>
  200. </div>
  201.  
  202. <footer id="footer">
  203. <div class="text-center clearfix">
  204. <p><small>&copy 2018 - Developed by IT Binsua </small>
  205. <br />
  206. <br />
  207. <a href="https://twitter.com/robbyprihandaya" class="btn btn-xs btn-circle btn-twitter"><i class="fa fa-twitter"></i></a>
  208. <a href="https://web.facebook.com/robbyprihandaya" class="btn btn-xs btn-circle btn-facebook"><i class="fa fa-facebook"></i></a>
  209. <a href="https://plus.google.com/106633506064864167239/posts" class="btn btn-xs btn-circle btn-gplus"><i class="fa fa-google-plus"></i></a>
  210. </p>
  211. </div>
  212. </footer>
  213. </form>
  214.  
  215. <?php
  216. if (isset($_POST[simpandasar])){
  217. mysql_query("INSERT INTO data_karyawan VALUES('$noreg_simper','$_POST[nik]','$_POST[nama]','tgl_pengajuan',
  218. '$masa_simper','$_POST[jabatan]','$_POST[departemen]')");
  219. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
  220. }
  221.  
  222. if (isset($_GET[deletedasar])){
  223. mysql_query("DELETE FROM phpmu_dasar where id_dasar='$_GET[deletedasar]'");
  224. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
  225. }
  226.  
  227. if (isset($_POST[simpanpelaksana])){
  228. mysql_query("INSERT INTO phpmu_pelaksana VALUES('','$_POST[a]','$_POST[id]','$_POST[b]')");
  229. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
  230. }
  231.  
  232. if (isset($_GET[deletepelaksana])){
  233. mysql_query("DELETE FROM phpmu_pelaksana where id_pelaksana='$_GET[deletepelaksana]'");
  234. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
  235. }
  236.  
  237. if (isset($_POST[simpanbiaya])){
  238. mysql_query("INSERT INTO phpmu_biaya VALUES('','$_POST[id]','$_POST[a]','$_POST[b]','$_POST[c]')");
  239. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
  240. }
  241.  
  242. if (isset($_GET[deletebiaya])){
  243. mysql_query("DELETE FROM phpmu_biaya where id_biaya='$_GET[deletebiaya]'");
  244. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
  245. }
  246.  
  247. if (isset($_POST[simpanpengikut])){
  248. mysql_query("INSERT INTO phpmu_pengikut VALUES('','$_POST[a]','$_POST[b]','$_POST[c]','$_POST[d]')");
  249. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_POST[id]."';</script>";
  250. }
  251.  
  252. if (isset($_GET[deletepengikut])){
  253. mysql_query("DELETE FROM phpmu_pengikut where id_pengikut='$_GET[deletepengikut]'");
  254. echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$_GET[id]."';</script>";
  255. }
  256. ?>
  257.  
  258. <div class="modal fade" id="tambahdasar" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  259. <div class="modal-dialog" role="document">
  260. <div class="modal-content">
  261. <div style='margin:0px; padding-top:0px' class="modal-header">
  262. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
  263. <h4 class="modal-title" id="myModalLabel">Tambahkan Data Dasar</h4>
  264. </div>
  265. <div class="modal-body">
  266. <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
  267. <div class="form-group">
  268. <label class="col-sm-3 control-label">Keterangan</label>
  269. <div class="col-sm-8">
  270. <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
  271. <textarea rows='10' class="form-control" name="a" required></textarea>
  272. </div>
  273. </div>
  274.  
  275. </div>
  276. <div style='clear:both' class="modal-footer">
  277. <button type="submit" name='simpandasar' class="btn btn-info btn-sm">Tambahkan</button>
  278. <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
  279. </div>
  280. </form>
  281. </div>
  282. </div>
  283. </div>
  284.  
  285. <div class="modal fade" id="tambahpelaksana" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  286. <div class="modal-dialog" role="document">
  287. <div class="modal-content">
  288. <div style='margin:0px; padding-top:0px' class="modal-header">
  289. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
  290. <h4 class="modal-title" id="myModalLabel">Tambahkan Data Pelaksana</h4>
  291. </div>
  292. <div class="modal-body">
  293. <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
  294.  
  295. <div class="form-group">
  296. <label class="col-sm-3 control-label">Pelaksana</label>
  297. <div class="col-sm-8">
  298. <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
  299. <select class="form-control" name="a">
  300. <option value='0'>- Pilih -</option>
  301. <?php
  302. $pelaksana = mysql_query("SELECT * FROM phpmu_karyawan ORDER BY nama_karyawan");
  303. while ($p = mysql_fetch_array($pelaksana)){
  304. echo "<option value='$p[id_karyawan]'> $p[nip_karyawan] - $p[nama_karyawan]</option>";
  305. }
  306. ?>
  307. </select>
  308. </div>
  309. </div>
  310.  
  311. <div class="form-group">
  312. <label class="col-sm-3 control-label">Keterangan</label>
  313. <div class="col-sm-8">
  314. <textarea rows='10' class="form-control" name="b" required></textarea>
  315. </div>
  316. </div>
  317.  
  318. </div>
  319. <div style='clear:both' class="modal-footer">
  320. <button type="submit" name='simpanpelaksana' class="btn btn-info btn-sm">Tambahkan</button>
  321. <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
  322. </div>
  323. </form>
  324. </div>
  325. </div>
  326. </div>
  327.  
  328. <div class="modal fade" id="tambahbiaya" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  329. <div class="modal-dialog" role="document">
  330. <div class="modal-content">
  331. <div style='margin:0px; padding-top:0px' class="modal-header">
  332. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
  333. <h4 class="modal-title" id="myModalLabel">Tambahkan Data Biaya</h4>
  334. </div>
  335. <div class="modal-body">
  336. <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
  337.  
  338. <div class="form-group">
  339. <label class="col-sm-3 control-label">Rincan Biaya</label>
  340. <div class="col-sm-8">
  341. <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
  342. <input type="text" class="form-control" name="a">
  343. </div>
  344. </div>
  345.  
  346. <div class="form-group">
  347. <label class="col-sm-3 control-label">Jumlah</label>
  348. <div class="col-sm-4">
  349. <input type="text" class="form-control" name="b">
  350. </div>
  351. </div>
  352.  
  353. <div class="form-group">
  354. <label class="col-sm-3 control-label">Keterangan</label>
  355. <div class="col-sm-8">
  356. <textarea rows='5' class="form-control" name="c" required></textarea>
  357. </div>
  358. </div>
  359.  
  360. </div>
  361. <div style='clear:both' class="modal-footer">
  362. <button type="submit" name='simpanbiaya' class="btn btn-info btn-sm">Tambahkan</button>
  363. <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
  364. </div>
  365. </form>
  366. </div>
  367. </div>
  368. </div>
  369.  
  370.  
  371. <div class="modal fade" id="tambahpengikut" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  372. <div class="modal-dialog" role="document">
  373. <div class="modal-content">
  374. <div style='margin:0px; padding-top:0px' class="modal-header">
  375. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
  376. <h4 class="modal-title" id="myModalLabel">Tambahkan Data Pengikut</h4>
  377. </div>
  378. <div class="modal-body">
  379. <form class="form-horizontal" action="index.php?view=kegiatan&act=edit&id=<?php echo $_GET[id]; ?>" method='POST'>
  380.  
  381. <div class="form-group">
  382. <label class="col-sm-3 control-label">Dari Karyawan</label>
  383. <div class="col-sm-8">
  384. <input type='hidden' value='<?php echo $_GET[id]; ?>' name='id'>
  385. <input type='hidden' id='bookId' name='a'>
  386. <select class="form-control" name="b">
  387. <option value='0'>- Pilih -</option>
  388. <?php
  389. $pelaksana = mysql_query("SELECT * FROM phpmu_karyawan ORDER BY nama_karyawan");
  390. while ($p = mysql_fetch_array($pelaksana)){
  391. echo "<option value='$p[id_karyawan]'> $p[nip_karyawan] - $p[nama_karyawan]</option>";
  392. }
  393. ?>
  394. </select>
  395. </div>
  396. </div>
  397.  
  398. <div class="form-group">
  399. <label class="col-sm-3 control-label">Nama Pengikut</label>
  400. <div class="col-sm-8">
  401. <input type="text" class="form-control" name="c" placeholder='Tulis Nama Pengikut, Jika Bukan dari Karyawan...'>
  402. </div>
  403. </div>
  404.  
  405. <div class="form-group">
  406. <label class="col-sm-3 control-label">Keterangan</label>
  407. <div class="col-sm-8">
  408. <textarea rows='5' class="form-control" name="d"></textarea>
  409. </div>
  410. </div>
  411.  
  412. </div>
  413. <div style='clear:both' class="modal-footer">
  414. <button type="submit" name='simpanpengikut' class="btn btn-info btn-sm">Tambahkan</button>
  415. <button type="button" data-dismiss="modal" aria-label="Close" class="btn btn-warning btn-sm"><span aria-hidden="true">Tutup</span></button>
  416. </div>
  417. </form>
  418. </div>
  419. </div>
  420. </div>
Ada 1 File Kiriman :
1. buma_tambah_data.JPG (46 KB)

Ada 3 Jawaban

Bukhori Muslim
commented on 08 Jul 2018 09:23:12
  1. Assalam,.. coba sekalian share table "data_karyawan" nya mas,..
  2. kita perlu lihat strukturnya juga.
Nian Dwi Christianto SW
commented on 08 Jul 2018 12:23:38
  1. Assalam,..
Terdapat 1 File dilampirkan :
1. struktur1.JPG (128 KB)
Nian Dwi Christianto SW
commented on 08 Jul 2018 12:24:11
  1. Assalam,..
  2. berikut sudah saya lampirkan gambarnya mas thanks.
Terdapat 1 File dilampirkan :
1. struktur2.JPG (30 KB)
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!