simpan data ke database

<!DOCTYPE html>

<?php

include ('includes/db.php');


?>
<html>
<head>
	<title>Inserting Product</title>
<script type="text/javascript" src="../../tinymce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
         // General options
         mode : "textareas",
         theme : "advanced",
});
</script>


</head>
<body>


<form action="tambahBuku.php" method="post" enctype="multipart/form-data" >

	<table align="center" width="100px" border="1"  bgcolor="#987">

		<tr align="center">
			<td colspan="7"><b><h2>Tambah Buku</h2></b></td>
		</tr>

		<tr>
			<td align="right"><b>Judul Buku</b></td>
			<td>
				<input type="text" name="judul_buku" size="60" required/>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Kategori Buku</b></td>
			<td>
				<select name="product_cat">
					<option>Select a Kategori</option>
					<?php
			$get_cats = "SELECT * FROM kategori";

			$run_cats =mysqli_query($con, $get_cats);

			while ($row_cats=mysqli_fetch_array ($run_cats)){

				$cat_id = $row_cats['kid'];
				$cat_nama = $row_cats['knama'];
				$cat_kdeskripsi = $row_cats['kdeskripsi'];

			echo "<option value='$cat_id'>$cat_kdeskripsi</option> ";


			}


					?>

				</select>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Penerbit Buku</b></td>
			<td>
				<select name="penerbit_buku">
					<option>Select a Penerbit</option>
					<?php
			$get_penerbit = "SELECT * FROM penerbit";

			$run_penerbit =mysqli_query($con, $get_penerbit);

			while ($row_penerbit=mysqli_fetch_array ($run_penerbit)){

			$penerbit_id = $row_penerbit['penerbit_id'];
			$nama_penerbit = $row_penerbit['nama_penerbit'];

				echo "<option value='$penerbit_id'>$nama_penerbit</option> ";


			}

					?>

				</select>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Gambar Buku</b></td>
			<td>
				<input type="file" name="gambar_buku" required />
			</td>
		</tr>

		<tr>
			<td align="right"><b>Harga Buku</b></td>
			<td>
				<input type="text" name="harga_buku	" required/>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Buku Description</b></td>
			<td>
				<textarea name="buku_desc" cols="90" rows="10">

				</textarea>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Discoun</b></td>
			<td>
				<input type="text" name="discoun" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Tahun Terbit</b></td>
			<td>
				<input type="text" name="tahun_terbit" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Bahasa</b></td>
			<td>
				<input type="text" name="bahasa" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Total Halaman</b></td>
			<td>
				<input type="text" name="t_halaman" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Isbn</b></td>
			<td>
				<input type="text" name="isbn" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Total Buku</b></td>
			<td>
				<input type="text" name="total" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Dimensi</b></td>
			<td>
				<input type="text" name="dimensi" size="50"> </input>
			</td>
		</tr>

		<tr>
			<td align="right"><b>Searching</b></td>
			<td>
				<input type="text" name="searching" size="50"> </input>
			</td>
		</tr>

		<tr align="center">
			<td colspan="7">
				<input type="Submit" name="insert_post" value="Insert Now"> </input>
			</td>
		</tr>

	</table>

</form>

</body>
</html>


<?php

	if(isset($_POST['insert_post'])){

		//getting the text data from the fields
		$judul_buku = $_POST['judul_buku'];
		$product_cat = $_POST['product_cat'];
		$penerbit_buku = $_POST['penerbit_buku'];
		$harga_buku = $_POST['harga_buku'];
		$buku_desc = $_POST['buku_desc'];
		$discoun = $_POST['discoun'];

		$tahun_terbit = $_POST['tahun_terbit'];
		$bahasa = $_POST['bahasa'];
		$t_halaman = $_POST['t_halaman'];
		$isbn = $_POST['isbn'];
		$total = $_POST['total'];
		$dimensi = $_POST['dimensi'];
		$searching = $_POST['searching'];

		//getting the image the fields
		$gambar_buku = $_FILES['gambar_buku']['name'];
		$product_image_tmp = $_FILES['gambar_buku']['tmp_name'];


		move_uploaded_file($product_image_tmp,"buku_images/$gambar_buku");


$insert_buku = "INSERT INTO buku (id_kategori,id_penerbit,judul_buku,deskripsi_buku,harga_buku,discoun_buku,tahun_terbit,bahasa,halaman,isbn,total_buku,gambar_buku,dimensi,searching) VALUES ('$product_cat','$penerbit_buku','$judul_buku','$buku_desc','$harga_buku','$discoun','$tahun_terbit','$bahasa','$t_halaman','$isbn','$total','$gambar_buku','$dimensi','$searching' ) ";


		 $insert_pro =mysqli_query($con,$insert_buku);


		 if($insert_pro){

		 	echo "<script>alert ('Product has been inserted!') </script> ";
		 	echo "<script>window.open('media.php?module=kategori','_self') </script>";

		 }


	}


?>