commit 2f644893700f9ff0eb356f8115ec35f3e2f0c790
parent 63ed78577b100fd58e3636f63d1c29a122700a29
Author: Friedel Schön <[email protected]>
Date: Sun, 25 Jun 2023 21:34:01 +0200
formatting and documenting
Diffstat:
22 files changed, 1504 insertions(+), 1482 deletions(-)
diff --git a/Controller/Templates.php b/Controller/Templates.php
@@ -1,125 +1,139 @@
<?php
-namespace Controller{
- class Templates{
+
+namespace Controller {
+
+ /// Controller\Templates is a utility class for creating HTML-forms and other constructs
+ class Templates
+ {
private \Lollipop\SQLDatabase $db;
private \Lollipop\DatabaseObject $table;
private string $schema = 'lollipop';
private string $table_name;
- function __construct(\Lollipop\SQLDatabase $db, \Lollipop\DatabaseObject $table){
+
+ public function __construct(\Lollipop\SQLDatabase $db, \Lollipop\DatabaseObject $table)
+ {
$this->db = $db;
$this->table = $table;
$this->table_name = $table::class;
}
- function form(string $action, array $data = [], array $response = []):string{
+ public function form(string $action, array $data = [], array $response = []): string
+ {
/*auto-increment fields are automatically hidden*/
$form_type = "Add";
$form = '<form method="POST" action="'. $action . '">';
- foreach($this->table->get_col_names_ai() as $col){
- if($data == []){
+ foreach($this->table->get_col_names_ai() as $col) {
+ if($data == []) {
$value = '-1';
- }else{
- if(in_array($col , array_keys($data)))
+ } else {
+ if(in_array($col, array_keys($data))) {
$value = $data[$col];
+ }
$form_type = "Update";
}
$form .= '<input type="hidden" name="' . $col . '" value="' . $value . '">';
}
$form .= '<input type="hidden" name="form_type" value="' . $form_type . '">';
- foreach($this->table->get_col_names_no_ai() as $col){
- if($data == []){
+ foreach($this->table->get_col_names_no_ai() as $col) {
+ if($data == []) {
$value = '';
- }else{
- if(in_array($col , array_keys($data)))
+ } else {
+ if(in_array($col, array_keys($data))) {
$value = $data[$col];
+ }
}
$form .= '<input type="text" name="' . $col . '" placeholder="' . $col . '" value="' . $value . '">';
$miss_key = 'missing_'.$col;
- if(array_key_exists($miss_key, $response)){
- $form .= '<div class="form-response"><p style="color:red;"> col: '. $col . ' cannot be empty</p></div>';
+ if(array_key_exists($miss_key, $response)) {
+ $form .= '<div class="form-response"><p style="color:red;"> col: '. $col . ' cannot be empty</p></div>';
}
}
$form .='
<input type="submit" value="'. $form_type .'">
- </form>';
-
+ </form>';
+
return $form;
}
- function form_v2(string $action, array $values = [], array $extra = [], array $response = []): string{
+ public function form_v2(string $action, array $values = [], array $extra = [], array $response = []): string
+ {
/*auto-increment fields are automatically hidden*/
- if(sizeof($values) == 0){
+ if(sizeof($values) == 0) {
$form_type = "Add";
- }else{
+ } else {
$form_type = "Update";
}
$form = '<h1>'. $form_type .' '. $this->table->get_table() .'</h1>
<a href="/'. $this->table->get_table() .'">New</a>';
$form .= '<form method="POST" action="'. $action . '">';
- foreach($this->table->get_col_info() as $col => $info){
- if(isset($info["extra"]) && $info["extra"] == "auto_increment"){
+ foreach($this->table->get_col_info() as $col => $info) {
+ if(isset($info["extra"]) && $info["extra"] == "auto_increment") {
$form .= '<input type="hidden" name="' . $col . '" placeholder="' . $col . '" value="';
- if(isset($values[$col]))
+ if(isset($values[$col])) {
$form .= $values[$col];
+ }
$form .= '">';
- }elseif(isset($info["extra"]) && $info["extra"] == "password"){
+ } elseif(isset($info["extra"]) && $info["extra"] == "password") {
$form .= '<input type="password" name="' . $col . '" placeholder="' . $col . '">';
- }elseif(isset($info["input_type"])){
+ } elseif(isset($info["input_type"])) {
$form .= '<input type="'. $info["input_type"] .'" name="' . $col . '" placeholder="' . $col . '" value="';
- if(isset($values[$col]))
+ if(isset($values[$col])) {
$form .= $values[$col];
+ }
$form .= '">';
}
$miss_key = 'missing_'.$col;
- if(array_key_exists($miss_key, $response)){
- $form .= '<div class="form-response"><p style="color:red;"> col: '. $col . ' cannot be empty</p></div>';
+ if(array_key_exists($miss_key, $response)) {
+ $form .= '<div class="form-response"><p style="color:red;"> col: '. $col . ' cannot be empty</p></div>';
}
}
- foreach($extra as $html){
+ foreach($extra as $html) {
$form.= $html;
}
$form .= '<input type="hidden" name="form_type" " value="' . $form_type . '">';
$form .='
<input type="submit" value="'. $form_type .'">
- </form>';
+ </form>';
return $form;
}
- function search_form(string $action):string{
+ public function search_form(string $action): string
+ {
return '
<form method="POST" action="'. $action . '">
<input type="text" name="search" placeholder="Search...">
<input type="submit" value="Search">
- </form>';
+ </form>';
}
- public function crud_table(string $action, string $search = "", string $search_key = "", \Model\PermissionUser $permissionUser = null):string{
- if($search == ""){
+ public function crud_table(string $action, string $search = "", string $search_key = "", \Model\PermissionUser $permissionUser = null): string
+ {
+ if($search == "") {
$search = "%";
- }else{
+ } else {
$search = "%$search%";
}
$table = "<table> <thead> <tr>";
- foreach($this->table->get_column_names() as $column){
+ foreach($this->table->get_column_names() as $column) {
$table .= "<th>$column</th>";
}
$table .= "<th>Alter</th> <th>Delete</th>";
- if($permissionUser != null){
+ if($permissionUser != null) {
$table .= "<th>user permissions</th>";
}
$table .= "</tr> </thead>";
-
+
$objs = $this->db->all_where($this->table_name, [$search_key => $search]);
$table .= "<tbody>";
- foreach($objs as $obj){
+ foreach($objs as $obj) {
$table .= "<tr>";
$col_names = $obj->get_column_names();
- foreach($col_names as $col){
+ foreach($col_names as $col) {
$table .= '<td>';
- if($col == "email" || $col == "name" || $col == "course" || $col == "exam"){
+ if($col == "email" || $col == "name" || $col == "course" || $col == "exam") {
$table .= '<a href="/'.$this->table->get_table().'/' .$obj->{$col}.'">'. $obj->{$col} . '</a></td>';
- }else{
- $table .= $obj->{$col} . '</td>';
+ } else {
+ $table .= $obj->{$col} . '</td>';
}
}
$table .= '
@@ -130,13 +144,13 @@ namespace Controller{
<a class="delete" href="' . $action . '/'. $obj->{$this->table->get_primary()} .'/delete/">Delete</a>
</td>
<td>';
- if($permissionUser != null){
- foreach($this->db->all_where(\Model\PermissionUser::class, [$permissionUser->get_primary() => $obj->{$this->table->get_primary()}]) as $perm){
+ if($permissionUser != null) {
+ foreach($this->db->all_where(\Model\PermissionUser::class, [$permissionUser->get_primary() => $obj->{$this->table->get_primary()}]) as $perm) {
$table .= $perm->id . ' ';
}
}
$table .= '</td> </tr>';
- }
+ }
$table .= "
</tbody>
@@ -144,18 +158,19 @@ namespace Controller{
return $table;
}
- function links():string{
+ public function links(): string
+ {
$links = '<div class ="links">';
- if(isset($_SESSION['user_permissions'])){
- if(in_array(1, $_SESSION['user_permissions']) || in_array(2, $_SESSION['user_permissions'])|| in_array(3, $_SESSION['user_permissions'])){
+ if(isset($_SESSION['user_permissions'])) {
+ if(in_array(1, $_SESSION['user_permissions']) || in_array(2, $_SESSION['user_permissions'])|| in_array(3, $_SESSION['user_permissions'])) {
$links .= '<a href="/user/'.$_SESSION["email"].'">My info</a>';
}
- if(in_array(2, $_SESSION['user_permissions']) || in_array(3, $_SESSION['user_permissions'])){
+ if(in_array(2, $_SESSION['user_permissions']) || in_array(3, $_SESSION['user_permissions'])) {
$links .= '<a href="/course">Courses</a>';
$links .= '<a href="/exam">Exams</a>';
$links .= '<a href="/grade">Grades</a>';
}
- if(in_array(3, $_SESSION['user_permissions'])){
+ if(in_array(3, $_SESSION['user_permissions'])) {
$links .= '<a href="/user">Users</a>';
}
}
@@ -163,14 +178,15 @@ namespace Controller{
return $links;
}
- function header():string{
+ public function header(): string
+ {
$header = "";
$header .= "<div class='header'>
<div class='box_title'>
<a href='/dashboard'>Lollipop</a>
</div>
<div class='header_middle'></div>";
- if(isset($_SESSION['user_permissions'])){
+ if(isset($_SESSION['user_permissions'])) {
$header .= "<div class='box_logout'>
<a href='/logout'>logout</a>
</div>";
@@ -180,4 +196,4 @@ namespace Controller{
}
}
-}
-\ No newline at end of file
+}
diff --git a/Lollipop/DatabaseObject.php b/Lollipop/DatabaseObject.php
@@ -1,131 +1,146 @@
<?php
namespace Lollipop {
- require_once "SQLDatabase.php";
-
- abstract class DatabaseObject
- {
- protected string $table;
- protected string $primary;
- protected array $column_names;
- protected array $not_nullable;
- protected SQLDatabase $db;
- protected array $data = [];
- protected array $changed_keys = [];
- private string $schema;
-
- function __construct(SQLDatabase $db)
- {
- $this->db = $db;
- $this->primary = $this->get_primary();
- $this->table = $this->get_table();
- $this->schema = $this->get_schema();
- }
-
- abstract static function get_primary(): string;
- abstract static function get_table(): string;
- abstract static function get_schema():string;
- public function setData($data)
- {
- $this->data = $data;
- }
- public function where(string $key, string $value)
- {
- $sql = "SELECT * FROM {$this->table} WHERE $key = ?";
- $value = array($value);
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute($value);
- $result = $stmt->get_result();
- if ($result->num_rows == 0) {
- return false;
- }
- $this->data = $result->fetch_assoc();
- return true;
- }
-
- public function where_array(array $values) : bool
- {
- $sql = "SELECT * FROM {$this->table} WHERE ";
- $params = [];
- $i = 0;
- foreach($values as $key => $param){
- if($i > 0)
- $sql .= " and ";
- $sql .= "{$key} = ?";
- $params[] = $param;
- }
-
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute($params);
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return false;
- }
-
- $this->data = $result->fetch_assoc();
- return true;
- }
- public function load(string $id): bool
- {
- /*this fuction accepts an $id value for the primary key
- * loads the row into data[]
- * returns bool if row is found
- */
- $sql = "SELECT * FROM {$this->table} WHERE {$this->primary} = ?";
-
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute([$id]);
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return false;
- }
-
- $this->data = $result->fetch_assoc();
- return true;
- }
-
- public function save() : bool
- {
- if (!$this->changed_keys)
- return false;
-
- $sql = "UPDATE {$this->table} SET ";
-
- $values = [];
- foreach ($this->changed_keys as $index => $key) {
- if ($index > 0)
- $sql .= ', ';
- $sql .= "$key = ?";
- $values[] = $this->data[$key];
- }
-
- $sql .= " WHERE {$this->primary} = ?";
- $values[] = $this->data[$this->primary];
-
- $stmt = $this->db->conn->prepare($sql);
-
- $this->changed_keys = [];
-
- if($stmt->execute($values))
- return true;
- else
- return false;
- }
-
- public function add() : bool
- /* this function add the set variables to the database */
- {
- if (!$this->changed_keys)
+ require_once "SQLDatabase.php";
+
+ /// Lollipop\DatabaseObject is an abstract class, a TableClass like Model\User should extends this
+ abstract class DatabaseObject
+ {
+ protected string $table;
+ protected string $primary;
+ protected array $column_names;
+ protected array $not_nullable;
+ protected SQLDatabase $db;
+ protected array $data = [];
+ protected array $changed_keys = [];
+ private string $schema;
+
+ public function __construct(SQLDatabase $db)
+ {
+ $this->db = $db;
+ $this->primary = $this->get_primary();
+ $this->table = $this->get_table();
+ $this->schema = $this->get_schema();
+ }
+
+ abstract public static function get_primary(): string;
+ abstract public static function get_table(): string;
+ abstract public static function get_schema(): string;
+
+ /// setData is to bulk-set the row instead of one-for-one
+ public function setData($data)
+ {
+ $this->data = $data;
+ }
+
+ /// select row by key
+ public function where(string $key, string $value)
+ {
+ $sql = "SELECT * FROM {$this->table} WHERE $key = ?";
+ $value = array($value);
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute($value);
+ $result = $stmt->get_result();
+ if ($result->num_rows == 0) {
+ return false;
+ }
+ $this->data = $result->fetch_assoc();
+ return true;
+ }
+
+ /// select rows by multiple values
+ public function where_array(array $values): bool
+ {
+ $sql = "SELECT * FROM {$this->table} WHERE ";
+ $params = [];
+ $i = 0;
+ foreach($values as $key => $param) {
+ if($i > 0) {
+ $sql .= " and ";
+ }
+ $sql .= "{$key} = ?";
+ $params[] = $param;
+ }
+
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute($params);
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return false;
+ }
+
+ $this->data = $result->fetch_assoc();
+ return true;
+ }
+
+ /// select row by id (and key is $this->primary_key())
+ public function load(string $id): bool
+ {
+ /*this fuction accepts an $id value for the primary key
+ * loads the row into data[]
+ * returns bool if row is found
+ */
+ $sql = "SELECT * FROM {$this->table} WHERE {$this->primary} = ?";
+
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute([$id]);
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
return false;
+ }
+
+ $this->data = $result->fetch_assoc();
+ return true;
+ }
+
+ /// update the row
+ public function save(): bool
+ {
+ if (!$this->changed_keys) {
+ return false;
+ }
+
+ $sql = "UPDATE {$this->table} SET ";
+
+ $values = [];
+ foreach ($this->changed_keys as $index => $key) {
+ if ($index > 0) {
+ $sql .= ', ';
+ }
+ $sql .= "$key = ?";
+ $values[] = $this->data[$key];
+ }
+
+ $sql .= " WHERE {$this->primary} = ?";
+ $values[] = $this->data[$this->primary];
+
+ $stmt = $this->db->conn->prepare($sql);
+
+ $this->changed_keys = [];
+
+ if($stmt->execute($values)) {
+ return true;
+ } else {
+ return false;
+ }
+ }
+
+ /// insert row into database if not existent
+ public function add(): bool
+ /* this function add the set variables to the database */
+ {
+ if (!$this->changed_keys) {
+ return false;
+ }
$sql = "INSERT INTO {$this->table} (";
$sql_val = ") VALUES (";
$values = [];
foreach ($this->changed_keys as $index => $key) {
- if ($index > 0){
+ if ($index > 0) {
$sql .= ', ';
$sql_val .= ', ';
}
@@ -139,144 +154,166 @@ namespace Lollipop {
$this->changed_keys = [];
- if($stmt->execute($values))
+ if($stmt->execute($values)) {
return true;
- else
+ } else {
return false;
- }
- public function delete()
- {
- $sql = "DELETE FROM {$this->table} WHERE {$this->primary} = ?";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute([$this->data[$this->primary]]);
- $this->data = [];
- $this->changed_keys = [];
- }
-
- public function __get(string $name)
- {
- return $this->data[$name];
- }
-
- public function __set(string $name, $value)
- {
- $this->data[$name] = $value;
- $this->changed_keys[] = $name;
- }
-
- public function getData()
- {
- return $this->data;
- }
- public function notNullable(){
- //non-auto-increment not-nullable collumn names query
- $col_names = [];
- $sql = " SELECT column_name, is_nullable, extra
+ }
+ }
+
+ /// deletes the row
+ public function delete()
+ {
+ $sql = "DELETE FROM {$this->table} WHERE {$this->primary} = ?";
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute([$this->data[$this->primary]]);
+ $this->data = [];
+ $this->changed_keys = [];
+ }
+
+ /// magic method: echo $obj->column
+ public function __get(string $name)
+ {
+ return $this->data[$name];
+ }
+
+ /// magic method: $obj->column = "value"
+ public function __set(string $name, $value)
+ {
+ $this->data[$name] = $value;
+ $this->changed_keys[] = $name;
+ }
+
+ /// get row as array
+ public function getData()
+ {
+ return $this->data;
+ }
+
+ /// get not-nullable fields of this table
+ public function notNullable()
+ {
+ //non-auto-increment not-nullable collumn names query
+ $col_names = [];
+ $sql = " SELECT column_name, is_nullable, extra
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '{$this->table}'
AND TABLE_SCHEMA = '{$this->schema}'";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return [];
- }
- while($tmp = $result->fetch_assoc()){
- if($tmp["is_nullable"] == 'NO'){
- if(!$tmp["extra"] == "auto_increment")
- $col_names[] = $tmp["column_name"];
- }
- }
- return $col_names;
- }
- public function get_column_names():array{
- $column_names = [];
- $sql = " SELECT column_name
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return [];
+ }
+ while($tmp = $result->fetch_assoc()) {
+ if($tmp["is_nullable"] == 'NO') {
+ if(!$tmp["extra"] == "auto_increment") {
+ $col_names[] = $tmp["column_name"];
+ }
+ }
+ }
+ return $col_names;
+ }
+
+ /// get column names of table
+ public function get_column_names(): array
+ {
+ $column_names = [];
+ $sql = " SELECT column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '$this->table'
AND TABLE_SCHEMA = '$this->schema'";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return [];
- }
- while($tmp = $result->fetch_assoc()){
- $column_names[] = $tmp["column_name"];
- }
- return $column_names;
- }
- public function get_col_names_no_ai():array{
- $column_names = [];
- $sql = " SELECT column_name, extra
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return [];
+ }
+ while($tmp = $result->fetch_assoc()) {
+ $column_names[] = $tmp["column_name"];
+ }
+ return $column_names;
+ }
+
+ /// get column names without auto-increments
+ public function get_col_names_no_ai(): array
+ {
+ $column_names = [];
+ $sql = " SELECT column_name, extra
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '$this->table'
AND TABLE_SCHEMA = '$this->schema'
AND EXTRA not like '%auto_increment%'";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return [];
- }
- while($tmp = $result->fetch_assoc()){
- $column_names[] = $tmp["column_name"];
- }
- return $column_names;
- }
- public function get_col_names_ai():array{
- $column_names = [];
- $sql = " SELECT column_name, extra
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return [];
+ }
+ while($tmp = $result->fetch_assoc()) {
+ $column_names[] = $tmp["column_name"];
+ }
+ return $column_names;
+ }
+
+ /// get auto-incremented columns
+ public function get_col_names_ai(): array
+ {
+ $column_names = [];
+ $sql = " SELECT column_name, extra
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '$this->table'
AND TABLE_SCHEMA = '$this->schema'
AND EXTRA like '%auto_increment%'";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return [];
- }
- while($tmp = $result->fetch_assoc()){
- $column_names[] = $tmp["column_name"];
- }
- return $column_names;
- }
- public function get_col_info():array{
- $column_names = [];
- $sql = " SELECT column_name, extra, data_type
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return [];
+ }
+ while($tmp = $result->fetch_assoc()) {
+ $column_names[] = $tmp["column_name"];
+ }
+ return $column_names;
+ }
+
+ /// get column infos
+ public function get_col_info(): array
+ {
+ $column_names = [];
+ $sql = " SELECT column_name, extra, data_type
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '$this->table'
AND TABLE_SCHEMA = '$this->schema'";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return [];
- }
- while($tmp = $result->fetch_assoc()){
- if(str_contains($tmp['data_type'], "varchar") || str_contains($tmp['data_type'], "text")){
- $column_names[$tmp["column_name"]]["input_type"] = "text";
- }elseif(str_contains($tmp['data_type'], "date")){
- $column_names[$tmp["column_name"]]["input_type"] = "date";
- }elseif(str_contains($tmp['data_type'], "int")){
- $column_names[$tmp["column_name"]]["input_type"] = "number";
- }elseif(str_contains($tmp['data_type'], "double")){
- $column_names[$tmp["column_name"]]["input_type"] = "number";
- }
- if(str_contains($tmp['extra'], "auto_increment")){
- $column_names[$tmp["column_name"]]['extra'] = "auto_increment";
- }
- if(str_contains($tmp['column_name'], "password")){
- $column_names[$tmp["column_name"]]['extra'] = "password";
- }
- }
- return $column_names;
- }
- }
-}
-\ No newline at end of file
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return [];
+ }
+ while($tmp = $result->fetch_assoc()) {
+ if(str_contains($tmp['data_type'], "varchar") || str_contains($tmp['data_type'], "text")) {
+ $column_names[$tmp["column_name"]]["input_type"] = "text";
+ } elseif(str_contains($tmp['data_type'], "date")) {
+ $column_names[$tmp["column_name"]]["input_type"] = "date";
+ } elseif(str_contains($tmp['data_type'], "int")) {
+ $column_names[$tmp["column_name"]]["input_type"] = "number";
+ } elseif(str_contains($tmp['data_type'], "double")) {
+ $column_names[$tmp["column_name"]]["input_type"] = "number";
+ }
+ if(str_contains($tmp['extra'], "auto_increment")) {
+ $column_names[$tmp["column_name"]]['extra'] = "auto_increment";
+ }
+ if(str_contains($tmp['column_name'], "password")) {
+ $column_names[$tmp["column_name"]]['extra'] = "password";
+ }
+ }
+ return $column_names;
+ }
+ }
+}
diff --git a/Lollipop/Router.php b/Lollipop/Router.php
@@ -1,106 +1,114 @@
-<?php
+<?php
+
namespace Lollipop {
- const MIME_TYPES = array(
- "css" => "text/css",
- "js" => "text/javascript"
- );
-
- class Router
- {
- protected array $routes = [];
- protected string $path;
- protected Template $temp;
-
- public function __construct($temp) {
- $this->temp = $temp;
- }
-
- protected function set_mime($file) {
- if (!is_null($file))
- $ext = pathinfo($file, PATHINFO_EXTENSION);
- else
- $ext = null;
-
- if ($ext != null && array_key_exists($ext, MIME_TYPES))
- $mime = MIME_TYPES[$ext];
- else
- $mime = "text/html";
-
- header("Content-Type: $mime");
- }
-
- protected function match(string $match, array &$route_vars): bool
- {
- $route_split = explode('/', trim($this->path, '/ '));
- $match_split = explode('/', trim($match, '/ '));
-
- if (sizeof($route_split) != sizeof($match_split)) {
- return false;
- }
-
- foreach ($match_split as $index => $m) {
- if (str_starts_with($m, ':')) {
- $route_vars[substr($m, 1)] = $route_split[$index];
- } else if ($m != $route_split[$index]) {
- return false;
- }
- }
- return true;
- }
-
-
- function addRoute(string|array $method, string $match, string|callable $func)
- {
- if (is_string($method))
- $method = [$method];
-
-
- $this->routes[] = array(
- "method" => $method,
- "match" => $match,
- "func" => $func,
- );
- }
-
- function includeRoute(string $path, array $_PARAM)
- {
- include $path;
- }
-
- function route(string $base = null)
- {
- $this->path = $_SERVER["REQUEST_URI"];
-
- if (strpos($this->path, '?'))
- $this->path = explode('?', $this->path)[0];
-
- if ($base && strpos($this->path, $base))
- $this->path = explode($base, $this->path)[1];
-
- $method = $_SERVER["REQUEST_METHOD"];
-
- foreach ($this->routes as $route) {
- if ($route["method"] != null && !in_array($method, $route["method"]))
- continue;
-
- $vars = [];
- if ($this->match($route["match"], $vars)) {
- if (is_callable($route["func"])) {
- $fil = $route["func"]($vars);
- if (!is_null($fil))
- $this->set_mime($fil);
- echo $this->temp->template($fil, $vars);
- return;
- } else {
- $this->set_mime($route["func"]);
- echo $this->temp->template($route["func"], $vars);
- return;
- }
- }
- }
-
- echo "404 '$this->path' not found!";
- return null;
- }
- }
-}
-\ No newline at end of file
+ const MIME_TYPES = array(
+ "css" => "text/css",
+ "js" => "text/javascript"
+ );
+
+ /// this is the basic router, implementing an automatic templater
+ class Router
+ {
+ protected array $routes = [];
+ protected string $path;
+ protected Template $temp;
+
+ public function __construct($temp)
+ {
+ $this->temp = $temp;
+ }
+
+ /// set content-type header
+ protected function set_mime($file)
+ {
+ if (!is_null($file)) {
+ $ext = pathinfo($file, PATHINFO_EXTENSION);
+ } else {
+ $ext = null;
+ }
+
+ if ($ext != null && array_key_exists($ext, MIME_TYPES)) {
+ $mime = MIME_TYPES[$ext];
+ } else {
+ $mime = "text/html";
+ }
+
+ header("Content-Type: $mime");
+ }
+
+ protected function match(string $match, array &$route_vars): bool
+ {
+ $route_split = explode('/', trim($this->path, '/ '));
+ $match_split = explode('/', trim($match, '/ '));
+
+ if (sizeof($route_split) != sizeof($match_split)) {
+ return false;
+ }
+
+ foreach ($match_split as $index => $m) {
+ if (str_starts_with($m, ':')) {
+ $route_vars[substr($m, 1)] = $route_split[$index];
+ } elseif ($m != $route_split[$index]) {
+ return false;
+ }
+ }
+ return true;
+ }
+
+ /// add route
+ /// $func can be a path to an template or a function which returns the path to an template and modifies $vars
+ public function addRoute(string|array $method, string $match, string|callable $func)
+ {
+ if (is_string($method)) {
+ $method = [$method];
+ }
+
+ $this->routes[] = array(
+ "method" => $method,
+ "match" => $match,
+ "func" => $func,
+ );
+ }
+
+ /// final routing
+ public function route(string $base = null)
+ {
+ $this->path = $_SERVER["REQUEST_URI"];
+
+ if (strpos($this->path, '?')) {
+ $this->path = explode('?', $this->path)[0];
+ }
+
+ if ($base && strpos($this->path, $base)) {
+ $this->path = explode($base, $this->path)[1];
+ }
+
+ $method = $_SERVER["REQUEST_METHOD"];
+
+ foreach ($this->routes as $route) {
+ if ($route["method"] != null && !in_array($method, $route["method"])) {
+ continue;
+ }
+
+ $vars = [];
+ if ($this->match($route["match"], $vars)) {
+ if (is_callable($route["func"])) {
+ $fil = $route["func"]($vars);
+ if (!is_null($fil)) {
+ $this->set_mime($fil);
+ }
+ echo $this->temp->template($fil, $vars);
+ return;
+ } else {
+ $this->set_mime($route["func"]);
+ echo $this->temp->template($route["func"], $vars);
+ return;
+ }
+ }
+ }
+
+ echo "404 '$this->path' not found!";
+ return null;
+ }
+ }
+}
diff --git a/Lollipop/SQLDatabase.php b/Lollipop/SQLDatabase.php
@@ -1,94 +1,98 @@
<?php
namespace Lollipop {
- use mysqli;
-
- class SQLDatabase
- {
- public mysqli $conn;
-
- function __construct(string $host, string $username, string $password, string $database = null, int $port = null)
- {
- $this->conn = new mysqli($host, $username, $password, $database, $port);
- }
-
- function get(string $table_class)
- {
- /* this function accepts a $table_name creates a Database object with the class $table_name
- * retuns a Database object
- */
- $cls = new $table_class($this);
- return $cls;
- }
-
- function all_where(string $table_name, array $vars)
- {
- /* this function accepts a table name and an array[$column_name => $value]
- * statement is select * from $table_name where $column_name = $value AND etc...
- * returns an array of classes
- */
- if (!sizeof($vars)) {
- return [];
- }
- $cls = new $table_name($this);
-
- $sql = "SELECT * FROM {$cls->get_table()} WHERE ";
- $params = [];
-
- $i = 0;
- foreach ($vars as $key => $value) {
- if ($i > 0) {
- $sql .= ' AND ';
- }
- $sql .= " $key LIKE ?";
- $params[] = $value;
- $i++;
- }
-
- $stmt = $this->conn->prepare($sql);
- $stmt->execute($params);
- $result = $stmt->get_result();
-
- if (!$result || $result->num_rows == 0) {
- return [];
- }
-
- $objects = [];
- while ($row = $result->fetch_assoc()) {
- $o = new $table_name($this);
- $o->setData($row);
- $objects[] = $o;
- }
- return $objects;
- }
-
- function all(string $table_name)
- {
- /* loads whole table $table_name
- * returns array of objects
- */
- $cls = new $table_name($this);
-
- $sql = "SELECT * FROM {$cls->get_table()}";
-
- $result = $this->conn->query($sql);
-
- if (!$result || $result->num_rows == 0) {
- return [];
- }
-
- $objects = [];
- while ($row = $result->fetch_assoc()) {
- $o = new $table_name($this);
- $o->setData($row);
- $objects[] = $o;
- }
- return $objects;
- }
+ use mysqli;
+
+ /// this is the main database engine
+ class SQLDatabase
+ {
+ public mysqli $conn;
+
+ public function __construct(string $host, string $username, string $password, string $database = null, int $port = null)
+ {
+ $this->conn = new mysqli($host, $username, $password, $database, $port);
+ }
+
+ /// get a table by passing the desired class
+ public function get(string $table_class)
+ {
+ /* this function accepts a $table_name creates a Database object with the class $table_name
+ * retuns a Database object
+ */
+ $cls = new $table_class($this);
+ return $cls;
+ }
+
+ /// this function accepts a table name and an array[$column_name => $value]
+ /// statement is select * from $table_name where $column_name = $value AND etc...
+ /// returns an array of classes
+ public function all_where(string $table_name, array $vars)
+ {
+ if (!sizeof($vars)) {
+ return [];
+ }
+ $cls = new $table_name($this);
+
+ $sql = "SELECT * FROM {$cls->get_table()} WHERE ";
+ $params = [];
+
+ $i = 0;
+ foreach ($vars as $key => $value) {
+ if ($i > 0) {
+ $sql .= ' AND ';
+ }
+ $sql .= " $key LIKE ?";
+ $params[] = $value;
+ $i++;
+ }
+
+ $stmt = $this->conn->prepare($sql);
+ $stmt->execute($params);
+ $result = $stmt->get_result();
+
+ if (!$result || $result->num_rows == 0) {
+ return [];
+ }
+
+ $objects = [];
+ while ($row = $result->fetch_assoc()) {
+ $o = new $table_name($this);
+ $o->setData($row);
+ $objects[] = $o;
+ }
+ return $objects;
+ }
+
+ /// returns every row in database of table
+ public function all(string $table_name)
+ {
+ /* loads whole table $table_name
+ * returns array of objects
+ */
+ $cls = new $table_name($this);
+
+ $sql = "SELECT * FROM {$cls->get_table()}";
+
+ $result = $this->conn->query($sql);
+
+ if (!$result || $result->num_rows == 0) {
+ return [];
+ }
+
+ $objects = [];
+ while ($row = $result->fetch_assoc()) {
+ $o = new $table_name($this);
+ $o->setData($row);
+ $objects[] = $o;
+ }
+ return $objects;
+ }
+
public function getDateRange(string $table_name, array $query, $order)
{
- if($query == null)
+ if($query == null) {
return [];
+ }
$cls = new $table_name($this);
@@ -106,8 +110,8 @@ namespace Lollipop {
}
}
- $sql .= " ORDER BY date_time " . $order;
- $sql .= " LIMIT 1000";
+ $sql .= " ORDER BY date_time " . $order;
+ $sql .= " LIMIT 1000";
$stmt = $this->conn->prepare($sql);
$stmt->execute($values);
$result = $stmt->get_result();
@@ -124,6 +128,5 @@ namespace Lollipop {
}
return $objects;
}
- }
+ }
}
-?>
-\ No newline at end of file
diff --git a/Lollipop/Template.php b/Lollipop/Template.php
@@ -1,86 +1,103 @@
-<?php
+<?php
+
namespace Lollipop {
-use ErrorException;
- Class Template{
- private TemplateMethods $methods;
-
- function __construct(TemplateMethods $methods){
- $this->methods = $methods;
+ use ErrorException;
+
+ /// this is the templating engine
+ /// syntax:
+ /// {{ $var }} will be replaces with the variable or nothing if not existend
+ /// {{ "value" !func }} func will be called, popping things from the stack and pushing the result
+ /// {{ $var "exist: %%" "doesnt exist" !format_if }} is an example
+ class Template
+ {
+ private TemplateMethods $methods;
+
+ public function __construct(TemplateMethods $methods)
+ {
+ $this->methods = $methods;
}
-
- function template(string $uri, array $data) : string{
+
+ public function template(string $uri, array $data): string
+ {
/* this function takes a uri and a string array data */
/* opens a stream to the uri specified file and stores the content in $file*/
- return $this->insert_data(file_get_contents($uri), $data);
+ return $this->insert_data(file_get_contents($uri), $data);
}
-
- private function insert_data(string $file, array $data):string{
+
+ private function insert_data(string $file, array $data): string
+ {
$html = "";
$filesize = strlen($file);
- for($i = 0; $i < $filesize-1; $i++){
- if ($file[$i] == '{' && $file[$i + 1] == '{') {
- for ($j = $i; $j < $filesize-1; $j++) {
- if ($file[$j] == '}' && $file[$j + 1] == '}') {
- $html .= $this->parse_template(trim(substr($file, $i + 2, $j - $i - 2)), $data);
- $i = $j + 1;
- break;
- }
- }
- } else {
- $html .= $file[$i];
- }
- }
- return $html;
- }
-
- private function parse_template(string $expr, array $data) {
- $tokens = [];
- $in_string = false;
- $buffer = '';
-
- foreach (str_split($expr) as $c) {
- if ($c == '"' && !$in_string) { // string start
- $in_string = true;
- } else if ($c == '"') { // string end
- $tokens[] = $buffer;
- $buffer = '';
- $in_string = false;
- } else if ($c == ' ' && !$in_string) {
- if ($buffer) {
- $tokens[] = $buffer;
- $buffer = '';
- }
- } else {
- $buffer .= $c;
- }
- }
- if ($buffer)
- $tokens[] = $buffer;
-
- return $this->eval_tokens($tokens, $data);
- }
+ for($i = 0; $i < $filesize-1; $i++) {
+ if ($file[$i] == '{' && $file[$i + 1] == '{') {
+ for ($j = $i; $j < $filesize-1; $j++) {
+ if ($file[$j] == '}' && $file[$j + 1] == '}') {
+ $html .= $this->parse_template(trim(substr($file, $i + 2, $j - $i - 2)), $data);
+ $i = $j + 1;
+ break;
+ }
+ }
+ } else {
+ $html .= $file[$i];
+ }
+ }
+ return $html;
+ }
+
+ private function parse_template(string $expr, array $data)
+ {
+ $tokens = [];
+ $in_string = false;
+ $buffer = '';
+
+ foreach (str_split($expr) as $c) {
+ if ($c == '"' && !$in_string) { // string start
+ $in_string = true;
+ } elseif ($c == '"') { // string end
+ $tokens[] = $buffer;
+ $buffer = '';
+ $in_string = false;
+ } elseif ($c == ' ' && !$in_string) {
+ if ($buffer) {
+ $tokens[] = $buffer;
+ $buffer = '';
+ }
+ } else {
+ $buffer .= $c;
+ }
+ }
+ if ($buffer) {
+ $tokens[] = $buffer;
+ }
+
+ return $this->eval_tokens($tokens, $data);
+ }
+
+ private function eval_tokens(array $tokens, array $data)
+ {
+ $stack = [];
+ foreach ($tokens as $token) {
+ if ($token && $token[0] == '!') {
+ $val = $this->methods->{substr($token, 1)}($stack);
+ if (!is_null($val)) {
+ $stack[] = $val;
+ }
+ } elseif ($token && $token[0] == '$') {
+ $stack[] = array_key_exists(substr($token, 1), $data) ? $data[substr($token, 1)] : "";
+ } else {
+ $stack[] = $token;
+ }
+ }
- private function eval_tokens(array $tokens, array $data) {
- $stack = [];
- foreach ($tokens as $token) {
- if ($token && $token[0] == '!') {
- $val = $this->methods->{substr($token, 1)}($stack);
- if (!is_null($val))
- $stack[] = $val;
- } else if ($token && $token[0] == '$') {
- $stack[] = array_key_exists(substr($token, 1), $data) ? $data[substr($token, 1)] : "";
- } else {
- $stack[] = $token;
- }
- }
-
- if (sizeof($stack) > 1)
- throw new ErrorException("Stack-size is not 1");
- if (sizeof($stack) == 0)
- return "";
- return $stack[0];
- }
+ if (sizeof($stack) > 1) {
+ throw new ErrorException("Stack-size is not 1");
+ }
+ if (sizeof($stack) == 0) {
+ return "";
+ }
+ return $stack[0];
+ }
}
-}
-\ No newline at end of file
+}
diff --git a/Lollipop/TemplateMethods.php b/Lollipop/TemplateMethods.php
@@ -2,6 +2,7 @@
namespace Lollipop {
+ /// this class contains all built-in functions for the templater
class TemplateMethods
{
public static function add(array &$tokens)
diff --git a/Lollipop/Utils.php b/Lollipop/Utils.php
@@ -1,35 +1,34 @@
<?php
-namespace Lollipop{
- Class Utils{
- static function post_to_array():array{
- $arr = [];
- foreach ($_POST as $key => $value) {
- $arr[$key] = $value;
- }
- return $arr;
- }
- static function missing_fields($not_nullable){
- $missing = [];
- foreach($not_nullable as $column){
- if($_POST[$column] == NULL || $_POST[$column] == ""){
- $key = 'missing_' . $column;
- $missing[$key] = "This field cannot be empty!";
+namespace Lollipop{
+
+ /// this class is a collection of utilities
+ class Utils
+ {
+ public static function missing_fields($not_nullable)
+ {
+ $missing = [];
+ foreach($not_nullable as $column) {
+ if($_POST[$column] == null || $_POST[$column] == "") {
+ $key = 'missing_' . $column;
+ $missing[$key] = "This field cannot be empty!";
+ }
+ }
+ return $missing;
}
- }
- return $missing;
- }
- static function missing_fields_sans_pw($not_nullable){
- $missing = [];
- foreach($not_nullable as $column){
- if($_POST[$column] == NULL || $_POST[$column] == ""){
- if($column != "password"){
- $key = 'missing_' . $column;
- $missing[$key] = "This field cannot be empty!";
- }
+
+ public static function missing_fields_sans_pw($not_nullable)
+ {
+ $missing = [];
+ foreach($not_nullable as $column) {
+ if($_POST[$column] == null || $_POST[$column] == "") {
+ if($column != "password") {
+ $key = 'missing_' . $column;
+ $missing[$key] = "This field cannot be empty!";
+ }
+ }
+ }
+ return $missing;
}
- }
- return $missing;
}
- }
-}
-\ No newline at end of file
+}
diff --git a/Model/Course.php b/Model/Course.php
@@ -1,47 +1,50 @@
<?php
namespace Model {
-use Lollipop\Utils;
- class Course extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "course";
- }
+ use Lollipop\Utils;
- static function get_primary(): string
- {
- return "id";
- }
+ class Course extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "course";
+ }
- static function get_schema(): string
- {
- return "lollipop";
- }
+ public static function get_primary(): string
+ {
+ return "id";
+ }
- public function add_course():bool{
- $missing_fields = Utils::missing_fields($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_col_names_no_ai())){
- $this->{$key} = $post;
- }
- }
- return $this->add();
- }
- return false;
- }
- public function update_course():bool{
- $missing_fields = Utils::missing_fields($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_column_names())){
- $this->{$key} = $post;
- }
- }
- return $this->save();
- }
- return false;
- }
- }
-}
-\ No newline at end of file
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
+
+ public function add_course(): bool
+ {
+ $missing_fields = Utils::missing_fields($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_col_names_no_ai())) {
+ $this->{$key} = $post;
+ }
+ }
+ return $this->add();
+ }
+ return false;
+ }
+ public function update_course(): bool
+ {
+ $missing_fields = Utils::missing_fields($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_column_names())) {
+ $this->{$key} = $post;
+ }
+ }
+ return $this->save();
+ }
+ return false;
+ }
+ }
+}
diff --git a/Model/CourseUser.php b/Model/CourseUser.php
@@ -1,20 +1,20 @@
<?php
namespace Model {
- class CourseUser extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "user_course";
- }
+ class CourseUser extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "user_course";
+ }
- static function get_primary(): string
- {
- return "id";
- }
- static function get_schema(): string
- {
- return "lollipop";
- }
- }
-}
-\ No newline at end of file
+ public static function get_primary(): string
+ {
+ return "id";
+ }
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
+ }
+}
diff --git a/Model/Exam.php b/Model/Exam.php
@@ -1,44 +1,48 @@
<?php
+
namespace Model {
- use Lollipop\Utils;
- class Exam extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "exam";
- }
+ use Lollipop\Utils;
+
+ class Exam extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "exam";
+ }
- static function get_primary(): string
- {
- return "id";
- }
- static function get_schema(): string
- {
- return "lollipop";
- }
- public function add_exam():bool{
- $missing_fields = Utils::missing_fields($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_col_names_no_ai())){
- $this->{$key} = $post;
- }
- }
- return $this->add();
- }
- return false;
- }
- public function update_exam():bool{
- $missing_fields = Utils::missing_fields($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_column_names())){
- $this->{$key} = $post;
- }
- }
- return $this->save();
- }
- return false;
- }
- }
-}
-\ No newline at end of file
+ public static function get_primary(): string
+ {
+ return "id";
+ }
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
+ public function add_exam(): bool
+ {
+ $missing_fields = Utils::missing_fields($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_col_names_no_ai())) {
+ $this->{$key} = $post;
+ }
+ }
+ return $this->add();
+ }
+ return false;
+ }
+ public function update_exam(): bool
+ {
+ $missing_fields = Utils::missing_fields($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_column_names())) {
+ $this->{$key} = $post;
+ }
+ }
+ return $this->save();
+ }
+ return false;
+ }
+ }
+}
diff --git a/Model/Grade.php b/Model/Grade.php
@@ -1,49 +1,52 @@
<?php
namespace Model {
-
-use Lollipop\Utils;
- class Grade extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "grade";
- }
- static function get_primary(): string
- {
- return "id";
- }
+ use Lollipop\Utils;
- static function get_schema(): string
- {
- return "lollipop";
- }
+ class Grade extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "grade";
+ }
- public function add_grade():bool{
- $missing_fields = Utils::missing_fields($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_col_names_no_ai())){
- $this->{$key} = $post;
- }
- }
- return $this->add();
- }
- return false;
- }
- public function update_grade():bool{
- $missing_fields = Utils::missing_fields($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_column_names())){
- $this->{$key} = $post;
- }
- }
- return $this->save();
- }
- return false;
- }
+ public static function get_primary(): string
+ {
+ return "id";
+ }
- }
-}
-\ No newline at end of file
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
+
+ public function add_grade(): bool
+ {
+ $missing_fields = Utils::missing_fields($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_col_names_no_ai())) {
+ $this->{$key} = $post;
+ }
+ }
+ return $this->add();
+ }
+ return false;
+ }
+ public function update_grade(): bool
+ {
+ $missing_fields = Utils::missing_fields($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_column_names())) {
+ $this->{$key} = $post;
+ }
+ }
+ return $this->save();
+ }
+ return false;
+ }
+
+ }
+}
diff --git a/Model/Login_handler.php b/Model/Login_handler.php
@@ -1,63 +0,0 @@
-<?php
-const login = "email";
-const pwd = "password";
-class Login_handler
-{
- function login():bool{
- $post_arr = Utils::post_to_array();;
- $missing_fields = Utils::missing_fields($post_arr , [login, pwd]);
-
- if(sizeof($missing_fields) > 0){
- return ($this->authenticate($post_arr));
- }else{
- return false;
- }
-
- }
- function authenticate(array $post) : bool
- //this function return true when user is autheticated uses set_globals to set $_SESSION variables
- {
- //create a SQLDatabase class
- $db = new Lollipop\SQLDatabase("86.92.67.21", "friedel", "hailiwa", "panda");
- //create a Database object class, with the table User
- $u = $db->get(User::class);
-
- //check if the email exists in db
- if(!$u->where($post[login])){
- //email does not exist
- return false;
- }else{
- if(password_verify($post[pwd], $u->password)){
- //authenticated -> set $_SESSION variables
- $this->set_globals($u, $db);
- return true;
- } else {
- //password did not match
- return false;
- }
- }
- }
-
- private function set_globals(Lollipop\DatabaseObject $u, Lollipop\SQLDatabase $db)
- //this function sets Session variables which incluse
- //email, first_name, last_name and array user_permissions
- {
- //start session and set
- session_start();
- $u->load($u->primary);
-
- foreach($u->getData() as $key => $data){
- if($key != pwd){
- $_SESSION[$key] = $data;
- }
- }
-
- //get permissions form db and set sessions_permissions
- $p = $db->all_where(Permission_user::class, array('id_user' => $u->id));
- foreach($p as $permission){
- $user_permissions[] = $permission->id;
- }
- $_SESSION['user_permissions'] = $user_permissions;
- }
-}
-?>
-\ No newline at end of file
diff --git a/Model/Permission.php b/Model/Permission.php
@@ -1,34 +1,35 @@
<?php
namespace Model {
- class Permission extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "permission";
- }
+ class Permission extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "permission";
+ }
- static function get_primary(): string
- {
- return "id";
- }
- static function get_schema(): string
- {
- return "lollipop";
- }
- function get_checkboxes(): array{
- $all_permissions = $this->db->all($this::class);
- $html = "<div class='check_this_box'>";
- foreach($all_permissions as $permission){
- $html .= '<input type="checkbox" id="'. $permission->name .'" name="permissions[]" value="'. $permission->id .'"';
- if($permission->id == 0){
- $html .= ' checked';
- }
- $html .= '>';
- $html .= '<label for="'. $permission->name .'">'. $permission->name .'</label>';
- }
- $html .= "</div>";
- return [0 => $html];
- }
- }
-}
-\ No newline at end of file
+ public static function get_primary(): string
+ {
+ return "id";
+ }
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
+ public function get_checkboxes(): array
+ {
+ $all_permissions = $this->db->all($this::class);
+ $html = "<div class='check_this_box'>";
+ foreach($all_permissions as $permission) {
+ $html .= '<input type="checkbox" id="'. $permission->name .'" name="permissions[]" value="'. $permission->id .'"';
+ if($permission->id == 0) {
+ $html .= ' checked';
+ }
+ $html .= '>';
+ $html .= '<label for="'. $permission->name .'">'. $permission->name .'</label>';
+ }
+ $html .= "</div>";
+ return [0 => $html];
+ }
+ }
+}
diff --git a/Model/PermissionUser.php b/Model/PermissionUser.php
@@ -1,44 +1,47 @@
<?php
+
namespace Model {
- class PermissionUser extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "permission_user";
- }
+ class PermissionUser extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "permission_user";
+ }
- static function get_primary(): string
- {
- return 'email';
- }
- static function get_schema(): string
- {
- return "lollipop";
- }
- public function add_permissions(User $user):bool{
- if(array_key_exists('permissions', $_POST)){
- foreach($_POST['permissions'] as $permission){
- $this->{$user->get_primary()} = $user->{$user->get_primary()};
- $this->id = $permission;
- $this->add();
- }
- return true;
- }
- return false;
- }
- public function update_permissions(User $user):bool{
- foreach($this->db->all_where(PermissionUser::class, [$this->get_primary() => $_POST[$this->get_primary()]]) as $permission){
- $permission->delete();
- }
- if(array_key_exists('permissions', $_POST)){
- foreach($_POST['permissions'] as $permission){
- $this->{$user->get_primary()} = $user->{$user->get_primary()};
- $this->id = $permission;
- $this->add();
- }
- return true;
- }
- return false;
- }
- }
-}
-\ No newline at end of file
+ public static function get_primary(): string
+ {
+ return 'email';
+ }
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
+ public function add_permissions(User $user): bool
+ {
+ if(array_key_exists('permissions', $_POST)) {
+ foreach($_POST['permissions'] as $permission) {
+ $this->{$user->get_primary()} = $user->{$user->get_primary()};
+ $this->id = $permission;
+ $this->add();
+ }
+ return true;
+ }
+ return false;
+ }
+ public function update_permissions(User $user): bool
+ {
+ foreach($this->db->all_where(PermissionUser::class, [$this->get_primary() => $_POST[$this->get_primary()]]) as $permission) {
+ $permission->delete();
+ }
+ if(array_key_exists('permissions', $_POST)) {
+ foreach($_POST['permissions'] as $permission) {
+ $this->{$user->get_primary()} = $user->{$user->get_primary()};
+ $this->id = $permission;
+ $this->add();
+ }
+ return true;
+ }
+ return false;
+ }
+ }
+}
diff --git a/Model/User.php b/Model/User.php
@@ -1,147 +1,152 @@
<?php
+
namespace Model {
- class User extends \Lollipop\DatabaseObject
- {
- static function get_table(): string
- {
- return "user";
- }
+ class User extends \Lollipop\DatabaseObject
+ {
+ public static function get_table(): string
+ {
+ return "user";
+ }
+
+ public static function get_primary(): string
+ {
+ return "email";
+ }
+
+ public static function get_password_field(): string
+ {
+ return "password";
+ }
+ public static function get_schema(): string
+ {
+ return "lollipop";
+ }
- static function get_primary(): string
- {
- return "email";
- }
+ public function login_fields(): string
+ {
+ $html = "";
+ $html .= '<input type="text" name="' . $this->get_primary(). '" placeholder="' . $this->get_primary() . '">';
+ $html .= '<input type="password" name="' . $this->get_password_field() . '" placeholder="password">';
+ return $html;
+ }
- static function get_password_field(): string{
- return "password";
- }
- static function get_schema(): string
- {
- return "lollipop";
- }
+ public function all_fields(array $res = []): string
+ {
+ $html = "";
+ foreach($this->column_names as $field) {
+ if($field == $this->get_password_field()) {
+ $html .= '<input type="password" name="' . $field . '" placeholder="' . $field . '">';
+ } else {
+ $html .= '<input type="text" name="' . $field . '" placeholder="' . $field . '">';
+ }
+ $miss_key = 'missing_'.$field;
+ if(array_key_exists($miss_key, $res)) {
+ $html .= '<div class="form-response"><p style="color:red;"> Field: '. $field . ' cannot be empty</p></div>';
+ }
+ }
+ return $html;
+ }
- function login_fields(): string{
- $html = "";
- $html .= '<input type="text" name="' . $this->get_primary(). '" placeholder="' . $this->get_primary() . '">';
- $html .= '<input type="password" name="' . $this->get_password_field() . '" placeholder="password">';
- return $html;
- }
+ public function login(): array
+ {
+ if([$this->get_primary() != "" && !$this->get_password_field() == ""]) {
+ return $this->authenticate();
+ } else {
+ return ["response" => ""];
+ }
+ }
+ public function authenticate(): array
+ //this function return true when user is autheticated uses set_globals to set $_SESSION variables
+ {
+ //check if the email exists in db
+ if(!$this->load($_POST[$this->get_primary()])) {
+ //email does not exist
+ return ["response" => "{$this->get_primary()}: {$_POST[$this->get_primary()]} does not exists in db"];
+ } else {
+ if(password_verify($_POST[$this->get_password_field()], $this->{$this->get_password_field()})) {
+ //authenticated -> set $_SESSION variables
+ $this->set_globals();
+ return [];
+ } else {
+ //password did not match
+ return ["response" => "incorrect password"];
+ }
+ }
+ }
- function all_fields(array $res = []): string{
- $html = "";
- foreach($this->column_names as $field){
- if($field == $this->get_password_field()){
- $html .= '<input type="password" name="' . $field . '" placeholder="' . $field . '">';
- }else{
- $html .= '<input type="text" name="' . $field . '" placeholder="' . $field . '">';
- }
- $miss_key = 'missing_'.$field;
- if(array_key_exists($miss_key, $res)){
- $html .= '<div class="form-response"><p style="color:red;"> Field: '. $field . ' cannot be empty</p></div>';
- }
- }
- return $html;
- }
+ private function set_globals()
+ //this function sets Session variables
+ {
+ $user_permissions = [];
+ //foreach field in database which is not password add to session
+ foreach($this->getData() as $key => $data) {
+ if($key != $this->get_password_field()) {
+ $_SESSION[$key] = $data;
+ }
+ }
+ //get permissions form db and set sessions_permissions
+ $p = $this->db->all_where(PermissionUser::class, [$this->get_primary() => $this->{$this->get_primary()}]);
+ foreach($p as $permission) {
+ $user_permissions[] = $permission->id;
+ }
+ $_SESSION['user_permissions'] = $user_permissions;
+ }
- function login():array{
- $post_arr = \Lollipop\Utils::post_to_array();
-
- if([$this->get_primary() != "" && !$this->get_password_field() == ""]){
- return $this->authenticate($post_arr);
- }else{
- return ["response" => ""];
- }
- }
- function authenticate(array $post) : array
- //this function return true when user is autheticated uses set_globals to set $_SESSION variables
- {
- //check if the email exists in db
- if(!$this->load($post[$this->get_primary()])){
- //email does not exist
- return ["response" => "{$this->get_primary()}: {$post[$this->get_primary()]} does not exists in db"];
- }else{
- if(password_verify($post[$this->get_password_field()], $this->{$this->get_password_field()})){
- //authenticated -> set $_SESSION variables
- $this->set_globals();
- return [];
- } else {
- //password did not match
- return ["response" => "incorrect password"];
- }
- }
- }
-
- private function set_globals()
- //this function sets Session variables
- {
- $user_permissions = [];
- //foreach field in database which is not password add to session
- foreach($this->getData() as $key => $data){
- if($key != $this->get_password_field()){
- $_SESSION[$key] = $data;
- }
- }
- //get permissions form db and set sessions_permissions
- $p = $this->db->all_where(PermissionUser::class, [$this->get_primary() => $this->{$this->get_primary()}]);
- foreach($p as $permission){
- $user_permissions[] = $permission->id;
- }
- $_SESSION['user_permissions'] = $user_permissions;
- }
+ public function add_user(): array
+ {
+ $missing_fields = \Lollipop\Utils::missing_fields($this->notNullable());
- function add_user():array{
- $post_arr = \Lollipop\Utils::post_to_array();
- $missing_fields = \Lollipop\Utils::missing_fields($this->notNullable());
-
- if(sizeof($missing_fields) == 0){
- return $this->add_data_db($post_arr);
- }else{
- return $missing_fields;
- }
- }
+ if(sizeof($missing_fields) == 0) {
+ return $this->add_data_db();
+ } else {
+ return $missing_fields;
+ }
+ }
- private function add_data_db(array $post_arr): array{
- $user_credentials = [];
- $response["success"] = false;
- if($this->load($post_arr[$this->get_primary()])){
- $response["response"] = "<p style=\"color:red;\">this email address is already taken: {$post_arr[$this->get_primary()]} </p>";
- return $response;
- }else{
- if($post_arr[$this->get_password_field()]){
- $post_arr[$this->get_password_field()] = password_hash($post_arr[$this->get_password_field()], PASSWORD_DEFAULT);
- }
- foreach($this->get_col_names_no_ai() as $col){
- if($post_arr[$col] != ""){
- $this->$col = $post_arr[$col];
- $user_credentials[$col] = $post_arr[$col];
- }
- }
- if($this->add()){
- $response["response"] = "<p style=\"color:green;\">succes</p>";
- $response += $user_credentials;
- $response["success"] = true;
- return $response;
- }else{
- $response["response"] = "<p style=\"color:red;\">could not add user to database</p>";
- return $response;
- }
- }
- }
- public function update_user():bool{
- $missing_fields = \Lollipop\Utils::missing_fields_sans_pw($this->notNullable());
- if(sizeof($missing_fields) == 0){
- foreach($_POST as $key => $post){
- if(in_array($key, $this->get_column_names())){
- if($key == $this->get_password_field()){
- $this->{$key} = password_hash($_POST[$key], PASSWORD_DEFAULT);
- }else{
- $this->{$key} = $post;
- }
- }
- }
- return $this->save();
- }
- return false;
- }
- }
-}
-\ No newline at end of file
+ private function add_data_db(): array
+ {
+ $user_credentials = [];
+ $response["success"] = false;
+ if($this->load($_POST[$this->get_primary()])) {
+ $response["response"] = "<p style=\"color:red;\">this email address is already taken: {$_POST[$this->get_primary()]} </p>";
+ return $response;
+ } else {
+ if($_POST[$this->get_password_field()]) {
+ $_POST[$this->get_password_field()] = password_hash($_POST[$this->get_password_field()], PASSWORD_DEFAULT);
+ }
+ foreach($this->get_col_names_no_ai() as $col) {
+ if($_POST[$col] != "") {
+ $this->$col = $_POST[$col];
+ $user_credentials[$col] = $_POST[$col];
+ }
+ }
+ if($this->add()) {
+ $response["response"] = "<p style=\"color:green;\">succes</p>";
+ $response += $user_credentials;
+ $response["success"] = true;
+ return $response;
+ } else {
+ $response["response"] = "<p style=\"color:red;\">could not add user to database</p>";
+ return $response;
+ }
+ }
+ }
+ public function update_user(): bool
+ {
+ $missing_fields = \Lollipop\Utils::missing_fields_sans_pw($this->notNullable());
+ if(sizeof($missing_fields) == 0) {
+ foreach($_POST as $key => $post) {
+ if(in_array($key, $this->get_column_names())) {
+ if($key == $this->get_password_field()) {
+ $this->{$key} = password_hash($_POST[$key], PASSWORD_DEFAULT);
+ } else {
+ $this->{$key} = $post;
+ }
+ }
+ }
+ return $this->save();
+ }
+ return false;
+ }
+ }
+}
diff --git a/index.php b/index.php
@@ -1,4 +1,5 @@
<?php
+
require_once "utils/autoloader.php";
require_once "routing/index.php";
require_once "routing/user.php";
@@ -12,13 +13,8 @@ $db = new Lollipop\SQLDatabase("86.92.67.21", "friedel", "hailiwa", "lollipop");
session_start();
-/*if(isset($_SESSION['user_permissions']) && in_array(1, $_SESSION['user_permissions'])){
- echo "permission dingen";
- foreach($_SESSION as $tmp){
- echo $tmp;
- }
-}*/
-//css
+// static files
+
$router->addRoute(["GET"], "/views/css/add_user.css", "views/css/add_user.css");
$router->addRoute(["GET"], "/views/css/course.css", "views/css/course.css");
$router->addRoute(["GET"], "/views/css/exam.css", "views/css/exam.css");
@@ -32,71 +28,72 @@ $router->addRoute(["POST"], "/", $index_post);
$router->addRoute(["GET"], "/logout", $logout);
-if(isset($_SESSION['user_permissions'])){
- if(in_array(1, $_SESSION['user_permissions']) || in_array(2, $_SESSION['user_permissions']) || in_array(3, $_SESSION['user_permissions'])){
- $router->addRoute(["GET"], "/user/:primary_key", $user_page);
+// restricted section
+if(isset($_SESSION['user_permissions'])) {
+ if(in_array(1, $_SESSION['user_permissions']) || in_array(2, $_SESSION['user_permissions']) || in_array(3, $_SESSION['user_permissions'])) {
+ $router->addRoute(["GET"], "/user/:primary_key", $user_page);
- $router->addRoute(["GET"], "/dashboard", $dashboard);
- }
+ $router->addRoute(["GET"], "/dashboard", $dashboard);
+ }
- if(in_array(2, $_SESSION['user_permissions']) || in_array(3, $_SESSION['user_permissions']) ){
- $router->addRoute(["GET"], "/course", $course_get);
+ if(in_array(2, $_SESSION['user_permissions']) || in_array(3, $_SESSION['user_permissions'])) {
+ $router->addRoute(["GET"], "/course", $course_get);
- $router->addRoute(["GET"], "/course/:course", $course_data);
+ $router->addRoute(["GET"], "/course/:course", $course_data);
- $router->addRoute(["POST"], "/course", $course_post);
+ $router->addRoute(["POST"], "/course", $course_post);
- $router->addRoute(["GET"], "/course/search/:search_query", $course_query);
+ $router->addRoute(["GET"], "/course/search/:search_query", $course_query);
- $router->addRoute(["POST"], "/course/search", $course_search);
+ $router->addRoute(["POST"], "/course/search", $course_search);
- $router->addRoute(["GET"], "/course/:primary_key/edit", $course_edit);
+ $router->addRoute(["GET"], "/course/:primary_key/edit", $course_edit);
- $router->addRoute(["GET"], "/course/:primary_key/delete", $course_delete);
+ $router->addRoute(["GET"], "/course/:primary_key/delete", $course_delete);
- $router->addRoute(["GET"], "/exam", $exam_get);
+ $router->addRoute(["GET"], "/exam", $exam_get);
- $router->addRoute(["GET"], "/exam/:exam", $exam_data);
+ $router->addRoute(["GET"], "/exam/:exam", $exam_data);
- $router->addRoute(["POST"], "/exam", $exam_post);
+ $router->addRoute(["POST"], "/exam", $exam_post);
- $router->addRoute(["GET"], "/exam/search/:search_query", $exam_query);
+ $router->addRoute(["GET"], "/exam/search/:search_query", $exam_query);
- $router->addRoute(["POST"], "/exam/search", $exam_search);
+ $router->addRoute(["POST"], "/exam/search", $exam_search);
- $router->addRoute(["GET"], "/exam/:primary_key/edit", $exam_edit);
+ $router->addRoute(["GET"], "/exam/:primary_key/edit", $exam_edit);
- $router->addRoute(["GET"], "/exam/:primary_key/delete", $exam_delete);
+ $router->addRoute(["GET"], "/exam/:primary_key/delete", $exam_delete);
- $router->addRoute(["GET"], "/grade", $grade_get);
+ $router->addRoute(["GET"], "/grade", $grade_get);
- $router->addRoute(["POST"], "/grade", $grade_post);
+ $router->addRoute(["POST"], "/grade", $grade_post);
- $router->addRoute(["GET"], "/grade/search/:search_query", $grade_query);
+ $router->addRoute(["GET"], "/grade/search/:search_query", $grade_query);
- $router->addRoute(["POST"], "/grade/search", $grade_search);
+ $router->addRoute(["POST"], "/grade/search", $grade_search);
- $router->addRoute(["GET"], "/grade/:primary_key/edit", $grade_edit);
+ $router->addRoute(["GET"], "/grade/:primary_key/edit", $grade_edit);
- $router->addRoute(["GET"], "/grade/:primary_key/delete", $grade_delete);
- }
+ $router->addRoute(["GET"], "/grade/:primary_key/delete", $grade_delete);
+ }
- if(in_array(3, $_SESSION['user_permissions'])){
+ if(in_array(3, $_SESSION['user_permissions'])) {
- $router->addRoute(["GET"], "/user", $user_get);
+ $router->addRoute(["GET"], "/user", $user_get);
- $router->addRoute(["POST"], "/user", $user_post);
+ $router->addRoute(["POST"], "/user", $user_post);
- $router->addRoute(["GET"], "/user/search/:search_query", $user_query);
+ $router->addRoute(["GET"], "/user/search/:search_query", $user_query);
- $router->addRoute(["POST"], "/user/search", $user_search);
+ $router->addRoute(["POST"], "/user/search", $user_search);
- $router->addRoute(["GET"], "/user/:primary_key/edit", $user_edit);
+ $router->addRoute(["GET"], "/user/:primary_key/edit", $user_edit);
- $router->addRoute(["GET"], "/user/:primary_key/delete", $user_delete);
+ $router->addRoute(["GET"], "/user/:primary_key/delete", $user_delete);
- $router->addRoute(["GET"], "/test", $test);
- }
+ $router->addRoute(["GET"], "/test", $test);
+ }
}
-$router->route();
+$router->route()
+\ No newline at end of file
diff --git a/routing/course.php b/routing/course.php
@@ -1,108 +1,109 @@
<?php
-$course_get = function(&$vars){
- global $db;
- $course = $db->get(Model\Course::class);
-
- if(isset($_POST["search"])){
- $course->load($_POST["search"]);
- $data = $course->getData();
- }
- $vars += get_vars($course, "/course", "/course/search", "", "name");
- return "views/course.html";
+
+$course_get = function (&$vars) {
+ global $db;
+ $course = $db->get(Model\Course::class);
+
+ if(isset($_POST["search"])) {
+ $course->load($_POST["search"]);
+ $data = $course->getData();
+ }
+ $vars += get_vars($course, "/course", "/course/search", "", "name");
+ return "views/course.html";
};
-$course_post = function(&$vars){
- global $db;
- $course = $db->get(Model\Course::class);
- $user = $db->get(Model\User::class);
- if(isset($_POST["form_type"])){
- if($user->load($_POST['lecturer'])){
- if($_POST["form_type"] == 'Add'){
- if($course->add_course()){
- $vars["response"] = 'succesfully added: ' . $_POST["name"];
+$course_post = function (&$vars) {
+ global $db;
+ $course = $db->get(Model\Course::class);
+ $user = $db->get(Model\User::class);
+ if(isset($_POST["form_type"])) {
+ if($user->load($_POST['lecturer'])) {
+ if($_POST["form_type"] == 'Add') {
+ if($course->add_course()) {
+ $vars["response"] = 'succesfully added: ' . $_POST["name"];
+ }
+ } elseif($_POST["form_type"] == 'Update') {
+ if($course->update_course()) {
+ $vars["response"] = 'succesfully updated: ' . $_POST["name"];
+ }
+ }
+ } else {
+ $vars["response"] = 'foreign_key constraint on lecturer';
}
- } elseif($_POST["form_type"] == 'Update'){
- if($course->update_course()){
- $vars["response"] = 'succesfully updated: ' . $_POST["name"];
- }
- }
- }else{
- $vars["response"] = 'foreign_key constraint on lecturer';
}
- }
-
- $vars += get_vars($course, "/course", "/course/search", "", "name");
- return "views/course.html";
+
+ $vars += get_vars($course, "/course", "/course/search", "", "name");
+ return "views/course.html";
};
-$course_query = function(&$vars){
- global $db;
- $course = $db->get(Model\Course::class);
- $vars += get_vars($course, "/course", "/course/search", "", "name");
- return "views/course.html";
+$course_query = function (&$vars) {
+ global $db;
+ $course = $db->get(Model\Course::class);
+ $vars += get_vars($course, "/course", "/course/search", "", "name");
+ return "views/course.html";
};
-$course_search = function(&$vars){
- if(isset($_POST['search'])){
- if($_POST['search'] == ""){
- $search = "%";
- }else{
- $search = $_POST['search'];
+$course_search = function (&$vars) {
+ if(isset($_POST['search'])) {
+ if($_POST['search'] == "") {
+ $search = "%";
+ } else {
+ $search = $_POST['search'];
+ }
+ $header = '/course/search/' . $search;
+ header('Location: ' . $header);
+ } else {
+ echo "wtF?";
+ var_dump($_POST);
}
- $header = '/course/search/' . $search;
- header('Location: ' . $header);
- }else{
- echo "wtF?";
- var_dump($_POST);
- }
};
-$course_edit = function(&$vars){
- global $db;
- $course = $db->get(Model\Course::class);
- $data = [];
- $course->load($vars["primary_key"]);
- foreach($course->getData() as $key => $col){
- $data[$key] = $col;
- }
- $vars += get_vars($course, "/course", "/course/search", "", "name", $data);
- return "views/course.html";
+$course_edit = function (&$vars) {
+ global $db;
+ $course = $db->get(Model\Course::class);
+ $data = [];
+ $course->load($vars["primary_key"]);
+ foreach($course->getData() as $key => $col) {
+ $data[$key] = $col;
+ }
+ $vars += get_vars($course, "/course", "/course/search", "", "name", $data);
+ return "views/course.html";
};
-$course_delete = function(&$vars){
- global $db;
- $course = $db->get(Model\Course::class);
- $course->load($vars["primary_key"]);
- $course->delete();
- $vars += get_vars($course, "/course", "/course/search", "", "name");
- return "views/course.html";
+$course_delete = function (&$vars) {
+ global $db;
+ $course = $db->get(Model\Course::class);
+ $course->load($vars["primary_key"]);
+ $course->delete();
+ $vars += get_vars($course, "/course", "/course/search", "", "name");
+ return "views/course.html";
};
-$course_data = function(&$vars){
- global $db;
- $course = $db->get(Model\Course::class);
- $exam = $db->get(Model\Exam::class);
- $course->where("name", $vars["course"]);
- $tmp = $vars["course"];
- $table = "<h1>all exams for $tmp </h1><table> <thead> <tr>";
- foreach($exam->get_column_names() as $column){
- $table .= "<th>$column</th>";
- }
- $table .= "</tr> </thead>";
- $table .= "<tbody>";
-
- foreach($db->all_where(Model\Exam::class, ["course_id" => $course->id]) as $data){
- $table .= "<tr>";
- $col_names = $exam->get_column_names();
- foreach($col_names as $col){
- $table .= '<td>' . $data->{$col} . '</td>';
- }
- $table .= "</tr>";
- };
+$course_data = function (&$vars) {
+ global $db;
+ $course = $db->get(Model\Course::class);
+ $exam = $db->get(Model\Exam::class);
+ $course->where("name", $vars["course"]);
+ $tmp = $vars["course"];
+ $table = "<h1>all exams for $tmp </h1><table> <thead> <tr>";
+ foreach($exam->get_column_names() as $column) {
+ $table .= "<th>$column</th>";
+ }
+ $table .= "</tr> </thead>";
+ $table .= "<tbody>";
+
+ foreach($db->all_where(Model\Exam::class, ["course_id" => $course->id]) as $data) {
+ $table .= "<tr>";
+ $col_names = $exam->get_column_names();
+ foreach($col_names as $col) {
+ $table .= '<td>' . $data->{$col} . '</td>';
+ }
+ $table .= "</tr>";
+ };
- $table .= "
- </tbody></table>";
- $vars['table'] = $table;
- return "views/parent_child.html";
+ $table .= "
+ </tbody></table>";
+ $vars['table'] = $table;
+ return "views/parent_child.html";
};
diff --git a/routing/exam.php b/routing/exam.php
@@ -1,108 +1,109 @@
<?php
-$exam_get = function(&$vars){
- global $db;
- $exam = $db->get(Model\Exam::class);
- if(isset($_POST["search"])){
- $exam->load($_POST["search"]);
- $data = $exam->getData();
- }
- $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
- return "views/exam.html";
+$exam_get = function (&$vars) {
+ global $db;
+ $exam = $db->get(Model\Exam::class);
+
+ if(isset($_POST["search"])) {
+ $exam->load($_POST["search"]);
+ $data = $exam->getData();
+ }
+ $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
+ return "views/exam.html";
};
-$exam_post = function(&$vars){
- global $db;
- $exam = $db->get(Model\Exam::class);
- $course = $db->get(Model\Course::class);
- if(isset($_POST["form_type"])){
- if($course->load($_POST['course_id'])){
- if($_POST["form_type"] == 'Add'){
- if($exam->add_exam()){
- $vars["response"] = 'succesfully added: ' . $_POST["name"];
- }
- } elseif($_POST["form_type"] == 'Update'){
- if($exam->update_exam()){
- $vars["response"] = 'succesfully updated: ' . $_POST["name"];
+$exam_post = function (&$vars) {
+ global $db;
+ $exam = $db->get(Model\Exam::class);
+ $course = $db->get(Model\Course::class);
+ if(isset($_POST["form_type"])) {
+ if($course->load($_POST['course_id'])) {
+ if($_POST["form_type"] == 'Add') {
+ if($exam->add_exam()) {
+ $vars["response"] = 'succesfully added: ' . $_POST["name"];
+ }
+ } elseif($_POST["form_type"] == 'Update') {
+ if($exam->update_exam()) {
+ $vars["response"] = 'succesfully updated: ' . $_POST["name"];
+ }
+ }
+ } else {
+ $vars["response"] = 'foreign_key constraint on course';
}
- }
- }else{
- $vars["response"] = 'foreign_key constraint on course';
}
- }
-
- $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
- return "views/exam.html";
+
+ $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
+ return "views/exam.html";
};
-$exam_query = function(&$vars){
- global $db;
- $exam = $db->get(Model\Exam::class);
- $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
- return "views/exam.html";
+$exam_query = function (&$vars) {
+ global $db;
+ $exam = $db->get(Model\Exam::class);
+ $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
+ return "views/exam.html";
};
-$exam_search = function(&$vars){
- if(isset($_POST['search'])){
- if($_POST['search'] == ""){
- $search = "%";
- }else{
- $search = $_POST['search'];
+$exam_search = function (&$vars) {
+ if(isset($_POST['search'])) {
+ if($_POST['search'] == "") {
+ $search = "%";
+ } else {
+ $search = $_POST['search'];
+ }
+ $header = '/exam/search/' . $search;
+ header('Location: ' . $header);
+ } else {
+ echo "wtF?";
+ var_dump($_POST);
}
- $header = '/exam/search/' . $search;
- header('Location: ' . $header);
- }else{
- echo "wtF?";
- var_dump($_POST);
- }
};
-$exam_edit = function(&$vars){
- global $db;
- $exam = $db->get(Model\Exam::class);
- $data = [];
- $exam->load($vars["primary_key"]);
- foreach($exam->getData() as $key => $col){
- $data[$key] = $col;
- }
- $vars += get_vars($exam, "/exam", "/exam/search", "", "name", $data);
- return "views/exam.html";
+$exam_edit = function (&$vars) {
+ global $db;
+ $exam = $db->get(Model\Exam::class);
+ $data = [];
+ $exam->load($vars["primary_key"]);
+ foreach($exam->getData() as $key => $col) {
+ $data[$key] = $col;
+ }
+ $vars += get_vars($exam, "/exam", "/exam/search", "", "name", $data);
+ return "views/exam.html";
};
-$exam_delete = function(&$vars){
- global $db;
- $exam = $db->get(Model\Exam::class);
- $exam->load($vars["primary_key"]);
- $exam->delete();
- $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
- return "views/exam.html";
+$exam_delete = function (&$vars) {
+ global $db;
+ $exam = $db->get(Model\Exam::class);
+ $exam->load($vars["primary_key"]);
+ $exam->delete();
+ $vars += get_vars($exam, "/exam", "/exam/search", "", "name");
+ return "views/exam.html";
};
-$exam_data = function(&$vars){
- global $db;
- $exam = $db->get(Model\Exam::class);
- $grade = $db->get(Model\Grade::class);
- $exam->where("name", $vars["exam"]);
- $tmp = $vars["exam"];
- $table = "<h1>all grades for $tmp </h1><table> <thead> <tr>";
- foreach($grade->get_column_names() as $column){
- $table .= "<th>$column</th>";
- }
- $table .= "</tr> </thead>";
- $table .= "<tbody>";
-
- foreach($db->all_where(Model\Grade::class, ["exam" => $exam->id]) as $data){
- $table .= "<tr>";
- $col_names = $grade->get_column_names();
- foreach($col_names as $col){
- $table .= '<td>' . $data->{$col} . '</td>';
- }
- $table .= "</tr>";
- };
+$exam_data = function (&$vars) {
+ global $db;
+ $exam = $db->get(Model\Exam::class);
+ $grade = $db->get(Model\Grade::class);
+ $exam->where("name", $vars["exam"]);
+ $tmp = $vars["exam"];
+ $table = "<h1>all grades for $tmp </h1><table> <thead> <tr>";
+ foreach($grade->get_column_names() as $column) {
+ $table .= "<th>$column</th>";
+ }
+ $table .= "</tr> </thead>";
+ $table .= "<tbody>";
- $table .= "
- </tbody></table>";
- $vars['table'] = $table;
- return "views/parent_child.html";
-};
-\ No newline at end of file
+ foreach($db->all_where(Model\Grade::class, ["exam" => $exam->id]) as $data) {
+ $table .= "<tr>";
+ $col_names = $grade->get_column_names();
+ foreach($col_names as $col) {
+ $table .= '<td>' . $data->{$col} . '</td>';
+ }
+ $table .= "</tr>";
+ };
+
+ $table .= "
+ </tbody></table>";
+ $vars['table'] = $table;
+ return "views/parent_child.html";
+};
diff --git a/routing/grade.php b/routing/grade.php
@@ -1,89 +1,89 @@
<?php
-$grade_get = function(&$vars){
- global $db;
- $grade = $db->get(Model\Grade::class);
- $templates = new Controller\Templates($db, $grade);
-
- if(isset($_POST["search"])){
- $grade->load($_POST["search"]);
- $data = $grade->getData();
- }
- $vars += get_vars($grade, "/grade", "/grade/search", "", "email");
- return "views/grade.html";
+
+$grade_get = function (&$vars) {
+ global $db;
+ $grade = $db->get(Model\Grade::class);
+ $templates = new Controller\Templates($db, $grade);
+
+ if(isset($_POST["search"])) {
+ $grade->load($_POST["search"]);
+ $data = $grade->getData();
+ }
+ $vars += get_vars($grade, "/grade", "/grade/search", "", "email");
+ return "views/grade.html";
};
-$grade_post = function(&$vars){
- global $db;
- $grade = $db->get(Model\Grade::class);
- $user = $db->get(Model\User::class);
- $exam = $db->get(Model\Exam::class);
- if($exam->load($_POST['exam'])){
- if($user->load($_POST['email'])){
- if(isset($_POST["form_type"])){
- if($_POST["form_type"] == 'Add'){
- if($grade->add_grade()){
- $vars["response"] = 'succesfully added: ' . $_POST["email"];
- }
- } elseif($_POST["form_type"] == 'Update'){
- if($grade->update_grade()){
+$grade_post = function (&$vars) {
+ global $db;
+ $grade = $db->get(Model\Grade::class);
+ $user = $db->get(Model\User::class);
+ $exam = $db->get(Model\Exam::class);
+ if($exam->load($_POST['exam'])) {
+ if($user->load($_POST['email'])) {
+ if(isset($_POST["form_type"])) {
+ if($_POST["form_type"] == 'Add') {
+ if($grade->add_grade()) {
+ $vars["response"] = 'succesfully added: ' . $_POST["email"];
+ }
+ } elseif($_POST["form_type"] == 'Update') {
+ if($grade->update_grade()) {
$vars["response"] = 'succesfully updated: ' . $_POST["email"];
}
}
}
- }else{
+ } else {
$vars["response"] = 'foreign_key constraint on email';
}
- }else{
+ } else {
$vars["response"] = 'foreign_key constraint on exam';
}
$vars += get_vars($grade, "/grade", "/grade/search", "", "email");
- return "views/grade.html";
+ return "views/grade.html";
};
-$grade_query = function(&$vars){
- global $db;
- $grade = $db->get(Model\Grade::class);
- $vars += get_vars($grade, "/grade", "/grade/search", "", "email");
- return "views/grade.html";
+$grade_query = function (&$vars) {
+ global $db;
+ $grade = $db->get(Model\Grade::class);
+ $vars += get_vars($grade, "/grade", "/grade/search", "", "email");
+ return "views/grade.html";
};
-$grade_search = function(&$vars){
- if(isset($_POST['search'])){
- if($_POST['search'] == ""){
- $search = "%";
- }else{
- $search = $_POST['search'];
+$grade_search = function (&$vars) {
+ if(isset($_POST['search'])) {
+ if($_POST['search'] == "") {
+ $search = "%";
+ } else {
+ $search = $_POST['search'];
+ }
+ $header = '/grade/search/' . $search;
+ header('Location: ' . $header);
+ } else {
+ echo "wtF?";
+ var_dump($_POST);
}
- $header = '/grade/search/' . $search;
- header('Location: ' . $header);
- }else{
- echo "wtF?";
- var_dump($_POST);
- }
};
-$grade_edit = function(&$vars){
- global $db;
- $grade = $db->get(Model\Grade::class);
+$grade_edit = function (&$vars) {
+ global $db;
+ $grade = $db->get(Model\Grade::class);
- $data = [];
- $grade->load($vars["primary_key"]);
- foreach($grade->getData() as $key => $col){
- $data[$key] = $col;
- }
+ $data = [];
+ $grade->load($vars["primary_key"]);
+ foreach($grade->getData() as $key => $col) {
+ $data[$key] = $col;
+ }
- $vars += get_vars($grade, "/grade", "/grade/search", "", "email", $data);
- return "views/grade.html";
+ $vars += get_vars($grade, "/grade", "/grade/search", "", "email", $data);
+ return "views/grade.html";
};
-$grade_delete = function(&$vars){
- global $db;
- $grade = $db->get(Model\Grade::class);
-
- $grade->load($vars["primary_key"]);
- $grade->delete();
+$grade_delete = function (&$vars) {
+ global $db;
+ $grade = $db->get(Model\Grade::class);
- $vars += get_vars($grade, "/grade", "/grade/search", "", "email");
- return "views/grade.html";
-};
+ $grade->load($vars["primary_key"]);
+ $grade->delete();
+ $vars += get_vars($grade, "/grade", "/grade/search", "", "email");
+ return "views/grade.html";
+};
diff --git a/routing/index.php b/routing/index.php
@@ -1,108 +1,109 @@
<?php
-$index_get = function(&$vars){
- if(isset($_SESSION['user_permissions'])){
- header('Location: /dashboard');
- }
- global $db;
- $templates = new Controller\Templates($db, $db->get(\Model\User::class));
- $vars["header"] = $templates->header();
- $vars["login-fields"] = $db->get(Model\User::class)->login_fields();
- return "views/login.html";
-};
-
-$index_post = function(&$vars){
- global $db;
- $res = $db->get(Model\User::class)->login();
- $templates = new Controller\Templates($db, $db->get(\Model\Course::class));
- $vars["header"] = $templates->header();
- if($res == []){
- header("Location: dashboard");
- exit();
- }else{
+$index_get = function (&$vars) {
+ if(isset($_SESSION['user_permissions'])) {
+ header('Location: /dashboard');
+ }
+ global $db;
+ $templates = new Controller\Templates($db, $db->get(\Model\User::class));
+ $vars["header"] = $templates->header();
$vars["login-fields"] = $db->get(Model\User::class)->login_fields();
- $vars["response"] = $res["response"] ;
return "views/login.html";
- }
};
-$dashboard = function(&$vars){
- global $db;
- $vars += $_SESSION;
- $templates = new Controller\Templates($db, $db->get(\Model\Course::class));
- $vars["header"] = $templates->header();
- $course = $db->get(Model\Course::class);
-
- $vars['links'] = $templates->links();
- $enrolled = [];
-
- foreach($db->all_where(Model\CourseUser::class, [ "email" => $_SESSION['email'] ]) as $data) {
- $enrolled[] = $data->id;
- }
-
- $table = "<table> <thead> <tr>";
- foreach($course->get_column_names() as $column){
- $table .= "<th>$column</th>";
- }
- $table .= "<th>registered</th></tr> </thead>";
-
- $objs = $db->all(Model\Course::class);
- $table .= "<tbody>";
- foreach($objs as $obj){
- if (in_array($obj->id, $enrolled)) {
- $enroll_btn = 'Enroll';
- $enroll_action = 'enroll';
+$index_post = function (&$vars) {
+ global $db;
+ $res = $db->get(Model\User::class)->login();
+ $templates = new Controller\Templates($db, $db->get(\Model\Course::class));
+ $vars["header"] = $templates->header();
+ if($res == []) {
+ header("Location: dashboard");
+ exit();
} else {
- $enroll_btn = 'Disenroll';
- $enroll_action = 'disenroll';
+ $vars["login-fields"] = $db->get(Model\User::class)->login_fields();
+ $vars["response"] = $res["response"] ;
+ return "views/login.html";
}
-
- $table .= "<tr>";
- $col_names = $obj->get_column_names();
- foreach($col_names as $col){
- $table .= '<td>' . $obj->{$col} . '</td>';
- }
- $table .= '
+};
+
+$dashboard = function (&$vars) {
+ global $db;
+ $vars += $_SESSION;
+ $templates = new Controller\Templates($db, $db->get(\Model\Course::class));
+ $vars["header"] = $templates->header();
+ $course = $db->get(Model\Course::class);
+
+ $vars['links'] = $templates->links();
+ $enrolled = [];
+
+ foreach($db->all_where(Model\CourseUser::class, [ "email" => $_SESSION['email'] ]) as $data) {
+ $enrolled[] = $data->id;
+ }
+
+ $table = "<table> <thead> <tr>";
+ foreach($course->get_column_names() as $column) {
+ $table .= "<th>$column</th>";
+ }
+ $table .= "<th>registered</th></tr> </thead>";
+
+ $objs = $db->all(Model\Course::class);
+ $table .= "<tbody>";
+ foreach($objs as $obj) {
+ if (in_array($obj->id, $enrolled)) {
+ $enroll_btn = 'Enroll';
+ $enroll_action = 'enroll';
+ } else {
+ $enroll_btn = 'Disenroll';
+ $enroll_action = 'disenroll';
+ }
+
+ $table .= "<tr>";
+ $col_names = $obj->get_column_names();
+ foreach($col_names as $col) {
+ $table .= '<td>' . $obj->{$col} . '</td>';
+ }
+ $table .= '
<td>
<a class="edit" href="/user/'. $_SESSION['email'] . '/course/' . $obj->id . '/' . $enroll_action . '/";>' . $enroll_btn . '</a>
</td>';
- $table .= '</tr>';
- }
+ $table .= '</tr>';
+ }
+
+ $table .= "
+ </tbody></table>";
+
+ $vars['in_course'] = $table;
- $table .= "
- </tbody></table>";
-
- $vars['in_course'] = $table;
-
- return "views/dashboard.html";
+ return "views/dashboard.html";
};
-$logout = function(&$vars){
- session_unset();
- session_destroy();
- header("Location: /");
+$logout = function (&$vars) {
+ session_unset();
+ session_destroy();
+ header("Location: /");
};
-$test = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $permissions = $db->get(Model\Permission::class);
-
- $permission_user = $db->get(Model\PermissionUser::class);
- var_dump($db->all_where(Model\User::class, ["email" => ""]));
- var_dump(get_vars($user, "/user", "/user/search", "", "email", [], $permissions->get_checkboxes(), $permission_user));
+$test = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $permissions = $db->get(Model\Permission::class);
+
+ $permission_user = $db->get(Model\PermissionUser::class);
+ var_dump($db->all_where(Model\User::class, ["email" => ""]));
+ var_dump(get_vars($user, "/user", "/user/search", "", "email", [], $permissions->get_checkboxes(), $permission_user));
};
-function get_vars(Lollipop\DatabaseObject $table, string $action, string $search_action, string $search_string, string $search_key, array $form_data = [], array $extra = [], Model\PermissionUser $permissionUser = null): array{
- global $db;
- $templates = new Controller\Templates($db, $table);
-
- $array = [];
- $array["header"] = $templates->header();
- $array["form"] = $templates->form_v2($action, $form_data, $extra);
- $array["search"] = $templates->search_form($search_action);
- $array["table"] = $templates->crud_table($action, $search_string, $search_key, $permissionUser);
- $array['links'] = $templates->links();
- $array['first_name'] = $_SESSION['first_name'];
- return $array;
+function get_vars(Lollipop\DatabaseObject $table, string $action, string $search_action, string $search_string, string $search_key, array $form_data = [], array $extra = [], Model\PermissionUser $permissionUser = null): array
+{
+ global $db;
+ $templates = new Controller\Templates($db, $table);
+
+ $array = [];
+ $array["header"] = $templates->header();
+ $array["form"] = $templates->form_v2($action, $form_data, $extra);
+ $array["search"] = $templates->search_form($search_action);
+ $array["table"] = $templates->crud_table($action, $search_string, $search_key, $permissionUser);
+ $array['links'] = $templates->links();
+ $array['first_name'] = $_SESSION['first_name'];
+ return $array;
}
diff --git a/routing/user.php b/routing/user.php
@@ -3,103 +3,103 @@
$user->load($_POST["search"]);
$data = $user->getData();
}*/
-$user_get = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $permissions = $db->get(Model\Permission::class);
- $permission_user = $db->get(Model\PermissionUser::class);
- $vars += get_vars($user, "/user", "/user/search", "", "email", [], $permissions->get_checkboxes(), $permission_user);
- return "views/user.html";
+$user_get = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $permissions = $db->get(Model\Permission::class);
+ $permission_user = $db->get(Model\PermissionUser::class);
+ $vars += get_vars($user, "/user", "/user/search", "", "email", [], $permissions->get_checkboxes(), $permission_user);
+ return "views/user.html";
};
-$user_post = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $permissions = $db->get(Model\Permission::class);
- $permission_user = $db->get(Model\PermissionUser::class);
-
- if(isset($_POST["form_type"])){
- if($_POST["form_type"] == 'Add'){
- if($user->add_user() && $permission_user->add_permissions($user)){
- $vars["response"] = 'succesfully added: ' . $_POST["email"];
- }
- }elseif($_POST["form_type"] == 'Update'){
- if($user->update_user() && $permission_user->update_permissions($user)){
- $vars["response"] = 'succesfully updated: ' . $_POST["email"];
- }else{
- echo"something went wrong";
- }
+$user_post = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $permissions = $db->get(Model\Permission::class);
+ $permission_user = $db->get(Model\PermissionUser::class);
+
+ if(isset($_POST["form_type"])) {
+ if($_POST["form_type"] == 'Add') {
+ if($user->add_user() && $permission_user->add_permissions($user)) {
+ $vars["response"] = 'succesfully added: ' . $_POST["email"];
+ }
+ } elseif($_POST["form_type"] == 'Update') {
+ if($user->update_user() && $permission_user->update_permissions($user)) {
+ $vars["response"] = 'succesfully updated: ' . $_POST["email"];
+ } else {
+ echo"something went wrong";
+ }
+ }
}
- }
- $vars += get_vars($user, "/user", "/user/search", "", "email", [], $permissions->get_checkboxes(), $permission_user);
- return "views/user.html";
+ $vars += get_vars($user, "/user", "/user/search", "", "email", [], $permissions->get_checkboxes(), $permission_user);
+ return "views/user.html";
};
-$user_query = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $permissions = $db->get(Model\Permission::class);
- $permission_user = $db->get(Model\PermissionUser::class);
- $query = '%' . $vars['search_query'] . '%';
- $vars += get_vars($user, "/user", "/user/search", $query, "email", [], $permissions->get_checkboxes(), $permission_user);
- return "views/user.html";
+$user_query = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $permissions = $db->get(Model\Permission::class);
+ $permission_user = $db->get(Model\PermissionUser::class);
+ $query = '%' . $vars['search_query'] . '%';
+ $vars += get_vars($user, "/user", "/user/search", $query, "email", [], $permissions->get_checkboxes(), $permission_user);
+ return "views/user.html";
};
-$user_search = function(&$vars){
- if(isset($_POST['search'])){
- if($_POST['search'] == ""){
- $search = "%";
- }else{
- $search = $_POST['search'];
+$user_search = function (&$vars) {
+ if(isset($_POST['search'])) {
+ if($_POST['search'] == "") {
+ $search = "%";
+ } else {
+ $search = $_POST['search'];
+ }
+ $header = '/user/search/' . $search;
+ header('Location: ' . $header);
+ } else {
+ echo "wtF?";
+ var_dump($_POST);
}
- $header = '/user/search/' . $search;
- header('Location: ' . $header);
- }else{
- echo "wtF?";
- var_dump($_POST);
- }
};
-$user_edit = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $permissions = $db->get(Model\Permission::class);
- $permission_user = $db->get(Model\PermissionUser::class);
- $templates = new controller\templates($db, $user);
- $data = [];
- $user->load($vars["primary_key"]);
- foreach($user->getData() as $key => $col){
- $data[$key] = $col;
- }
- $vars += get_vars($user, "/user", "/user/search", "", "email", $data, $permissions->get_checkboxes(), $permission_user);
- return "views/user.html";
+$user_edit = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $permissions = $db->get(Model\Permission::class);
+ $permission_user = $db->get(Model\PermissionUser::class);
+ $templates = new controller\templates($db, $user);
+ $data = [];
+ $user->load($vars["primary_key"]);
+ foreach($user->getData() as $key => $col) {
+ $data[$key] = $col;
+ }
+ $vars += get_vars($user, "/user", "/user/search", "", "email", $data, $permissions->get_checkboxes(), $permission_user);
+ return "views/user.html";
};
-$user_delete = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $permissions = $db->get(Model\Permission::class);
+$user_delete = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $permissions = $db->get(Model\Permission::class);
- $permission_user = $db->get(Model\PermissionUser::class);
- $user->load($vars["primary_key"]);
- $user->delete();
- $vars += get_vars($user, "/user", "/user/search", "", "email", $permissions->get_checkboxes(), [], $permission_user);
- return "views/user.html";
+ $permission_user = $db->get(Model\PermissionUser::class);
+ $user->load($vars["primary_key"]);
+ $user->delete();
+ $vars += get_vars($user, "/user", "/user/search", "", "email", $permissions->get_checkboxes(), [], $permission_user);
+ return "views/user.html";
};
-$user_page = function(&$vars){
- global $db;
- $user = $db->get(Model\User::class);
- $user->load($vars['primary_key']);
- $data = $user->getData();
- if(in_array(3, $_SESSION['user_permissions'])){
- foreach($data as $key => $d){
- $vars['user_data'] .= "<p>your $key = $d<p><br>";
- }
- }elseif($vars['primary'] == $_SESSION['email']){
- foreach($data as $key => $d){
- $vars['user_data'] .= "<p>your $key = $d<p><br>";
+$user_page = function (&$vars) {
+ global $db;
+ $user = $db->get(Model\User::class);
+ $user->load($vars['primary_key']);
+ $data = $user->getData();
+ if(in_array(3, $_SESSION['user_permissions'])) {
+ foreach($data as $key => $d) {
+ $vars['user_data'] .= "<p>your $key = $d<p><br>";
+ }
+ } elseif($vars['primary'] == $_SESSION['email']) {
+ foreach($data as $key => $d) {
+ $vars['user_data'] .= "<p>your $key = $d<p><br>";
+ }
}
- }
- return "views/user_page.html";
-};
-\ No newline at end of file
+ return "views/user_page.html";
+};
diff --git a/utils/autoloader.php b/utils/autoloader.php
@@ -1,8 +1,9 @@
<?php
spl_autoload_register(function ($class_name) {
- if (DIRECTORY_SEPARATOR != "\\")
+ if (DIRECTORY_SEPARATOR != "\\") {
$class_name = str_replace("\\", DIRECTORY_SEPARATOR, $class_name);
+ }
$sr = DIRECTORY_SEPARATOR;
$filename = $class_name . '.php';
@@ -16,4 +17,4 @@ spl_autoload_register(function ($class_name) {
} else {
include $class_name . '.php';
}
-});
-\ No newline at end of file
+});
