public static function calcularPercentilMargens($imc, $sexo, $nascimento) { $curva = new Curva(); // Margens dos percentis baseado no cálculo inicial. $margemIMCInferior = $imc - MARGEM_LIMITE_PERCENTIL; $margemIMCSuperior = $imc + MARGEM_LIMITE_PERCENTIL; // Valores crescentes e decrescentes do IMC. $imcDecrescente = $imc; $imcCrescente = $imc; $idadeMeses = DataUtil::calcularIdadeMeses($nascimento); $db = new DbHandler(); // Verificação do percentil inferior. $percentilInferior = NULL; while (empty($percentilInferior) && $imcDecrescente >= $margemIMCInferior) { // Decrescer gradativamente os valores do IMC na escala. $imcDecrescente = $imcDecrescente - ESCALA_IMC_PERCENTIL; $percentilInferior = $db->selecionarPercentil($imcDecrescente, $sexo, $idadeMeses); } $curva->setPercentilInferior($percentilInferior); // Verificação do percentil superior. $percentilSuperior = NULL; while (empty($percentilSuperior) && $imcCrescente <= $margemIMCSuperior) { // Crescer gradativamente os valores do IMC na escala. $imcCrescente = $imcCrescente + ESCALA_IMC_PERCENTIL; $percentilSuperior = $db->selecionarPercentil($imcCrescente, $sexo, $idadeMeses); } $curva->setPercentilSuperior($percentilSuperior); return $curva; }
/** * Checking if the request has valid api key in the "Authorization" header */ function authenticate(\Slim\Route $route) { $headers = apache_request_headers(); $response = array(); $app = \Slim\Slim::getInstance(); if (isset($headers["Authorization"])) { $db = new DbHandler(); $api_key = $headers["Authorization"]; $user = $db->isValidApiKey($api_key); if ($user == null) { $response["error"] = true; $response["message"] = "Access Denied. Invalid Api key"; echoResponse(FAILURE_CODE, $response); $app->stop(); } else { global $user_name; $user_name = $user; } } else { $response["error"] = true; $response["message"] = "Api key is misssing"; echoResponse(404, $response); $app->stop(); } }
/** * Adding Middle Layer to authenticate every request * Checking if the request has valid api key in the 'Authorization' header */ function authenticate(\Slim\Route $route) { // Getting request headers $headers = apache_request_headers(); $response = array(); $app = \Slim\Slim::getInstance(); // Verifying Authorization Header if (isset($headers['Authorization'])) { $db = new DbHandler(); // get the api key $api_key = $headers['Authorization']; // validating api key if (!$db->isValidApiKey($api_key)) { // api key is not present in users table $response["error"] = true; $response["message"] = "Access Denied. Invalid Api key"; echoRespnse(401, $response); $app->stop(); } else { global $user_id; // get user primary key id $user_id = $db->getUserId($api_key); } } else { // api key is missing in header $response["error"] = true; $response["message"] = "Api key is misssing"; echoRespnse(400, $response); $app->stop(); } }
function doLog($Mesaj) { $db = new DbHandler(); $useragent = $_SERVER["HTTP_USER_AGENT"]; $IPAdres = $_SERVER["REMOTE_ADDR"]; $db->Log($IPAdres, $useragent, $Mesaj); }
public function notifyAdmins($id, $title, $description, $author, $email, $time = "", $geo = "", $source = "") { $dbHandler = new DbHandler(); $emails = $dbHandler->getAdminsEmails(); if (count($emails) == 0) { return; } $emails_comma_separated = $this->recieversString($emails); $subject = $this->constructEmailSubject($id); $body = $this->constructEmailBody($id, $title, $description, $author, $email, $time, $geo, $source); $headers = $this->makeHeaders(); mail($emails_comma_separated, $subject, $body, $headers); }
function getTable() { $db = new DbHandler(); $result = $db->getEbookAll(); $response["error"] = false; $response["ebooks"] = array(); $allEbooksArray = array(); if ($result != null) { while ($row = $result->fetch_assoc()) { $allEbooksArray[] = array("Id" => $row['id'], "nazwa" => $row['nazwa'], "opis" => $row['opis'], "dane" => $row['dane']); } } $this->allEbooksArray = $allEbooksArray; }
protected static function getUserId($username) { $conn = DbHandler::getConnection(); $query = "SELECT id FROM users WHERE username = '******'"; $user_id = $conn->querySingle($query); return $user_id; }
public static function insertMessage($user_id, $chat_id, $message) { $conn = DbHandler::getConnection(); $query = "INSERT INTO messages (chat_id, user_id, message, insert_time) " . "VALUES (" . $conn->escapeString($chat_id) . ", " . $conn->escapeString($user_id) . ", '" . $conn->escapeString($message) . "', " . $conn->escapeString(getMicrotime()) . ")"; $conn->exec($query); UserHandler::setUserActivity(); return true; }
function __construct() { parent::__construct(); try { $this->handler = new mysqli($this->hostname, $this->username, $this->password, $this->schema); if ($this->handler->connect_error) { throw new Exception('DB Connection Error'); } } catch (Exception $exception) { echo 'Cannot connect to selected DB: ' . $exception->getMessage() . "\n"; } $this->handler->autocommit(FALSE); }
$sheet = $objPHPExcel->getActiveSheet(); $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); // Loop through each row of the worksheet in turn $array['cols'][] = array('type' => 'date', 'id' => 'date', 'label' => 'Date'); $array['cols'][] = array('type' => 'number', 'id' => 'Theorique', 'label' => 'Théorique'); $array['cols'][] = array('type' => 'number', 'id' => 'Centres_ouverts', 'label' => 'Centres ouverts'); $array['cols'][] = array('type' => 'number', 'id' => 'Centres_actifs', 'label' => 'Centres actifs'); for ($row = 2; $row <= $highestRow; $row++) { $array['rows'][] = array('c' => array(array('v' => 'Date(' . date('Y, m , j', strtotime('-1 month', strtotime(date('Y-m-j', PHPExcel_Shared_Date::ExcelToPHP($sheet->getCellByColumnAndRow(0, $row)->getValue()))))) . ')'), array('v' => $sheet->getCellByColumnAndRow('1', $row)->getValue()), array('v' => $sheet->getCellByColumnAndRow('2', $row)->getValue()), array('v' => $sheet->getCellByColumnAndRow('3', $row)->getValue()))); } echoResponse(200, $array); } }); $app->get('/etude/:id/courbe/patient', function ($id) { $db = new DbHandler(); $query = "SELECT laboratoire.libelle as lab,etude.libelle as et FROM etude , laboratoire WHERE etude.id_laboratoire=laboratoire.id and etude.id={$id}"; $response = $db->execute($query); foreach ($response as &$value) { $rep = "../../data/" . $value['lab'] . "/" . $value['et'] . "/Courbe_Patients.xlsx"; } date_default_timezone_set('Europe/Paris'); $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objReader->setReadDataOnly(true); if (file_exists($rep)) { $objPHPExcel = $objReader->load($rep); $sheet = $objPHPExcel->getActiveSheet(); $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); // Loop through each row of the worksheet in turn $array['cols'][] = array('type' => 'date', 'id' => 'date', 'label' => 'Date');
<?php require_once '../include/DbHandler.php'; require_once '../include/PassHash.php'; require '.././libs/Slim/Slim.php'; define('DB_HOST', 'localhost'); define('DB_NAME', 'task_manager'); define('DB_USER', 'vyk'); define('DB_PASSWORD', 'navneeta'); $con = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error()); $db = mysql_select_db(DB_NAME, $con) or die("Failed to connect to MySQL: " . mysql_error()); $u = $_POST['user']; $p = $_POST['pass']; $db = new DbHandler(); // check for correct email and password if ($db->checkLogin($email, $password)) { // get the user by email $user = $db->getUserByEmail($email); if ($user != NULL) { echo "SUCCESSFULLY LOGIN TO USER PROFILE PAGE..."; } else { echo "SORRY... YOU ENTERD WRONG ID AND PASSWORD... PLEASE RETRY..."; } }
$pdf->Open(); $pdf->AddPage(); $pdf->SetMargins(5, 3, 5); // margen, left, top y right //$pdf->Ln(03); //$pdf->SetWidths(array(65, 60, 55, 50, 20)); $pdf->SetFont('Arial', 'B', 8); $pdf->SetFillColor(85, 107, 47); $pdf->SetTextColor(0); $pdf->ln(); // $response = array(); $lisPreguntas = json_decode($app->request->getBody()); $idUser = intval($_SESSION['uid']); $lista = implode(",", $lisPreguntas); $db = new DbHandler(); $impresas = $db->get1Record("select fn_num_respuesta_print( '{$lista}' ) as cantidad"); //var_dump($impresas); if ($impresas['cantidad'] == 0) { // genera las respuestas en el documento PDF // $target_dir = $_SERVER['DOCUMENT_ROOT'] . "/server/uploaded_files/"; // registra el nuevo lote de preguntas impresas // insert into pyr_respuesta_print ( id, fecha, id_usuario ) values ( now(), now(), 12 ); $idLote = $db->get1Record("select fn_ins_pyr_respuesta_print( {$idUser} ) as id"); if ($idLote != NULL && $idLote > 0) { $ok = true; foreach ($lisPreguntas as $respuesta) { // registra el detalle de preguntas incluidas en el lote // insert into pyr_respuesta_print_det ( id_print, id_pregunta ) values ( '2015-11-13 01:04:40', 63 ); if ($ok == true) { $idDet = $db->get1Record("select fn_ins_pyr_respuesta_print_det( '" . $idLote['id'] . "', {$respuesta} ) as idDet");
} }); $app->post('/resetPassword', function () use($app) { require_once 'passwordHash.php'; $response = array(); $r = json_decode($app->request->getBody()); $password_non = $r->password; if (strtolower($password) == $password_non) { $response["status"] = "error"; $response["message"] = "Need at least 1 capital letter in password"; echoResponse(201, $response); $app->stop(); } if (!preg_match('/[0-9]+/', $password_non)) { $response["status"] = "error"; $response["message"] = "Need at least 1 number in password"; echoResponse(201, $response); $app->stop(); } $password = passwordHash::hash($password_non); $key = $r->key; $db = new DbHandler(); $dbemail = $db->getOneRecord("select email from confirm where validation_key='{$key}'"); $email = $dbemail['email']; $dbuid = $db->getOneRecord("select uid from users where email='{$email}'"); $uid = $dbuid['uid']; $db->updateOneRecord("update users set password = '******' where uid='{$uid}'"); $response["status"] = "success"; $response["message"] = "Account password sucessfully reset."; echoResponse(200, $response); });
<?php include_once "utility.php"; include_once "db.php"; /** * Created by PhpStorm. * User: Steve * Date: 9/22/14 * Time: 8:09 PM */ $user = "******"; $pw = "Zero"; if (strtolower($_POST['user_name']) != $user || $_POST['user_password'] != $pw) { exit("INVALID CREDENTIALS"); } $week = $_POST["week"]; $scorecard = $_POST["scorecard"]; if ($scorecard == 'true') { $scorecard = 1; } else { $scorecard = 0; } $news1 = $_POST["news1"]; $news2 = $_POST["news2"]; $news3 = $_POST["news3"]; $db = new DbHandler(); $db->insertVariables($week, $scorecard, $news1, $news2, $news3); exit("Status: Content inserted successfully");
$response["message"] = array(); // looping through result and preparing tasks array while ($project = $result->fetch_assoc()) { $tmp = array(); $tmp["nombre"] = $project["nombre"]; $tmp["socialID"] = $project["socialID"]; $tmp["proyectoID"] = $project["proyectoID"]; $tmp["comentario"] = $project["comentario"]; $tmp["fecha_comentario"] = $project["fecha_comentario"]; array_push($response["message"], $tmp); } echoRespnse(200, $response); }); $app->post('/donar', function () use($app) { $response = array(); $db = new DbHandler(); // fetching all user tasks $result = $db->getAllProjects(); $response["error"] = false; $response["message"] = array(); // looping through result and preparing tasks array while ($project = $result->fetch_assoc()) { $tmp = array(); $tmp["nombre"] = $project["nombre"]; $tmp["descripcionLarga"] = $project["descripcion_larga"]; $tmp["descripcionCorta"] = $project["descripcion_corta"]; $tmp["monto"] = $project["monto"]; $tmp["diasVigencia"] = $project["diasvigencia"]; $tmp["proyectoID"] = $project["proyectoID"]; $tmp["categoria"] = $project["categoria"]; $tmp["ciudad"] = $project["ciudad"];
<?php require_once '../include/DbHandler.php'; $db = new DbHandler(); $result = $db->crearRespuesta("Hola hola bla bla", 6, 1); if (is_null($result)) { echo "Es NULL"; } else { print_r($result); }
if ($datos != NULL) { $response['data'] = $datos; $response['status'] = "success"; $response['message'] = ''; } else { $response['status'] = "info"; $response['message'] = 'No hay municipios'; } echoResponse(200, $response); }); // Opción para actualizar un registro de la tabla cat_municipio // Opción para eliminar un registro de la tabla cat_municipio $app->get('/municipioD/:id', 'sessionAlive', function ($id) use($app) { // Recupera los datos de la forma // $response = array(); // // $db = new DbHandler(); $resId = $db->deleteRecord("call sp_del_cat_municipio(?)", $id); if ($resId == 0) { $response['status'] = "success"; $response['message'] = 'Datos eliminados'; } else { if ($resId < 0) { $response['status'] = "error " . $resId; $response['message'] = 'No pudo eliminar los Datos'; } } echoResponse(200, $response); });
<?php include './include/DbHandler.php'; $db = new DbHandler(); header('Content-Type: application/json'); $response = array(); $response["error"] = false; if (isset($_POST['mobile']) && $_POST['mobile'] != '') { $mobile = $_POST['mobile']; $result = $db->logoutUser($mobile); if ($result != NULL) { $response["message"] = "User Logged out successfully!"; } else { $response["error"] = true; $response["message"] = "Sorry! Failed to Logout your account."; } } else { $response["error"] = true; $response["message"] = "Sorry! Mobile is missing."; } echo json_encode($response);
$db = new DbHandler(); $res = $db->addProject($name, $start_date, $end_date, $description, $team_lead, $target_audience, $estimated_funds); if ($res != PROJECT_CREATE_FAILED) { $response["error"] = false; $response["message"] = "project successfully registered with id" + $res; echoRespnse(201, $response); } else { $response["error"] = TRUE; $response["message"] = "oops! an error occured while registering project"; echoRespnse(200, $response); } }); $app->get('/projects/:id', function ($project_id) { global $user_id; $response = array(); $db = new DbHandler(); // fetch project $result = $db->getProject($project_id); if ($result != NULL) { $response["error"] = false; $response["id"] = $result["id"]; $response["name"] = $result["name"]; $response["start_date"] = $result["start_date"]; $response["end_date"] = $result["end_date"]; $response["description"] = $result["description"]; $response["team_lead"] = $result["team_lead"]; $response["estimated_funds"] = $result["estimated_funds"]; echoRespnse(200, $response); } else { $response["error"] = true; $response["message"] = "The requested resource doesn't exists";
<?php /** * Register a new user * * By Kai Rune Orten */ $app->post('/register', function () use($app) { $r = json_decode($app->request->getBody()); verifyRequiredParams(array('phone', 'birth'), $r->user); validateRequest($r->user); $db = new DbHandler(); $tabble_name = "user"; $phone = $r->user->phone; $birth = $r->user->birth; //We need to format the date to MySQL standard yyyy-mm-dd. $r->user->birth = Date('Y-m-d', strtotime($birth)); //If we dont care if the user register multiple time, remove the following function and condition $userExists = $db->getOneRecord("select 1 from {$tabble_name} where phone='{$phone}'"); if (!$userExists) { $column_names = array('first_name', 'last_name', 'email', 'phone', 'birth'); $result = $db->insertIntoTable($r->user, $column_names, $tabble_name); if ($result !== NULL) { $response["status"] = "success"; $response["message"] = array("Registrering fullført"); echoResponse(200, $response); } else { $response["status"] = "error"; $response["message"] = array("En feil oppstod i registreringen, vennligst prøv igjen"); echoResponse(200, $response); }
var_dump($qid); var_dump($iscorrect);*/ $db = new DbHandler(); $res = $db->submitAnswer($input); if ($res == 0) { $response = array("error" => false, "message" => "successful insert"); echoResponse(201, $response); } else { if ($res == 1) { $response = array("error" => true, "message" => "failed to insert user response"); echoResponse(200, $response); } } }); $app->get('/lumitrivia/usersubmit/:username', function ($username) use($app) { $db = new DbHandler(); $res = $db->getSubmissionsByUsername($username); if ($res == 1) { $response = array("error" => true, "message" => "failed getting user submissions"); echoResponse(201, $response); } else { echoResponse(200, $res); } }); /** * Verifying required params posted or not */ function verifyRequiredParams($required_fields) { $error = false; $error_fields = "";
} $response["message"] = "Query Successful"; } else { $response["error"] = true; $response["message"] = "One or more field(s) missing or invalid."; } echoResponse(200, $response); }); /* * NOTIFICATION RELATED METHODS * */ $app->get('/allnotifications', function () use($app) { $response = array(); $userId = $app->request()->get('userId'); $db = new DbHandler(); //echo "testing"; // fetching all user tasks $result = $db->getAllNotifications($userId); // looping through result and preparing updates array if ($result) { $response["error"] = false; $response["notifications"] = array(); $notification = $result->fetch_assoc(); if ($notification == NULL) { $response["message"] = "No Notifications Found"; echoResponse(200, $response); return; } // looping through result and preparing updates array while ($notification) {
$datos = $db->getAllRecord("call sp_sel_cat_ice( )"); //var_dump($datos); if ($datos != NULL) { $response = $datos; } else { $response['status'] = "info"; $response['message'] = "No hay ICE's"; } echoResponse(200, $response); }); // Opción para actualizar un registro de la tabla cat_ice // Opción para eliminar un registro de la tabla cat_ice $app->get('/iceD/:id', 'sessionAlive', function ($id) use($app) { // Recupera los datos de la forma // $response = array(); // // $db = new DbHandler(); $resId = $db->deleteRecord("call sp_del_cat_ice(?)", $id); if ($resId == 0) { $response['status'] = "success"; $response['message'] = 'Datos eliminados'; } else { if ($resId < 0) { $response['status'] = "error " . $resId; $response['message'] = 'No pudo eliminar los Datos'; } } echoResponse(200, $response); });
<?php include './include/DbHandler.php'; $db = new DbHandler(); header('Content-Type: application/json'); $response = array(); if (isset($_POST['mobile']) && $_POST['mobile'] != '') { $name = $_POST['name']; $vehicle_reg_no = $_POST['vehicle_reg_no']; $mobile = $_POST['mobile']; $otp = rand(100000, 999999); $res = $db->createUser($name, $vehicle_reg_no, $mobile, $otp); if ($res == USER_CREATED_SUCCESSFULLY) { // send sms sendSms($mobile, $otp); $response["error"] = false; $response["message"] = "SMS request is initiated! You will be receiving it shortly."; } else { if ($res == USER_CREATE_FAILED) { $response["error"] = true; $response["message"] = "Sorry! Error occurred in registration."; } else { if ($res == USER_ALREADY_EXISTED) { $response["error"] = true; $response["message"] = "Mobile number already existed!"; } } } } else { $response["error"] = true; $response["message"] = "Sorry! mobile number is not valid or missing.";
$result = $db->insertIntoTable($r->user, $column_names, $tabble_name); if ($result != NULL) { $response["status"] = "success"; $response["message"] = "User account created successfully"; $response["uid"] = $result; if (!isset($_SESSION)) { session_start(); } $_SESSION['uid'] = $response["uid"]; $_SESSION['phone'] = $phone; $_SESSION['name'] = $name; $_SESSION['email'] = $email; echoResponse(200, $response); } else { $response["status"] = "error"; $response["message"] = "Failed to create user. Please try again"; echoResponse(201, $response); } } else { $response["status"] = "error"; $response["message"] = "An user with the provided phone or email exists!"; echoResponse(201, $response); } }); $app->get('/logout', function () { $db = new DbHandler(); $session = $db->destroySession(); $response["status"] = "info"; $response["message"] = "Logged out successfully"; echoResponse(200, $response); });
/** * Get revision data of a particular generator ID * @param String $name nameString of User in database * method GET * url /names/name */ function getAnImplementedDateGenRevision($date, $genID, $revId) { $response = array(); $db = new DbHandler(); if ($revId == 'count' && !is_numeric($revId)) { $result = $db->getImplementedDateGenRevisionCount($date, $genID); if (gettype($result) == "string") { $response["error"] = true; $response["message"] = $result; } else { $response["error"] = false; $response["count"] = $result->fetch_assoc()['count']; } echoResponse(200, $response); } else { if ($revId == 'latest' && !is_numeric($revId)) { $result = $db->getImplementedDateRevisionCount($date); if (gettype($result) == "string") { $response["error"] = true; $response["message"] = $result; echoResponse(200, $response); } else { $count = $result->fetch_assoc()['count']; getAnImplementedDateGenRevision($date, $genID, $count); } } else { if (is_numeric($revId) || $revId == null) { // fetching all users with a particular name $result = $db->getAnImplementedDateGenRevisionData($date, $genID, $revId); //$result1 = $db->getAnImplementedDateGenRevisionParams($date, $revId); if (gettype($result) == "string") { $response["error"] = true; $response["message"] = $result; } else { $response["error"] = false; $response["revNumber"] = $revId; $response["date"] = $date; $response["revData"] = array(); // looping through result and preparing names array while ($task = $result->fetch_assoc()) { $tmp = array(); $tmp["p_id"] = $task["p_id"]; $tmp["from_b"] = $task["from_b"]; $tmp["to_b"] = $task["to_b"]; $tmp["cat"] = $task["cat"]; $tmp["val"] = $task["val"]; array_push($response["revData"], $tmp); } // looping through result and preparing names array /*while ($task = $result1->fetch_assoc()) { $response["comment"] = $task["comment"]; $response["TO"] = $task["time"]; }*/ } echoResponse(200, $response); } else { $response["error"] = true; $response["message"] = "Invalid Revision data request url"; echoResponse(200, $response); } } } }
$datos = $db->getAllRecord("call sp_sel_sip_tipo_precalificado( )"); //var_dump($datos); if ($datos != NULL) { $response = $datos; } else { $response['status'] = "info"; $response['message'] = 'No hay sectores'; } echoResponse(200, $response); }); // Opción para actualizar un registro de la tabla sip_tipo_precalificado // Opción para eliminar un registro de la tabla sip_tipo_precalificado $app->get('/tpD/:id', 'sessionAlive', function ($id) use($app) { // Recupera los datos de la forma // $response = array(); // // $db = new DbHandler(); $resId = $db->deleteRecord("call sp_del_sip_tipo_precalificado(?)", $id); if ($resId == 0) { $response['status'] = "success"; $response['message'] = 'Datos eliminados'; } else { if ($resId < 0) { $response['status'] = "error " . $resId; $response['message'] = 'No pudo eliminar los Datos'; } } echoResponse(200, $response); });
$response["message"] = "Failed to create company. Please try again"; echoRespnse(200, $response); } }); /** * Updating existing company * method PUT * params company, status * url - /companies/:id */ $app->put('/companies/:id', 'authenticate', function ($company_id) use($app) { // check for required params verifyRequiredParams(array('name', 'status')); global $user_id; $name = $app->request->put('name'); $status = $app->request->put('status'); $db = new DbHandler(); $response = array(); // updating company $result = $db->updateCompany($company_id, $name, $status); if ($result) { // company updated successfully $response["error"] = false; $response["message"] = "company updated successfully"; } else { // company failed to update $response["error"] = true; $response["message"] = "company failed to update. Please try again!"; } echoRespnse(200, $response); });
$response = array(); // $db = new DbHandler(); $datos = $db->getAllRecord("call sp_sel_sip_organo( )"); //var_dump($datos); if ($datos != NULL) { $response = $datos; } else { $response['status'] = "info"; $response['message'] = 'No hay información'; } echoResponse(200, $response); }); // Opción para eliminar un registro de la tabla sip_organo $app->get('/organoD/:id', 'sessionAlive', function ($id) use($app) { $response = array(); // // $db = new DbHandler(); $resId = $db->deleteRecord("call sp_del_sip_organo(?)", $id); if ($resId == 0) { $response['status'] = "success"; $response['message'] = 'Datos eliminados'; } else { if ($resId < 0) { $response['status'] = "error " . $resId; $response['message'] = 'No pudo eliminar los Datos'; } } echoResponse(200, $response); });
public function getAll() { $dbHandler = new DbHandler(); $allSubmissions = $dbHandler->getAll(); return $allSubmissions; }