* setting the database value for stock column
*/
if ($stock > 5) {
$status = 1;
} else {
$status = 0;
}
//varriable which will contain the category in string format
$category_string = "";
if (!empty($GLOBALS['_POST']['category']) && $GLOBALS['_POST'] > 0) {
$category = $GLOBALS['_POST']['category'];
//convert array to string seperated by commas
foreach ($category as $cate) {
$category_string = $category_string . "," . $cate;
}
/*
- remove the first word from the $category_string sa it
- it contains a comma
*/
$category_string = substr($category_string, 1);
}
//discount is set or not
if (!empty($discount)) {
//insert values in product table
$result = $manageData->insertCoupon($coupon_id, $category_string, $coupon_name, $description, $references, $coupon_code, $old_price, $price_guest, $price_members, $tax, $discount, $stock, $date, $expiration_date, $maxpick, $status, $photo_name, $photo_name1, $photo_name2, $photo_name3, $photo_name4);
if ($result == 1) {
header("Location: ../../addCoupon.php?msg=1111");
}
} else {
header("Location: ../../addCoupon.php?msg=9999");
}