function add_info() { $food_name = $_POST['food_name']; $food_description = $_POST['food_description']; $regular_price = $_POST['regular_price']; $sale_price = $_POST['sale_price']; $cyclone_price = $_POST['cyclone_price']; $category_id = $_POST['category_id']; $sale_start_date = $_POST['sale_start_date']; $sale_end_date = $_POST['sale_end_date']; $current_date = date("Y-m-d"); $current_date = date("Y-m-d", strtotime($current_date)); $sale_start = date("Y-m-d", strtotime($_POST['sale_start_date'])); $sale_end = date("Y-m-d", strtotime($_POST['sale_end_date'])); $cyclone_card = $_POST['cyclone_card']; if (ucfirst($cyclone_card) == "Yes") { $cyclone_card = 1; } else { if (ucfirst($cyclone_card) == "No") { $cyclone_card = 0; } } $sql = "INSERT INTO food SET\n\t\t\t\t\tfood_name = '" . $food_name . "',\n\t\t\t\t\tfood_description = '" . $food_description . "',\n\t\t\t\t\tregular_price = '" . $regular_price . "',\n\t\t\t\t\tsale_price = '" . $sale_price . "',\n\t\t\t\t\tsale_start_date = '" . format_date_update($sale_start_date) . "',\n\t\t\t\t\tsale_end_date = '" . format_date_update($sale_end_date) . "',"; if ($current_date >= $sale_start && $current_date <= $sale_end) { $sql .= " on_sale = '1', "; } else { $sql .= " on_sale = '0', "; } $sql .= "cyclone_card_price = '" . $cyclone_price . "',\n\t\t\t\t\tcyclone_card_item = '" . $cyclone_card . "',\n\t\t\t\t\tcategory_id = '" . $category_id . "'"; $result = mysql_query($sql); $id = mysql_insert_id(); //Insert into sales_history table if item was on sale. if ($current_date >= $sale_start && $current_date <= $sale_end) { insert_sales_table($id); } echo " \n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\twindow.location.href = 'upload.php?id=" . $id . "';\n\t\t\t\t\t\t</script>\n\t\t\t\t\t"; }
function update_info($id) { $food_name = $_POST['food_name']; $food_description = $_POST['food_description']; $regular_price = $_POST['regular_price']; $sale_price = $_POST['sale_price']; $category_id = $_POST['category_id']; $sale_start_date = $_POST['sale_start_date']; $sale_end_date = $_POST['sale_end_date']; $current_date = date("Y-m-d"); $current_date = date("Y-m-d", strtotime($current_date)); $sale_start = date("Y-m-d", strtotime($_POST['sale_start_date'])); $sale_end = date("Y-m-d", strtotime($_POST['sale_end_date'])); $cyclone_card = $_POST['cyclone_card']; if (ucfirst($cyclone_card) == "Yes") { $cyclone_card = 1; } else { if (ucfirst($cyclone_card) == "No") { $cyclone_card = 0; } } $cyclone_card_price = $_POST['cyclone_card_price']; $sql = "UPDATE food SET\n\t\t\t\t\tfood_name = '" . $food_name . "',\n\t\t\t\t\tfood_description = '" . $food_description . "',\n\t\t\t\t\tregular_price = '" . $regular_price . "',\n\t\t\t\t\tcyclone_card_item = '" . $cyclone_card . "',\n\t\t\t\t\tcyclone_card_price = '" . $cyclone_card_price . "',\n\t\t\t\t\tsale_price = '" . $sale_price . "',\n\t\t\t\t\tsale_start_date = '" . format_date_update($sale_start_date) . "',\n\t\t\t\t\tsale_end_date = '" . format_date_update($sale_end_date) . "',"; if ($current_date >= $sale_start && $current_date <= $sale_end) { $sql .= " on_sale = '1', "; insert_sales_table($id); } else { $sql .= " on_sale = '0', "; } $sql .= "category_id = '" . $category_id . "'\n\t\t\t\t\tWHERE\n\t\t\t\t\tfood_id = " . $id; $result = mysql_query($sql); echo " \n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\twindow.location.href = 'food_inventory.php?page=1';\n\t\t\t\t\t\t</script>\n\t\t\t\t\t"; }