function getTransaction() { include '../../includes/database.php'; $table = "transactions"; $num = sql_GET_ALL($table, ["ID", "DESC"])[0]["ID"] + 1; $stmt = $db->prepare(sql_PUT($table)); $ex = buildJSONInputWProps($table, ["Amount" => 4.5, "Type" => 1, "ID" => $num]); $stmt->execute($ex); return $num; }
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; }