query($SQL_product);
while ($objResult_product = mysqli_fetch_array($objQuery_product)) {
$ProductDetail = $objResult_product["Product_Detail"];
$ProductDetail2 = $objResult_product["Product_Detail2"];
$ProductDetail3 = $objResult_product["Product_Detail3"];
$ProductUnit = $objResult_product["Product_Unit"];
$ProductCategoryID = $objResult_product["ProductCategory_ID"];
$ProductCategoryName = $objResult_product["ProductCategory_Name"];
$ProductID = $objResult_product["Product_ID"];
$ProductName = $objResult_product["Product_Name"];
$ProductImg = $objResult_product["Product_Img"];
$ProductPrice = $objResult_product["Product_Price"];
$ProductDate = $objResult_product["Product_Date"];
$NewformatProductPrice = number_format((float) $ProductPrice, 2, '.', ',');
$ProductDate_Create = date_create($ProductDate);
$ProductDate_New = date_format($ProductDate_Create, "F d , Y");
$sql_img_list = "
SELECT ProductImg_ID , Product_ID , ProductImg_Name , ProductImg_Date , ProductImg_Time
ProductImg_Sort , ProductImg_Status
FROM product_img
WHERE Product_ID = '$ProductID'
";
$objQuery_imglist = $objConnect->query($sql_img_list);
$objQuery_imglist2 = $objConnect->query($sql_img_list);
$CHK_imglist = mysqli_num_rows($objQuery_imglist);
$SQL_ProductOptions = "
SELECT ProductOptions_ID , ProductOptions_Name, ProductOptions_Date , ProductOptions_Time ,
Product_ID , StatusProductOptions_ID , ProductOptions_Price
FROM product_options
WHERE Product_ID = $ProductID AND
StatusProductOptions_ID = 1
ORDER BY ProductOptions_Name
";
?>
query($SQL_product);
while ($objResult_product = mysqli_fetch_array($objQuery_product)) {
$ProductDetail = $objResult_product["Product_Detail"];
$ProductDetail2 = $objResult_product["Product_Detail2"];
$ProductDetail3 = $objResult_product["Product_Detail3"];
$ProductUnit = $objResult_product["Product_Unit"];
$ProductDetail2 = str_replace("repair-fitness","repairsfitness",$ProductDetail2);
$ProductID = $objResult_product["Product_ID"];
$ProductName = $objResult_product["Product_Name"];
$ProductImg = $objResult_product["Product_Img"];
$ProductPrice = $objResult_product["Product_Price"];
$ProductDate = $objResult_product["Product_Date"];
$NewformatProductPrice = number_format((float) $ProductPrice, 2, '.', ',');
$ProductDate_Create = date_create($ProductDate);
$ProductDate_New = date_format($ProductDate_Create, "F d , Y");
$sql_img_list = "
SELECT ProductImg_ID , Product_ID , ProductImg_Name , ProductImg_Date , ProductImg_Time
ProductImg_Sort , ProductImg_Status
FROM product_img
WHERE Product_ID = '$ProductID'
";
$objQuery_imglist = $objConnect->query($sql_img_list);
$objQuery_imglist2 = $objConnect->query($sql_img_list);
$CHK_imglist = mysqli_num_rows($objQuery_imglist);
$SQL_ProductOptions = "
SELECT ProductOptions_ID , ProductOptions_Name, ProductOptions_Date , ProductOptions_Time ,
Product_ID , StatusProductOptions_ID , ProductOptions_Price
FROM product_options
WHERE Product_ID = $ProductID AND
StatusProductOptions_ID = 1
ORDER BY ProductOptions_Name
";
?>
