function getSavedRectangles() { return DbHelper::select(Rectangle::DB_TABLE, array(Rectangle::DB_COL_TOP_A, Rectangle::DB_COL_LEFT_A, Rectangle::DB_COL_TOP_B, Rectangle::DB_COL_LEFT_B)); }
<?php $app->get('/courses', function () { $db = new DbHelper(); $columns = "ID,title,description,price,start_date,end_date,max_number_of_students,ID_subject"; $table = "course"; $where = array(); $orwhere = array(); //$limit = 1; $result = $db->select($table, $columns, $where, $orwhere); echoResponse(200, $result); });
echoResponse(200, $response); }); $app->post('/signUp', function () use($app) { $response = array(); $r = json_decode($app->request->getBody()); verifyRequiredParams(array('email', 'nickname', 'password'), $r->user); require_once 'passwordHash.php'; $db = new DbHelper(); $nickname = $r->user->nickname; $email = $r->user->email; $password = $r->user->password; $columns = 'ID,nickname,password,email,created'; $table = 'user'; $where = ""; $orwhere = ""; $isUserExists = $db->select($table, $columns, $where, $orwhere, '1'); if (!$isUserExists) { $r->user->password = passwordHash::hash($password); $table_name = "user"; $column_names = array('nickname', 'email', 'password'); $result = $db->insertIntoTable($r->user, $column_names, $table_name); if ($result != NULL) { $response["status"] = "success"; $response["message"] = "User account created successfully"; $response["ID"] = $result; if (!isset($_SESSION)) { session_start(); } $_SESSION['ID'] = $response["ID"]; $_SESSION['nickname'] = $nickname; $_SESSION['email'] = $email;