<?php
include("includes/db.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="
https://tinymce.cachefly.net/4.0/tinymce.min.js"></script>
<script>tinymce.init({ selector:'textarea' });</script>
</head>
<body bgcolor="#FFFFFF">
<center><div class="header_wrapper">
<img src="images/ad_banner.jpg"></div></center>
<form method="post" action="insert_product.php" enctype="multipart/form-data">
<table width="1000" height="600" align="center" bgcolor="#66CCFF">
<td align="center" bgcolor="#FFFFFF"><h1>Insert New Product</h1></td>
<tr>
<td>
<table width="710" align="center" bgcolor="#66CCFF">
<tr align="center" bordercolor="#6633FF">
</tr>
<tr>
<td><b>Product Title : </b></td>
<td><input type="text" name="product_title" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Category : </b></td>
<td>
<select name="product_cat">
<option>Select a Category</option>
<?php
$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>
<td>
</td>
<tr>
<td><b>Product Brand : </b></td>
<td>
<select name="product_brand">
<option>Select-Brand</option>
<?php
$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>
<td>
</td>
<tr>
<td><b>Product Image 1 : </b></td>
<td><input type="file" name="product_img1" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Image 2 : </b></td>
<td><input type="file" name="product_img2" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Image 3 : </b></td>
<td><input type="file" name="product_img3" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Price : </b></td>
<td><input type="text" name="product_price" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Description : </b></td>
<td><textarea name="product_desc" cols="38" rows="10"></textarea></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Keywords : </b></td>
<td><input type="text" name="product_keywords" size="50"/></td>
</tr>
<td>
</td>
<tr align="center">
<td colspan="2"><input type="submit" name="insert_product" value="Insert Product" /></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
if(isset($_POST['insert_product'])){
//text data variables
$product_title = $_POST['product_title'];
$product_cat = $_POST['product_cat'];
$product_brand = $_POST['product_brand'];
$product_price = $_POST['product_price'];
$product_desc = $_POST['product_desc'];
$status = 'on';
$product_keywords = $_POST['product_keywords'];
//image names
$product_img1 = $_FILES['product_img1'] ['name'];
$product_img2 = $_FILES['product_img2'] ['name'];
$product_img3 = $_FILES['product_img3'] ['name'];
//Immage temp names
$temp_name1 = $_FILES['product_img1'] ['tmp_name'];
$temp_name2 = $_FILES['product_img2'] ['tmp_name'];
$temp_name3 = $_FILES['product_img3'] ['tmp_name'];
if($product_title=='' OR $product_cat=='' OR $product_brand=='' OR $product_price=='' OR $product_desc=='' OR$product_keywords=='' OR $product_img1=='' ) {
echo "<script>alert('please fill all the fields!')</script>";
exit();
}
else{
//uploading imagea to its folder
move_uploaded_file($temp_name1,"product_images/$product_img1");
move_uploaded_file($temp_name1,"product_images/$product_img2");
move_uploaded_file($temp_name1,"product_images/$product_img3");
$insert_product = "insert into products (cat_id,brand_id,date,product_title,product_img1,product_img2,product_img3,product_price,product_desc,status) values ('$product_cat','$product_brand',NOW(),'$product_title','$product_img1','$product_img2','$product_img3','$product_price','$product_desc','$status')";
$run_product = mysqli_query($con, $insert_product);
if($run_product){
echo "<script>alert('Product inserted successfully')</script>";
}
}
}
?>
ช่วยดูให้หน่อยครับ
ช่วยด้วยครับ !! เขียนโค้ด php เพิ่มสินค้า แล้วมันไม่เข้าฐานข้อมูล แก้มา1วันเต็มๆแล้ว
include("includes/db.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="https://tinymce.cachefly.net/4.0/tinymce.min.js"></script>
<script>tinymce.init({ selector:'textarea' });</script>
</head>
<body bgcolor="#FFFFFF">
<center><div class="header_wrapper">
<img src="images/ad_banner.jpg"></div></center>
<form method="post" action="insert_product.php" enctype="multipart/form-data">
<table width="1000" height="600" align="center" bgcolor="#66CCFF">
<td align="center" bgcolor="#FFFFFF"><h1>Insert New Product</h1></td>
<tr>
<td>
<table width="710" align="center" bgcolor="#66CCFF">
<tr align="center" bordercolor="#6633FF">
</tr>
<tr>
<td><b>Product Title : </b></td>
<td><input type="text" name="product_title" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Category : </b></td>
<td>
<select name="product_cat">
<option>Select a Category</option>
<?php
$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>
<td>
</td>
<tr>
<td><b>Product Brand : </b></td>
<td>
<select name="product_brand">
<option>Select-Brand</option>
<?php
$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>
<td>
</td>
<tr>
<td><b>Product Image 1 : </b></td>
<td><input type="file" name="product_img1" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Image 2 : </b></td>
<td><input type="file" name="product_img2" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Image 3 : </b></td>
<td><input type="file" name="product_img3" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Price : </b></td>
<td><input type="text" name="product_price" /></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Description : </b></td>
<td><textarea name="product_desc" cols="38" rows="10"></textarea></td>
</tr>
<td>
</td>
<tr>
<td><b>Product Keywords : </b></td>
<td><input type="text" name="product_keywords" size="50"/></td>
</tr>
<td>
</td>
<tr align="center">
<td colspan="2"><input type="submit" name="insert_product" value="Insert Product" /></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
if(isset($_POST['insert_product'])){
//text data variables
$product_title = $_POST['product_title'];
$product_cat = $_POST['product_cat'];
$product_brand = $_POST['product_brand'];
$product_price = $_POST['product_price'];
$product_desc = $_POST['product_desc'];
$status = 'on';
$product_keywords = $_POST['product_keywords'];
//image names
$product_img1 = $_FILES['product_img1'] ['name'];
$product_img2 = $_FILES['product_img2'] ['name'];
$product_img3 = $_FILES['product_img3'] ['name'];
//Immage temp names
$temp_name1 = $_FILES['product_img1'] ['tmp_name'];
$temp_name2 = $_FILES['product_img2'] ['tmp_name'];
$temp_name3 = $_FILES['product_img3'] ['tmp_name'];
if($product_title=='' OR $product_cat=='' OR $product_brand=='' OR $product_price=='' OR $product_desc=='' OR$product_keywords=='' OR $product_img1=='' ) {
echo "<script>alert('please fill all the fields!')</script>";
exit();
}
else{
//uploading imagea to its folder
move_uploaded_file($temp_name1,"product_images/$product_img1");
move_uploaded_file($temp_name1,"product_images/$product_img2");
move_uploaded_file($temp_name1,"product_images/$product_img3");
$insert_product = "insert into products (cat_id,brand_id,date,product_title,product_img1,product_img2,product_img3,product_price,product_desc,status) values ('$product_cat','$product_brand',NOW(),'$product_title','$product_img1','$product_img2','$product_img3','$product_price','$product_desc','$status')";
$run_product = mysqli_query($con, $insert_product);
if($run_product){
echo "<script>alert('Product inserted successfully')</script>";
}
}
}
?>
ช่วยดูให้หน่อยครับ