function rest_get($req) { global $JSON; if (checkPrivileges($req[0]) == false) { return; } $resp = reqRouter($req, "GET"); $response; switch ($resp) { case 1: global $routes; $order = @$routes[$req[0]]["orderBy"]; if (isset($order)) { $response = sql_GET_ALL($req[0], [$order, "ASC"]); } else { $response = sql_GET_ALL($req[0], [$routes[$req[0]]['identifier'], "ASC"]); } break; case 2: $response = sql_GET($req); break; case 3: $response = sql_GET_ROW($req); break; case 4: $response = sql_GET_SORT($req, true); break; case 5: $response = sql_GET_SORT($req, false); break; case 6: $response = sql_GET_COLUMNS(); break; case 7: $response = sql_GET_JOIN($JSON); break; case 8: $response = getPrice($JSON); break; case 9: $response = getByTime($req, $JSON); break; case 0: default: rest_error("Mal-Formed request, check url params", 400); return; } if (isset($response) && (is_array($response) && count($response) > 0)) { rest_success(json_encode($response)); } else { rest_error("Empty Results, Check if item exists in dataBase, Check Url requested.", 404); } return 0; }
function rest_delete($req) { if (checkPrivileges($req[0]) == false) { rest_error("Insufficient priveleges to DATABASE", 401); return; } $resp = reqRouter($req, "DELETE"); if ($resp == 0) { rest_error("Check URL Request, The value you are attempting to delete may not exist, check ID '" . $req[1] . "'", 400); return; } $response = sql_DELETE($req); if (isset($response)) { global $JSON; rest_success("'{$req['1']}' was deleted successfully!"); } else { rest_error("DELETION ERROR", 500); } return 0; }
function rest_post($req) { if (checkPrivileges($req[0]) == false) { rest_error("Insufficient privelege to DATABASE", 401); return; } $resp = reqRouter($req, "POST"); if ($resp == 0) { rest_error("Check URL Request, The value you are attempting to set to may already be taken, You may not be fetching the correct value or column", 400); return; } //$resp==2 user is accessing /tableName/identifier and is updating to values that are available $response = $resp == 1 ? sql_POST($req) : sql_POST_ALL($req); if (isset($response)) { global $JSON; rest_success("'{$req['1']}' Has Been Updated Successfully!"); } else { rest_error("POST ERROR Has Occurred", 500); } return 0; }
function rest_put($req) { global $routes; global $JSON; include '../../includes/database.php'; $table = $req[0]; if (checkPrivileges($table) == false || checkTableReqs($table, $JSON) == false) { rest_error("Insufficient Priveleges OR incorrect JSON Requirements", 401); return; } $ret = reqRouter($req, "PUT"); if ($ret == 0) { rest_error("Item Exists Or Incorrect JSON Properties.", 409); return; } else { if ($ret == 2) { if (!isset($JSON["OrderSymbols"])) { rest_error("NO Order received, check JSON", 406); } $list = $JSON["OrderSymbols"]; $orders = explode(" , ", $list); $arr = []; $allPossibles = sql_GET_JOIN(["tables" => ["symbols"], "from" => "ingredients", "relations" => [["symbols.Name", "ingredients.Symbol"]], "select" => ["symbols.Symbol"]]); for ($i = 0; $i < count($orders); $i++) { $ingredients = explode(" ", $orders[$i]); //from here we need to check that each ingrediant is valid and available? for ($x = 0; $x < count($ingredients); $x++) { $ingrediant = $ingredients[$x]; $num = isInside($allPossibles, "Symbol", $ingrediant); if ($num == -1) { rest_error($ingrediant . " is not a valid ingredient!", 406); return; } $cur = $allPossibles[$num]; } } $table = "orders"; $JSON["TransactionID"] = getTransaction(); } } if ($req[0] == "users") { if (!filter_var($JSON["Email"], FILTER_VALIDATE_EMAIL)) { rest_error("Invalid Email, Please Enter a Valid Email address.", 406); return; } } $stmt = $db->prepare(sql_PUT($table)); $ex = buildJSONInputWProps($table, $JSON); if (is_string($ex)) { rest_error("Property: '" . $ex . "' is not set on provided JSON Object. Your JSON May be Mal-Formed,incorrect for the database or some other error may have occured", 400); return; } $var = $stmt->execute($ex); if ($var) { rest_success('Inputted Successfully Into the DataBase!'); } else { rest_error('Input unsuccessful. Check spelling this is usually thrown when an item should match another tables item.', 406); } /* $stmt = $db->prepare(sql_PUT($req)); $stmt->execute(array(':fname' => $fname, ':lname' => $lname,':email' => $email,':pass' => $password,':verified'=>0));*/ return 0; }
switch ($method) { case 'PUT': case 'POST': case 'GET': case 'DELETE': //add $funcly = "rest_" . strtolower($method); $funcly($request); break; case 'LOGIN': $var = reqRouter($request, "LOGIN"); if ($var == 1) { rest_success("Successfully logged in..."); return; } else { if ($var == 2) { rest_success(json_encode(["location" => "signin.php"])); return; } else { rest_error("Bad request", 400); return; } } break; case 'OPTIONS': return; break; default: rest_error($request, 400); break; }