Click here to Skip to main content
15,891,431 members
Search within:


Cant show and cant insert into database: akun kegiatan, nama kegiatan, surat tugas, laporan
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
PHP
MySQL
 
<?php
    if (isset($_POST[tambah])){
            $tglmulai = $_POST[tc]."-".$_POST[tb]."-".$_POST[ta];
            $tglselesai = $_POST[tf]."-".$_POST[te]."-".$_POST[td];
            mysql_query("INSERT INTO phpmu_kegiatan VALUES(
			'',
			'$_POST[a]',
			'$_POST[b]',
			'$_POST[c]',
            '$_POST[d]',
			'$_POST[e]',
			'$tglmulai',
			'$tglselesai',
			'$_POST[h]',
			'$_POST[i]',
			'$_POST[j]')");
        $id = mysql_insert_id();                             
                        echo "<script>document.location='index.php?view=kegiatan&act=edit&id=".$id."';</script>";
    }
?>
<form action='' class="form-horizontal" method="POST" data-validate="parsley" enctype='multipart/form-data'>
            <h4 style='padding-top:15px'>Tambah Data Kegiatan</h4>
            <!-- Basic Data Tables Example -->
            <div class="col-md-12">
            <div class="panel panel-default">
                <div class="panel-heading">
                     
                    <br>
                </div>
                <div class="panel-body">   
                            <div class="form-group">
                            <label class="col-lg-2 control-label">Nama</label>
                                <div class="col-lg-3">
                                <input type="text" name="a" placeholder="" class="bg-focus form-control">
                                </div>
                            </div>

                            <div class="form-group">
                            <label class="col-lg-2 control-label">Akun Kegiatan</label>
                                <div class="col-lg-3">
                                <select name="test">
									<option value="1">-</option>
									<option value="2">524111</option>
									<option value="3">524114</option>
									<option value="4">524119</option>
								</select>
                                </div>
                            </div>
							
							<div class="form-group">
                                <label class="col-lg-2 control-label">Nama Kegiatan</label>
                                <div class="col-lg-8">
                                <select name="test">
									<option value="1">-</option>
									<option value="2">AFA.001. 121.A. Pengembangan Panduan Integrasi Data</option>
									<option value="3">AFA.001. 121.B. Pengembangan Pedoman Pemanfaatan Data Pendataan Keluarga</option>
									<option value="4">FAE.001. 125.A. Monitoring Evaluasi Terpadu SIGA</option>
									<option value="5">FAE.001. 125.B. Perencanaan Program dan Kegiatan DITLAPTIK (KOREN, LAKIP, SPIP, RB, ZI/WBK)</option>
									<option value="6">FAE.001. 125.C. Administrasi Pengelolaan Anggaran</option>
									<option value="7">QMA.001. 283.A. Penyusunan Protokol Integrasi Data</option>
									<option value="8">QMA.001. 283.B. Penyusunan Meta Data dan Standarisasi Data Stunting</option>
									<option value="9">QMA.001. 283.C. Sarpras dan Operasional Layanan Pusat Pengendali Data</option>
									<option value="10">QMA.001. 283.D. Tenaga Ahli Data Scientist, Programmer dan Operator</option>
									<option value="11">QMA.001. 283.E. Rapat Koordinasi Data Stunting Lintas Sektor</option>
									<option value="12">QMA.001. 283.F. Need Assesment Data dan Indikator</option>
									<option value="13">QMA.001. 283.G. Pengembangan SOP Pemanfaatan Data Bersama</option>
									<option value="14">QMA.001. 299.A. Penyusunan Pedoman Verifikasi dan Validasi Data Kasus Stunting dan Keluarga Beresiko Stunting</option>
									<option value="15">QMA.001. 299.B. Sosialisasi Pedoman Verifikasi dan Validasi</option>
									<option value="16">UAB.001. 123.A. Penyusunan Laporan Statistik Program Bangga Kencana (Umpan Balik)</option>
									<option value="17">UAB.001. 123.B. Analisis dan Evaluasi Statistik Program Bangga Kencana ( BUlanan, Semesteran dan Tahunan)</option>
									<option value="18">UAB.001. 123.C. Pengembangan Validasi dan Output New SIGA</option>
									<option value="19">UAB.001. 123.D. PengembanganTools Penilaian Kualitas Data New SIGA</option>
									<option value="20">UAB.001. 123.E. Harmonisasi Data Lintas Sektor</option>
									<option value="21">UAB.001. 123.F. Workshop Rekonsiliasi Cakupan dan Kualitas Data New SIGA</option>
									<option value="22">UAB.001. 124.A. Peningkatan Strategi Advokasi, Penggerakan dan Promosi Program Bangga Kencana dan Percepatan Penurunan Stunting</option>
									<option value="23">UAB.001. 124.B. Forum Penguatan Satu Data Bangga Kencana</option>
									<option value="24">UAB.001. 124.C. Ekspose Data Bersama Mitra Kerja</option>
									<option value="25">UAB.001. 124.D. Evaluasi Sistem Pengelolaan Data Program KKBPK</option>
									<option value="26">UAB.001. 124.E. Penyusunan Rancangan Integrasi Data Melalui Dashboard</option>
									<option value="27">UBA.001. 122.A. Pengembangan dan Sosialisasi Panduan Pengolahan data PBDKI</option>
									<option value="28">UBA.001. 122.B. Regional Workshop Pemutakhiran Basis Data Keluarga Indonesia (PBDKI)</option>
									<option value="29">UBA.001. 122.C. Ujicoba PBDKI di Kampung KB Percontohan Tk. Kab/Kota</option>
									<option value="30">UBA.001. 122.D. Pengembangan dan Pengadaan panduan pengumpulan dan pengolahan data PBDKI</option>
									<option value="31">UBA.001. 122.E. Bimbingan Teknis dan Pengamatan Pelaksanaan PBDKI</option>
									<option value="32">UBA.001. 122.F. Pengadaan formulir PBDKI di 23 provinsi</option>
									<option value="33">UBA.001. 122.G. Pengembangan validasi , output dan analisis data PBDKI</option>
									<option value="34">UBA.001. 122.H. Pengadaan PBDKI KIT Wilayah Timur Bagi Kader Pendata</option>
									<option value="35">UBA.001. 122.I. Pengembangan Integrasi dan sosisalisasi sistem Aplikasi PK dengan Sistem Aplikasi lain</option>
									<option value="36">UBA.001. 122.J. Pengembangan dan Pengadaan panduan pengumpulan dan pengolahan data PBDKI (SelfBlocking)</option>
								</select>
                                </div>
                            </div>

                            <div class="form-group">
                            <label class="col-lg-2 control-label">Tujuan/Tempat Kegiatan</label>
                                <div class="col-lg-3">
                                <input type="text" name="c" placeholder="" class="bg-focus form-control">
                                </div>
                            </div>
							
							 <div class="form-group">
                                <label class="col-lg-2 control-label">Tanggal Berangkat</label>
                                <div class="col-lg-8">
                                
                                  <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=1; $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=2013; $n<=date("Y"); $n++){ 
                                        echo "<option value='$n'>$n</option>";
                                      } 
                                    ?>
                                  </select>
                                
                                </div>
                            </div>

                            <div class="form-group">
                                <label class="col-lg-2 control-label">Tanggal Kembali</label>
                                <div class="col-lg-8">
                                
                                  <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=2010; $n<=date("Y"); $n++){ 
                                        echo "<option value='$n'>$n</option>";
                                      } 
                                    ?>
                                  </select>
                                
                                </div>
                            </div>

                            <div class="form-group">
                            <label class="col-lg-2 control-label">Rupiah</label>
                                <div class="col-lg-2">
                                <input type="text" name="d" placeholder="" class="bg-focus form-control" data-required="true">
                                </div>
                            </div>

                            <div class="form-group">
                                <label class="col-lg-2 control-label">Lama</label>
                                <div class="col-lg-6">
                                <input type="text" name="h" placeholder="" data-required="true" class="bg-focus form-control">
                                </div>
                            </div>

                            <div class="form-group">
                                <label class="col-lg-2 control-label">Surat Tugas</label>
                                <div class="col-lg-9">
                                <form action="aksi.php" method="post" enctype="multipart/form-data">
									<input type="file" name="file">
									<input type="submit" name="upload" value="Upload">
								</form>
                                </div>
                            </div>
							
							<div class="form-group">
                                <label class="col-lg-2 control-label">Laporan</label>
                                <div class="col-lg-9">
                                <form action="aksion.php" method="post" enctype="multipart/form-data">
									<input type="file" name="file">
									<input type="submit" name="upload" value="Upload">
								</form>
                                </div>
                            </div>

                            <div class="form-group">
                            <div class="col-lg-10 pull-right">    
                            <button type="submit" name='tambah' class="btn btn-info">Simpan Data</button>                  
                            <button type="reset" class="btn btn-default">Reset</button>

                            </div>
                        </div>
                </div>
                    <br><br>
                </div>
            </div>

        <footer id="footer"> 
                <div class="text-center clearfix">
                    <p><small>© 2022 </small>
                        <br /><br /> 
                        <a href="" class="btn btn-xs btn-circle btn-twitter">class="fa fa-twitter"> 
                        <a href="" class="btn btn-xs btn-circle btn-facebook">^__i class="fa fa-facebook"></a> 
                        <a href="" class="btn btn-xs btn-circle btn-gplus">^__i class="fa fa-google-plus"></a> 
                    </p> 
                </div> 
        </footer>
</form>


What I have tried:

change select name in Akun Kegiatan and Nama Kegiatan but it didnt work. it didnt show in table and dont get into database
Posted
Updated 4-Apr-22 21:15pm
v2
Add a Solution
Comments
OriginalGriff 5-Apr-22 2:14am    
"It doesn't work" is probably the most useless problem report we get - and we get it a lot. It tells us nothing about what is happening, or when it happens.
So tell us what it is doing that you didn't expect, or not doing that you did.
Tell us what you did to get it to happen.
Tell us any error messages.
Use the "Improve question" widget to edit your question and provide better information.
Richard Deeming 5-Apr-22 3:43am    
Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation/interpolation to build a SQL query. ALWAYS use a parameterized query.

PHP: SQL Injection - Manual[^]
PHP: Prepared statements and stored procedures - Manual[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Cant connect to database
cant insert data to database
Cant add data to the database
Data inserted but cant see the data on mysql database localhost server using PHP
Cant Find Database when Install the application in other computer
cant show the output
I cant fix my mysql syntax
I cant delete data from fetch in react.
Cant insert data in MySQL using VB.NET
Cant connect to Sql Compact!

Advertise
Privacy
Cookies
Terms of Use
Last Updated 5 Apr 2022
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900