sesuai jdul, form ini tempat admin input produk baru nya..
tapi kok pas diinput dan upload gambar, lalu saat simpan malah gagal terupload ya? slah dmn ya kakak?
gimana biar file data + gambarnya bs tersimpan ke databasenya..
tabel databasenya : produk
Quote:
<html>
<head>
<title>Data Barang</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
require_once('config.php');
$status="";
$cmbCategories="";
$txtkode_brg="";
$txtnama_brg="";
$txtjumlah="";
$txtHarga="";
$txtDeskripsi="";
$txtGambar="";
//---Membuat Function anti injection----------------------
function anti_injection($str){
$str=stripslashes(strip_tags(htmlspecialchars($str,ENT_QUOTES)));
return $str;
}
if(isset($_POST['btnSimpan'])){
$cmbCategories=$_POST['cmbCategories'];
$txtkode_brg=anti_injection($_POST['txtkode_brg']);
$txtnama_brg=anti_injection($_POST['txtnama_brg']);
$txtjumlah=anti_injection($_POST['txtjumlah']);
$txtHarga=$_POST['txtHarga'];
$txtDeskripsi=anti_injection($_POST['txtDeskripsi']);
$txtGambar=$_FILES['txtGambar']['name'];
$ssql="INSERT INTO produk(kode_brg, nama_brg, jumlah, price, description, image)
SELECT '$txtkode_brg', '$cmbCategories', '$txtnama_brg', '$txtjumlah',
'$txtHarga', '$txtDeskripsi', '$txtGambar'
";
//file upload.php
$fileName = $_FILES['picture']['name']; //berisi nama file yang sedang diupload
$fileSize = $_FILES['picture']['size'];
$fileError = $_FILES['picture']['error']; //ukuran size file yang diupload dalam byte
if($fileSize > 0 || $fileError == 0){
$move = move_uploaded_file($_FILES['picture']['tmp_name'], 'images/'.$fileName);
if($move){
echo "gambar berhasil diupload";
}else{
echo "Gagal mengupload file";
}
}else{
echo "Gagal mengupload file: ".$fileError;
}
}
?>
<form method="post" enctype="multipart/form-data">
<table border="1">
<tr>
<th colspan="2" align="right" style="border: white;">--: Input produk baru:--</th>
</tr>
<tr>
<td>Kategori</td>
<td> :<select name="cmbCategories">
<option>Mahkota dental material</option>
<option>Mahkota dental unit</option>
<option>Mahkota dental instrument</option>
<?php
$ssql="SELECT * FROM kategori WHERE 1";
$result=mysql_query($ssql);
//--menampilkan isi categori------------------------------
while ($data=mysql_fetch_array($result)){
echo "<option value='$data[Mahkota_dental_material]'>$data[Mahkota_dental_unit], $data[Mahkota_dental_instrument]</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Kode_brg</td>
<td> :<input name="txtkode_brg" type="text" maxlength="13" size="20" ></td>
</tr>
<tr>
<td>nama_brg</td>
<td> :<input name="txtnama_brg" type="text" size="30" maxlength="60" ></td>
</tr>
<tr>
<tr>
<td>jumlah</td>
<td> :<input name="txtjumlah" type="text" size="20" maxlength="30" ></td>
</tr>
<tr>
<td>Harga</td>
<td> :<input name="txtHarga" type="text" size="10" maxlength="10" align="right" value="0.00" ></td>
</tr>
<tr>
<td valign="top">Deskripsi</td>
<td> <textarea name="txtDeskripsi" rows="3" cols="20"></textarea></td>
</tr>
<tr>
<td>Gambar</td>
<td> :<input name="txtGambar" type="file"></td>
</tr>
<tr>
<td><input name="btnSimpan" type="submit" value="Simpan">
<input name="btnBatal" type="reset" value="Batal">
<input type="hidden" name="txtFlag"></td>
<td align="right"><?
echo "$status";
?></td>
</tr>
</table>
</form>
</body>
</html>