$h_fail = "Unit: " . $ut_id . " Not Added"; database($sql, $h_success, $h_fail); } //---------------------------------------------- Add Billing Plan --------------------------------------------------------------------------- function add_plan($bill_plan, $name, $years, $roi) { $sql = "INSERT INTO bill_plan (bill_plan, name, no_years, roi, cr_dt)\nVALUES ('{$bill_plan}', '{$name}', '{$years}', '{$roi}', now());"; $h_success = "Billing Plan: " . $desc . " Added Successfully"; $h_success = "<script type='text/javascript'>alert('{$h_success}');</script>"; $h_fail = "Billing Plan: " . $bill_plan . " Not Added"; database($sql, $h_success, $h_fail); } switch ($_POST[add]) { case "tower": unset($msg); add_tower($_POST['tw_id'], $_POST['desc']); break; //add tower //add tower case "type": unset($msg); add_type($_POST[type_id], $_POST[desc], $_POST[tw_id], $_POST[price]); break; //add type //add type case "unit": unset($msg); add_unit($_POST[ut_id], $_POST[type], $_POST[tw_id], $_POST[floor], $_POST[area]); break; //add unit //add unit
$h_success = "Type " . $desc . " Added Successfully"; $h_fail = "Location:reg_fail.php"; database($sql, $h_success, $h_fail); } //---------------------------------------------- Add Unit ------------------------------------------------------------------------------- function add_unit($ut_id, $type, $tw_id, $floor, $area) { $sql = "INSERT INTO unit (ut_id, type, tw_id, floor, area, cr_dt)\nVALUES ('{$ut_id}', '{$type}', '{$tw_id}', '{$floor}', '{$area}', now());"; $h_success = "Unit " . $ut_id . " Added Successfully"; $h_fail = "Location:reg_fail.php"; database($sql, $h_success, $h_fail); } switch ($_POST[action]) { case "add_tower": unset($msg); add_tower($_POST[tw_id], $_POST[desc]); break; //add tower //add tower case "add_type": unset($msg); add_type($_POST[type_id], $_POST[desc], $_POST[tw_id], $_POST[price]); break; //add type //add type case "add_unit": unset($msg); add_unit($_POST[ut_id], $_POST[type], $_POST[tw_id], $_POST[floor], $_POST[area]); break; //add unit //case "disp_unit" : unset($msg); disp_unit(); break; //display unit