Exemplo n.º 1
0
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);
}
Exemplo n.º 2
0
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;
}