$feature = $_POST['updFeature']; $id = $_POST['featureID']; updateFeature($feature, $id); } elseif (isset($_POST['advantageID'])) { $id = $_POST['advantageID']; $adv = $_POST['updAdvantage']; updateAdvantage($adv, $id); } elseif (isset($_POST['addNewShift'])) { $shift = $_POST['addNewShift']; $time = $_POST['addNewTime']; addSchedule($shift, $time); $id = getScheduleID($shift, $time); echo $id; } elseif (isset($_POST['scheduleID'])) { $id = $_POST['scheduleID']; deleteSchedule($id); } elseif (isset($_POST['addNewFeature'])) { $desc = $_POST['addNewFeature']; addFeature($desc); $id = getFeatureID($desc); echo $id; } elseif (isset($_POST['featureID'])) { $id = $_POST['featureID']; deleteFeature($id); } elseif (isset($_POST['addNewAdvantage'])) { $advantage = $_POST['addNewAdvantage']; addAdvantages($advantage); $resp['advKey'] = getAdvantageID($advantage); echo json_encode($resp); } elseif (isset($_POST['advID'])) { $Aid = $_POST['advID'];
<?php include 'db_helper.php'; if ($_GET['f'] == 'add' && $_GET['p1'] && $_GET['p2'] && $_GET['p3'] && $_GET['p4']) { addSchedule($_GET['p1'], $_GET['p2'], $_GET['p3'], $_GET['p4']); } elseif ($_GET['f'] == 'get' && $_GET['p1']) { getSchedule($_GET['p1']); } elseif ($_GET['f'] == 'del' && $_GET['p1'] && $_GET['p2'] && $_GET['p3'] && $_GET['p4']) { deleteSchedule($_GET['p1'], $_GET['p2'], $_GET['p3'], $_GET['p4']); } function addSchedule($TID, $Day, $Start, $End) { $dbQuery = sprintf("INSERT INTO Schedule (TID,Day,Start,End) VALUES ('%d','%s','%d','%d')", $TID, mysql_real_escape_string($Day), $Start, $End); $result = getDBResultInserted($dbQuery, 'TID'); //header("Content-type: application/json"); echo json_encode($result); } function deleteSchedule($TID, $Day, $Start, $End) { $dbQuery = sprintf("DELETE from Schedule WHERE TID ='%d', Day='s%', Start='%d', End='%d'", $TID, mysql_real_escape_string($Day), $Start, $End); $result = getDBResultInserted($dbQuery, 'TID'); //header("Content-type: application/json"); echo json_encode($result); } function getSchedule($TID, $Day, $Start, $End) { $dbQuery = sprintf("SELECT * from Schedule WHERE TID ='%d'", $TID, mysql_real_escape_string($Day), $Start, $End); $result = getDBResultInserted($dbQuery, 'TID'); //header("Content-type: application/json"); echo json_encode($result); }