Postingan lainnya
simpan input data ke database.
mau nanya gan, kira2 dari kodingan punya saya ini dimana salahnya yah, kok ngga bisa nyimpan ke database? sedangkan kalo diinputkan dari database, data bisa muncul ke form?
<?php
//cek dahulu, jika tombol tambah di klik
if(isset($_POST['tambah'])){
include('koneksi.php');
//jika tombol tambah benar di klik maka lanjut prosesnya
$id_proyek = $data['id_proyek'];
$kode = $data['kode'];
$id_divisi = $data['id_divisi'];
$id_witel = $data['id_witel'];
$nama_pj = $data['nama_pj'];
$nama_proyek = $data['nama_proyek'];
$lokasi = $data['lokasi'];
$garis_bujur = $data['garis_bujur'];
$garis_lintang = $data['garis_lintang'];
$id_order1 = $data['id_order1'];
$id_type1 = $data['id_type1'];
$result = $data['result'];
$mulai_proyek = $data['mulai_proyek'];
$target_proyek = $data['target_proyek'];
$mitra = $data['mitra'];
$jumlah_team = $data['jumlah_team'];
$survey = $data['survey'];
$instalasi_ffth = $data['instalasi_ftth'];
$id_kemajuan = $data['id_kemajuan'];
$ct_ut = $data['ct_ut'];
$rekon = $data['rekon'];
$persentasi = $data['persentasi'];
$kendala = $data['kendala'];
$keterangan = $data['keterangan'];
// Upload
$gambar_proyek = $_FILES['gambar_proyek']['name'];
$extension = strtolower(substr($gambar_proyek, strpos($gambar_proyek, '.') + 1));
$type = $_FILES['gambar_proyek']['type'];
$size = $_FILES['gambar_proyek']['size'];
$max_size = 2097152;
$tmp_name = $_FILES['gambar_proyek']['tmp_name'];
// Akhir Upload Foto
//melakukan query dengan perintah INSERT INTO untuk memasukkan data ke database
if($kode=='')
echo "kode kosong";
else
{
$cek = mysql_num_rows(mysql_query("SELECT * FROM proyek WHERE kode='$kode'"));
if($cek > 0){
echo "<script>window.alert('Kode proyek yang anda masukan sudah ada')
window.location='proyek.php'</script>";
}else{
if (($extension = 'jpg' || $extension=='png' || $extension=='jpeg') && ($type=='image/jpg' || $type=='image/png' || $type=='image/jpeg') && $size <= $max_size) {
$location = 'gambar/';
if (move_uploaded_file($tmp_name, $location.$gambar_proyek)){
$input = mysql_query("INSERT INTO proyek VALUES('$id_proyek', '$kode', '$id_divisi', '$id_witel', '$nama_pj', '$nama_proyek', '$lokasi', '$garis_bujur', '$garis_lintang', '$id_order1', '$id_type1', '$result', '$mulai_proyek', '$target_proyek', '$mitra', '$jumlah_team', '$survey', '$instalasi_ftth', '$id_kemajuan', '$ct_ut', '$rekon', '$persentasi', '$kendala', '$keterangan', '$gambar_proyek')") or die(mysql_error());
//jika query input sukses
if($input){
echo "<script>window.alert('Data Berhasil Ditambahkan')
window.location='order1.php'</script>";
}else{
echo 'Gagal menambahkan data! '; //Pesan jika proses tambah gagal
}
}
}
}
?>
<html lang="en">
<head>
<?php include ('kerangka.php');?>
<?php include ('koneksi.php');?>
<title>CCAN & WAN</title>
<!-- Bootstrap -->
<link href="../vendors/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- Font Awesome -->
<link href="../vendors/font-awesome/css/font-awesome.min.css" rel="stylesheet">
<!-- NProgress -->
<link href="../vendors/nprogress/nprogress.css" rel="stylesheet">
<!-- iCheck -->
<link href="../vendors/iCheck/skins/flat/green.css" rel="stylesheet">
<!-- Custom Theme Style -->
<link href="../build/css/custom.min.css" rel="stylesheet">
</head>
<body class="nav-md">
<div class="container body">
<!-- page content -->
<div class="right_col" role="main">
<div class="">
<div class="page-title">
<div class="title_left">
<h3>Tambah Proyek</h3>
</div>
<div class="title_right">
<div class="col-md-5 col-sm-5 col-xs-12 form-group pull-right top_search">
<div class="input-group">
<input type="text" class="form-control" placeholder="Search for...">
<span class="input-group-btn">
<button class="btn btn-default" type="button">Go!</button>
</span>
</div>
</div>
</div>
</div>
<div class="clearfix"></div>
<div class="row">
<div class="clearfix"></div>
<form class="form-vertical" method="post" action="" enctype="multipart/form-data">
<div class="control-group">
<label> Kode Proyek </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="kode" placeholder="Kode Proyek">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label>Divisi </label>
<select id="divisi" class ="form-control" singel="singel" name="divisi">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM divisi";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value='".$data['id_divisi']."'>".$data['divisi']."</option>";
}
?>
</select>
</div>
<div class="control-groub">
<label>Site ID </label>
<select id="witel" class ="form-control" singel="singel" name="id_witel" onchange="changeValue(this.value)">
<option selected="selected">-</option>
<?php
include('koneksi.php');
$query = "SELECT * FROM witel";
$hasil = mysql_query($query);
$jsArray = "var dtwitel = new Array(); \n";
while ($data = mysql_fetch_array($hasil))
{
echo "<option value='".$data['id_witel']."'>".$data['site_id']."</option>";
$jsArray .="dtwitel['" . $data['id_witel']."'] ={satu:'" . addcslashes($data['witel'])."'};\n";
}
?>
</select><span class="help-block"></span>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Witel</label>
<div class="controls">
<input type="text" class="form-control" id="id_witel" required="required" placeholder="Witel">
<span class="help-block"></span>
</div>
</div>
<script type="text/javascript">
<?php echo $jsArray; ?>
function changeValue(id){
document.getElementById('id_witel').value = dtwitel[id].satu;
}
</script>
<div class="control-group">
<label class="control-label" for="inputnama">Nama PJ</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="nama_pj" placeholder="Nama PJ">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Nama Proyek</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="nama_proyek" placeholder="Nama Proyek">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Lokasi</label>
<div class="controls">
<textarea rows="5" cols="40" class="form-control" id="inputnama" required="required" name="lokasi" placeholder="Lokasi"></textarea>
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Garis Bujur</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="garis_bujur" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Garis Lintang</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="garis_lintang" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">Order </label>
<select id="order1" class ="form-control" singel="singel" name="order1">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM order1";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value='".$data['id_order1']."'>".$data['order1']."</option>";
}
?>
</select>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">Type </label>
<select id="type1" class ="form-control" singel="singel" name="type1">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM type1";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value='".$data['id_type1']."'>".$data['type1']."</option>";
}
?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Result </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="result" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Mulai Proyek</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="mulai_proyek" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Target Proyek</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="target_proyek" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Mitra </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="mitra" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Jumlah Team </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="jumlah_team" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Survey </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="survey" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Instalasi FTTH</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="instalasi_ftth" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">Proses Kemajuan </label>
<<select id="kemajuan" class ="form-control" singel="singel" name="kemajuan">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM proses_kemajuan";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value='".$data['id_kemajuan']."'>".$data['kemajuan']."</option>";
}
?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">CT/UT</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="ct_ut" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Rekon</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="rekon" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Persentasi</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="persentasi" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Kendala</label>
<div class="controls">
<textarea rows="5" cols="40" class="form-control" id="inputnama" required="required" name="kendala" placeholder=""></textarea>
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputIsiBerita">Deskripsi</label>
<div class="controls">
<textarea rows="5" cols="40" class="form-control" id="inputnama" required="required" name="ket" placeholder="Nama Proyek"></textarea>
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputGambar">Gambar Proyek</label>
<div class="controls">
<input type="file" id="inputGambar" name="gbr_berita" required>
</div>
</div>
<div class="control-group">
<div class="controls">
<div class="form-actions">
<button type="submit" name="tambah" class="btn btn-primary">Simpan</button>
<button type="reset" class="btn btn-danger">Reset</button>
<a class="btn btn btn-warning" href="proyek.php">Kembali</a>
</div>
</div>
</div>
</form>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- /page content -->
<!-- footer content -->
<?php include ('footer.html');?>
<!-- /footer content -->
</div>
<!-- jQuery -->
<script src="../vendors/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap -->
<script src="../vendors/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- FastClick -->
<script src="../vendors/fastclick/lib/fastclick.js"></script>
<!-- NProgress -->
<script src="../vendors/nprogress/nprogress.js"></script>
<!-- iCheck -->
<script src="../vendors/iCheck/icheck.min.js"></script>
<!-- Custom Theme Scripts -->
<script src="../build/js/custom.min.js"></script>
</body>
</html>
0
12 Jawaban:
@lastriani coba dhe query SQLnya di set lalu di echo kemudian di coba ke database.
$sql = "select * from table";
echo $sql;exit;
ada errornya ngga?
0
$input = mysql_query("INSERT INTO proyek VALUES('$id_proyek', '$kode', '$id_divisi', '$id_witel', '$nama_pj', '$nama_proyek', '$lokasi', '$garis_bujur', '$garis_lintang', '$id_order1', '$id_type1', '$result', '$mulai_proyek', '$target_proyek', '$mitra', '$jumlah_team', '$survey', '$instalasi_ftth', '$id_kemajuan', '$ct_ut', '$rekon', '$persentasi', '$kendala', '$keterangan', '$gambar_proyek')") or die(mysql_error());
ini emang gak ada column nya?
INSERT INTO proyek (id,data,user,pass) VALUES ('$id','$data','$pass')
->kira kira begini
0
kalau insert kolomnya tidak disebut bisa selama urutan values bener. tpi rekomendasi memang baiknya kolomnya disebut.
0
sudah di coba dua2 nya gan tetap ngga bisa.
0
hasil query yg diecho gmna ? trus query itu dijalankan klo error error gmna ?
0
ngga ada notif errornya kak cuman pas di click tombol simpan masih tetap di form input, dan data yg diinput sudah kosong ngga kesimpan ke database juga..
0
@lastriani maksudnya coba kamu echo Query SQlnya yg insert bla bla bla itu kemudian kamu copy code querynya dan di run di SQL nya ada pesan error/ tidak. bukan test di browsernya. ini guna untuk memastikan letak errornya dari SQL querynya atau dari database/dll.
0
coba di var dump
var_dump($input);return false;
kalo bool = false, berati query ente ada yg salah
0
cb di echo query statementnya dulu kayak yang disarankan sebelumnya.baru jalanin di database. kemungkinan besar itu masalh query.
0
klo diinput dari database bisa muncul ketampilan form data kak tapi klo diinputkan dari form input ngga bisa nyimpan. @mukhsinsin
0
Jawaban Terpilih
<?php
if(isset($_POST['tambah'])){
include('koneksi.php');
//jika tombol tambah benar di klik maka lanjut prosesnya
$id_proyek = $_POST['id_proyek'];
$siteid = $_POST['siteid'];
$id_witel = $_POST['id_witel'];
$nama_pj = $_POST['nama_pj'];
$nama_proyek = $_POST['nama_proyek'];
$lokasi = $_POST['lokasi'];
$garis_bujur = $_POST['garis_bujur'];
$garis_lintang = $_POST['garis_lintang'];
$id_stowan = $_POST['id_stowan'];
$id_type1 = $_POST['id_type1'];
$mulai_proyek = $_POST['mulai_proyek'];
$target_proyek = $_POST['target_proyek'];
$id_mitrawan = $_POST['id_mitrawan'];
$jumlah_team = $_POST['jumlah_team'];
$nama_odp = $_POST['nama_odp'];
$id_typeolt = $_POST['id_typeolt'];
$nilai_estimasi = $_POST['nilai_estimasi'];
$persentasi = $_POST['persentasi'];
$kendala = $_POST['kendala'];
$keterangan = $_POST['keterangan'];
// Upload
$gambar_proyek = $_FILES['gambar_proyek']['name'];
$extension = strtolower(substr($gambar_proyek, strpos($gambar_proyek, '.') + 1));
$type = $_FILES['gambar_proyek']['type'];
$size = $_FILES['gambar_proyek']['size'];
$max_size = 2097152;
$tmp_name = $_FILES['gambar_proyek']['tmp_name'];
// Akhir Upload Foto
//melakukan query dengan perintah INSERT INTO untuk memasukkan data ke database
if($siteid=='')
echo "siteid kosong";
else
{
$cek = mysql_num_rows(mysql_query("SELECT * FROM proyek WHERE siteid='$siteid'"));
if($cek > 0){
echo "<script>window.alert('Kode proyek yang anda masukan sudah ada')
window.location='proyek.php'</script>";
}else{
if (($extension = 'jpg' || $extension=='png' || $extension=='jpeg') && ($type=='image/jpg' || $type=='image/png' || $type=='image/jpeg') && $size <= $max_size) {
$location = 'gambar/';
if (move_uploaded_file($tmp_name, $location.$gambar_proyek)){
$input = mysql_query("INSERT INTO proyek VALUES('', '$siteid', '$id_witel',
'$nama_pj', '$nama_proyek', '$lokasi', '$garis_bujur','$garis_lintang', '$id_stowan', '$id_type1',
'$mulai_proyek', '$target_proyek', '$id_mitrawan', '$jumlah_team', '$nama_odp', '$id_typeolt',
'$nilai_estimasi', '$persentasi', '$kendala', '$keterangan', '$gambar_proyek')") or die(mysql_error());
//jika query input sukses
if($input){
echo "<script>window.alert('Data Berhasil Ditambahkan')
window.location='proyek.php'</script>";
}else{
echo 'Gagal menambahkan data! '; //Pesan jika proses tambah gagal
}
}
}
}
}
}
?>
<html lang="en">
<head>
<?php include ('kerangka.php');?>
<?php include ('koneksi.php');?>
<title>CCAN & WAN</title>
<!-- Bootstrap -->
<link href="../vendors/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- Font Awesome -->
<link href="../vendors/font-awesome/css/font-awesome.min.css" rel="stylesheet">
<!-- NProgress -->
<link href="../vendors/nprogress/nprogress.css" rel="stylesheet">
<!-- iCheck -->
<link href="../vendors/iCheck/skins/flat/green.css" rel="stylesheet">
<!-- Custom Theme Style -->
<link href="../build/css/custom.min.css" rel="stylesheet">
</head>
<body class="nav-md">
<div class="container body">
<!-- page content -->
<div class="right_col" role="main">
<div class="">
<div class="page-title">
<div class="title_left">
<h3>Tambah Proyek</h3>
</div>
<div class="title_right">
<div class="col-md-5 col-sm-5 col-xs-12 form-group pull-right top_search">
<div class="input-group">
<input type="text" class="form-control" placeholder="Search for...">
<span class="input-group-btn">
<button class="btn btn-default" type="button">Go!</button>
</span>
</div>
</div>
</div>
</div>
<div class="clearfix"></div>
<div class="row">
<div class="clearfix"></div>
<form class="form-vertical" method="post" action="" enctype="multipart/form-data">
<div class="control-group">
<label> Site ID </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="siteid" placeholder="Kode Proyek">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label>Witel </label>
<select id="witel" class ="form-control" singel="singel" name="witel">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM witel";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value=\"$data[id_witel]\">$data[witel]'</option>";
}
?>
</select>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Nama PJ</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="nama_pj" placeholder="Nama PJ">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Nama Proyek</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="nama_proyek" placeholder="Nama Proyek">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Lokasi</label>
<div class="controls">
<textarea rows="5" cols="40" class="form-control" id="inputnama" required="required" name="lokasi" placeholder="Lokasi"></textarea>
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Garis Bujur</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="garis_bujur" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Garis Lintang</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="garis_lintang" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">STO </label>
<select id="stowan" class ="form-control" singel="singel" name="stowan">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM stowan";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value=\"$data[id_stowan]\">$data[stowan]</option>";
}
?>
</select>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">Type/ Kategori </label>
<select id="type1" class ="form-control" singel="singel" name="type1">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM type1";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value=\"$data[id_type1]\">$data[type1]</option>";
}
?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Mulai Proyek</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="mulai_proyek" placeholder="">
<span class="help-block"></span>
</div>
</div>
<!--
onClick="if(self.gfPop)gfPop.fPopCalendar(document.postform.from);return false;">
<a href="javascript:void(0)" onClick="if(self.gfPop)gfPop.fPopCalendar(document.postform.from);return false;">
<img name="popcal" align="absmiddle" style="border:none" src="img/calender.png" width="34" height="29" border="0" alt=""></a>
<tr>
<td>Sampai Tanggal :</td> <td>
<input type="text" id="to" name="to" onClick="if(self.gfPop)gfPop.fPopCalendar(document.postform.to);return false;"/><a href="javascript:void(0)" onClick="if(self.gfPop)gfPop.fPopCalendar(document.postform.to);return false;" ><img name="popcal" align="absmiddle" style="border:none" src="./calender/calender.jpeg" width="34" height="29" border="0" alt=""></a></td>
</tr> -->
<div class="control-group">
<label class="control-label" for="inputnama">Target Proyek</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="target_proyek" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">Mitra </label>
<select id="mitrawan" class ="form-control" singel="singel" name="mitrawan">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM mitrawan";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value=\"$data[id_mitrawan]\">$data[mitrawan]</option>";
}
?>
</select>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Jumlah Team </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="jumlah_team" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Nama ODP </label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="nama_odp" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-groub">
<label class="control-label" for="inputnama">Type OLT </label>
<select id="typeolt" class ="form-control" singel="singel" name="typeolt">
<option selected="selected">-</option>
<?php
// query untuk menampilkan semua mata pelajaran dari tabel
$query = "SELECT * FROM typeolt";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<option value=\"$data[id_typeolt]\">$data[typeolt]</option>";
}
?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Nilai Estimasi</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="nilai_estimasi" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Persentasi</label>
<div class="controls">
<input type="text" class="form-control" id="inputnama" required="required" name="persentasi" placeholder="">
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputnama">Kendala</label>
<div class="controls">
<textarea rows="5" cols="40" class="form-control" id="inputnama" required="required" name="kendala" placeholder=""></textarea>
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputIsiBerita">Deskripsi</label>
<div class="controls">
<textarea rows="5" cols="40" class="form-control" id="inputnama" required="required" name="ket" placeholder=""></textarea>
<span class="help-block"></span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputGambar">Gambar Proyek</label>
<div class="controls">
<input type="file" id="inputGambar" name="gambar_proyek" required>
</div>
</div>
<div class="control-group">
<div class="controls">
<div class="form-actions">
<button type="submit" name="tambah" class="btn btn-primary">Simpan</button>
<button type="reset" class="btn btn-danger">Reset</button>
<a class="btn btn btn-warning" href="proyekccan.php">Kembali</a>
</div>
</div>
</div>
</form>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- /page content -->
<!-- footer content -->
<?php include ('footer.html');?>
<!-- /footer content -->
</div>
<!-- jQuery -->
<script src="../vendors/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap -->
<script src="../vendors/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- FastClick -->
<script src="../vendors/fastclick/lib/fastclick.js"></script>
<!-- NProgress -->
<script src="../vendors/nprogress/nprogress.js"></script>
<!-- iCheck -->
<script src="../vendors/iCheck/icheck.min.js"></script>
<!-- Custom Theme Scripts -->
<script src="../build/js/custom.min.js"></script>
</body>
</html>
field2 yang terdahulu saya ganti beberapa hingga menjdi seperti code diatas. ada beberapa query pada code ketinggalan akibat saya kurang teliti. dan yang anehnya lagi setelah query saya betulkan, code masih salah dan setelah code yang ada saya copy ke halaman baru dan saya simpan dengan nama yang sama tetapi hnya saya tambah angka 1 dan setelah saya coba ternyata bisa ke simpan.. :( :D
0