product_edit.php
// SETELAH TOMBOL SIMPAN DI TEKAN
if (isset($_POST['save'])){
$tgl_masuk = date("y-m-j");
if (empty($_POST['id'])){
$result = mysql_query("INSERT INTO produk(nama_produk, harga, deskripsi, tgl_masuk, gambar) VALUES('".$nama."','".$harga."','".$deskripsi."','".$tgl_masuk."','".$gambar."')");
echo "Data has been recorded in the database.";
}
else{
$result = mysql_query("UPDATE produk SET nama_produk='".$nama_produk."', harga='".$harga."', deskripsi='".$deskripsi."', gambar='".$gambar."' WHERE id=".$_POST['id']);
$result = mysql_query($sqlstr) or die(mysql_error());
$confirmation = ($result) ? "Data telah tersimpan." : "Gagal menyimpan data.";
}
}
?>
<h2><center>Product Preview</center></h2>
<p></p>
<?php
$data = array();
if(!empty($_GET['id']))
{
$result = mysql_query("SELECT * FROM produk AS p, kategori AS k WHERE id_produk='".mysql_real_escape_string($_GET['id'])."'AND p.id_kategori = k.id_kategori") or die(mysql_error());
$data = mysql_fetch_array($result);
echo '<pre>';
print_r($data);
//print_r($array);
echo '</pre>';
}
else
{
$data['nama_produk'] = '';
$data['nama_kategori'] = '';
$data['harga'] = '';
//$data['deskripsi'] = '';
$data['gambar'] = '';
//print_r($data);
}
?>
<form method = "POST" not enctype="multipart/form-data" action = "<?php $_SERVER['PHP_SELF']; ?>">
<table border="0" cellpadding="2">
<tr>
<td>Nama</td>
<td><input name="nama" size="20px" type="text" value ="<?php echo $data['nama_produk']; ?>"/>
</tr>
<tr>
<td>Kategori</td>
<td><select name="kategori"><option value=<?php echo $data['nama_kategori']; ?> selected><?php echo $data['nama_kategori']; ?></option>
<?php
$resultCOMBO = mysql_query("SELECT nama_kategori FROM kategori") or die(mysql_error()); while($dataCOMBO = mysql_fetch_array($resultCOMBO)){
echo "<option value={$dataCOMBO['nama_kategori']}>{$dataCOMBO['nama_kategori']}</option>";
}?>
</select>
</td>
</tr>
<tr>
<td>Harga</td>
<td><input name="harga" type="text" value = <?php echo $data['harga']; ?>></td>
</tr>
<tr>
<td>Deskripsi</td>
<td>
<textarea name="deskripsi" cols="30" rows="15"><?php echo isset($data['deskripsi']) ? $data['deskripsi'] : ''; ?></textarea></td>
<script type="text/javascript">
var editor = CKEDITOR.replace('deskripsi');
</script>
</tr>
<tr>
<td>Gambar</td>
<td><img src="foto_produk/<?php echo $data['gambar'];?>" width="30%" height="30%" /></td>
</tr>
<tr>
<td>Ganti Gambar</td>
<td>
<input name="gambar" type="file" value="Browse" /></td>
</tr>
<tr>
<td></td>
<td><br /><center><input name="save" type="submit" value="Simpan" /></center></td>
</form>
</tr>
</tr>Hi, I am trying to insert the following data into table product:
nama_produk, harga, deskripsi, tgl_masuk, gambar
There are 2 datas that I failed to insert:
1. id_kategori (I have not include in the insert since in the form only shows nama_kategori which id's is shown in kategori table.). I do not know how to insert id_kategori since the form only shows me nama_kategori (kategori table shows the information regarding the kategori id from nama_kategori)
2. gambar (or picture). I wonder why when I checked the table the file information is not there yet.
Please help. Thanks.
