image witharak upload wenne ne, anith data tika enter wenawa...
HTML:
<!DOCTYPE>
<?php
include("includes/db.php");
?>
<html>
<head>
<title>Inserting Product</title>
<script src="//cdn.tinymce.com/4/tinymce.min.js"></script>
<script>tinymce.init({ selector:'textarea' });</script>
</head>
<body bgcolor="skyblue">
<form action="insert_product.php" method="post" encrypt="multipart/form-data">
<table align="center" width="750" border="2" bgcolor="Orange">
<tr align="center">
<td colspan="7"><h2>Insert New Post Here</h2></td>
<tr>
<td align="right"><b>Product Title:</b> </td>
<td><input type="text" name="product_title" size="60" required/></td>
</tr>
<tr>
<td align="right"><b>Product Category:</b> </td>
<td>
<select name="product_cat" required/>
<option>Select a Category</option>
<?php
// select categories
$get_cats= "select * from categories ";
$run_cats = mysqli_query($con,$get_cats);
while ($row_cats= mysqli_fetch_array($run_cats)){
$cat_id = $row_cats['cat_id'];
$cat_title = $row_cats['cat_title'];
echo "<option value='$cat_id'>$cat_title</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td align="right"><b>Product Brand:</b> </td>
<td>
<select name="product_brand" required/>
<option>Select a Brand</option>
<?php
// select brands
$get_brands= "select * from brands ";
$run_brands = mysqli_query($con,$get_brands);
while ($row_brands= mysqli_fetch_array($run_brands)){
$brand_id = $row_brands['brand_id'];
$brand_title = $row_brands['brand_title'];
echo "<option value='$brand_id'>$brand_title</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td align="right"><b>Product Image:</b> </td>
<td><input type="file" name="product_image"/></td>
</tr>
<tr>
<td align="right"><b>Product Price: </b></td>
<td><input type="text" name="product_price" /></td>
</tr>
<tr>
<td align="right"><b>Product Description: </b></td>
<td>
<textarea name="product_desc" cols="30" rows="10" / ></textarea>
</td>
</tr>
<tr>
<td align="right"><b>Product Keywords:</b> </td>
<td><input type="text" name="product_keywords" size="60" required/></td>
</tr>
<tr align="center">
<td colspan="8"><input type="submit" name="insert_post" value="Insert Product Now"></td>
</tr>
</tr>
</table>
</form>
</body>
</html>
<?php
if(isset($_POST['insert_post'])){
$product_title = $_POST['product_title'];
$product_cat = $_POST['product_cat'];
$product_brand = $_POST['product_title'];
$product_price = $_POST['product_price'];
$product_desc = $_POST['product_desc'];
$product_keywords = $_POST['product_keywords'];
$product_image = $_FILES['product_image']['name'][0];
$product_image_tmp = $_FILES['product_image']['tmp_name'][0];
move_uploaded_file($product_image_tmp,"product_images/$product_image");
echo $insert_product = "insert into products
(product_cat,product_brand,product_title,product_price,product_desc,product_image,product_keywords)
values('$product_cat','$product_brand','$product_title','$product_price','$product_desc','$product_image','$product_keywords')";
$insert_pro = mysqli_query($con,$insert_product);
if($insert_pro){
echo "<script>alert('Product Has Been Inserted')</script>";
echo "<script>window.open('insert_product.php','_self')</script>";
}
}
?>
