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;
