Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Notice: undefined variable --->($databahan)
salah dimananya y? ko variabel $dataBahan gk kebaca??
<?php
// Validasi Login : yang boleh mengakses halaman ini hanya yang sudah Login admin
include_once "../library/inc.sesadmin.php";
include_once "../library/inc.library.php";
include_once "../library/inc.connection.php";
# TOMBOL SIMPAN DIKLIK
if(isset($_POST['btnSimpan'])){
// Baca form
$txtNama = $_POST['txtNama'];
$txtNama = str_replace("'","´",$txtNama);
$txtNama = ucwords(strtolower($txtNama));
$cmbBahan =$_POST['cmbBahan'];
$txtHrgJual = $_POST['txtHrgJual'];
$txtHrgJual = str_replace("'","´",$txtHrgJual);
$txtStok = $_POST['txtStok'];
$txtStok = str_replace("'","´",$txtStok);
$txtKeterangan =$_POST['txtKeterangan'];
$txtKeterangan = str_replace("'","´",$txtKeterangan);
$cmbKategori =$_POST['cmbKategori'];
// Validasi form
$pesanError = array();
if (trim($txtNama)=="") {
$pesanError[] = "Data <b>Nama Barang</b> tidak boleh kosong !";
}
if (trim($txtKeterangan)=="") {
$pesanError[] = "Data <b>Keterangan</b> tidak boleh kosong !";
}
if (trim($cmbKategori)=="KOSONG") {
$pesanError[] = "Data <b>Kategori</b> belum dipilih !";
}
# JIKA ADA PESAN ERROR DARI VALIDASI
if (count($pesanError)>=1 ){
echo "<div class='mssgBox'>";
echo "<img src='../images/attention.png'> <br><hr>";
$noPesan=0;
foreach ($pesanError as $indeks=>$pesan_tampil) {
$noPesan++;
echo "Â Â $noPesan. $pesan_tampil<br>";
}
echo "</div> <br>";
}
else {
# SIMPAN DATA KE DATABASE. Jika tidak menemukan pesan error, simpan data ke database
// Membuat kode baru
$kodeBaru = buatKode("barang", "B");
// Mengkopi file gambar
if (! empty($_FILES['namaFile']['tmp_name'])) {
$nama_file = $_FILES['namaFile']['name'];
$nama_file = stripslashes($nama_file);
$nama_file = str_replace("'","",$nama_file);
$nama_file = str_replace(" ","-",$nama_file);
$nama_file = $kodeBaru.".".$nama_file;
copy($_FILES['namaFile']['tmp_name'],"../img-barang/".$nama_file);
}
else {
$nama_file = "";
}
// Simpan data dari form ke database
$mySql = "INSERT INTO barang (kd_barang, nm_barang, kd_bahan,
harga_jual, stok, keterangan, file_gambar, kd_kategori) VALUES('$kodeBaru', '$txtNama', '$dataBahan', '$txtHrgJual', '$txtStok', '$txtKeterangan',
'$nama_file', '$cmbKategori')";
$myQry = mysql_query($mySql, $koneksidb) or die ("Query salah : ".mysql_error());
if($myQry){
// Refresh
echo "<meta http-equiv='refresh' content='0; url=?open=Barang-Add'>";
}
}
}
# MEMBUAT NILAI DATA PADA FORM
# SIMPAN DATA PADA FORM, Jika saat Sumbit ada yang kosong (lupa belum diisi)
$dataKode = buatKode("barang", "B");
$dataNama = isset($_POST['txtNama']) ? $_POST['txtNama'] : '';
$dataBahan = isset($_POST['cmbBahan']) ? $_POST['cmbBahan'] : '';
$dataHrgJual = isset($_POST['txtHrgJual']) ? $_POST['txtHrgJual'] : '';
$dataStok = isset($_POST['txtStok']) ? $_POST['txtStok'] : '';
$dataKeterangan = isset($_POST['txtKeterangan']) ? $_POST['txtKeterangan'] : '';
$dataKategori = isset($_POST['cmbKategori']) ? $_POST['cmbKategori'] : '';
?>
<meta content='width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0, shrink-to-fit=no' name='viewport' />
<!-- Fonts and icons -->
<link href="https://fonts.googleapis.com/css?family=Montserrat:400,700,200" rel="stylesheet" />
<link href="https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css" rel="stylesheet">
<!-- CSS Files -->
<link href="../assets/css/bootstrap.min.css" rel="stylesheet" />
<link href="../assets/css/paper-dashboard.css?v=2.0.0" rel="stylesheet" />
<!-- CSS Just for demo purpose, don't include it in your project -->
<link href="../assets/demo/demo.css" rel="stylesheet" />
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data" name="frmadd">
<table class="table-list" width="100%" style="margin-top:0px;">
<tr>
<th colspan="3"><strong>TAMBAH DATA BARANG </strong></th>
</tr>
<tr>
<td width="14%"><strong>Kode</strong></td>
<td width="1%"><strong>:</strong></td>
<td width="85%"><input name="textfield" value="<?php echo $dataKode; ?>" size="10" maxlength="10" readonly="readonly"/></td></tr>
<tr>
<td><strong>Nama Barang </strong></td>
<td><strong>:</strong></td>
<td><input name="txtNama" value="<?php echo $dataNama; ?>" size="80" maxlength="200" /></td>
</tr>
<tr>
<td><strong>Bahan</strong></td>
<td><strong>:</strong></td>
<td><select name="cmbBahan">
<option value="KOSONG" selected="selected">....</option>
<?php
$comboSql = "SELECT * FROM bahan ORDER BY nm_bahan ASC";
$comboQry = mysql_query($comboSql, $koneksidb) or die ("Gagal query".mysql_error());
while ($comboData =mysql_fetch_array($comboQry)) {
if ($comboData['kd_bahan']==$dataBahan) {
$cek="selected";
}
else {
$cek="";
}
echo "<option value='$comboData[kd_bahan]' $cek>$comboData[nm_bahan]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td><strong>Harga Jual (Rp) </strong></td>
<td><strong>:</strong></td>
<td><input name="txtHrgJual" type="text" value="<?php echo $dataHrgJual; ?>" size="20" maxlength="12" /></td>
</tr>
<tr>
<td><strong>Jumlah Stok </strong></td>
<td><strong>:</strong></td>
<td><input name="txtStok" type="text" value="<?php echo $dataStok; ?>" size="10" maxlength="4" /></td>
</tr>
<tr>
<td><strong>File Gambar </strong></td>
<td><strong>:</strong></td>
<td><input name="namaFile" type="file" size="70" /></td>
</tr>
<tr>
<td><strong>Keterangan</strong></td>
<td><strong>:</strong></td>
<td><textarea id="elm1" name="txtKeterangan" cols="70" rows="6"><?php echo $dataKeterangan; ?></textarea></td>
</tr>
<tr>
<td><strong>Kategori</strong></td>
<td><strong>:</strong></td>
<td><select name="cmbKategori">
<option value="KOSONG">....</option>
<?php
$mySql = "SELECT * FROM kategori ORDER BY nm_kategori";
$myQry = mysql_query($mySql, $koneksidb) or die ("Gagal Query".mysql_error());
while ($myData = mysql_fetch_array($myQry)) {
if ($myData['kd_kategori']== $dataKategori) {
$cek = " selected";
} else { $cek=""; }
echo "<option value='$myData[kd_kategori]' $cek> $myData[nm_kategori] </option>";
}
?>
</select></td>
</tr>
<tr><td>Â </td>
<td>Â </td>
<td><input type="submit" name="btnSimpan" value=" SIMPAN DATA " style="cursor:pointer;"></td>
</tr>
</table>
</form>
0
3 Jawaban:
hai @alanbeck sepertinya kamu salah masukkan nama variablenya, karena dari kode kamu itu kamu assign hasil dari cmbBahan di variable $cmbBahan bukan di $dataBahan. coba di cek lagi.
1