function insert_sales_table($id) { $sale_price = $_POST['sale_price']; $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'])); $sql = "INSERT INTO sales_history SET\n\t\t\t\t\tfood_id = '" . $id . "',\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) . "'"; $result = mysql_query($sql); }
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']; $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) . "',\n\t\t\t\t\tcategory_id = '" . $category_id . "'\n\t\t\t\t\tWHERE\n\t\t\t\t\tfood_id = " . $id; $result = mysql_query($sql); //header("LOCATION: food_inventory.php"); echo $sql; }