commit bcc9a36bb5488725bb9f0022b396e738d9264c78
parent 65149823272f79f28ac6defeeabf38ee1b53ba95
Author: Friedel Schön <[email protected]>
Date: Tue, 27 Jun 2023 23:58:53 +0200
updating Lollipop
Diffstat:
6 files changed, 739 insertions(+), 499 deletions(-)
diff --git a/Lollipop/DatabaseObject.php b/Lollipop/DatabaseObject.php
@@ -1,129 +1,146 @@
<?php
namespace Lollipop {
- require_once "SQLDatabase.php";
-
- abstract class DatabaseObject
- {
- protected string $table;
- protected string $primary;
-
- protected SQLDatabase $db;
- protected array $data = [];
- protected array $changed_keys = [];
-
- function __construct(SQLDatabase $db)
- {
- $this->db = $db;
- $this->primary = $this->get_primary();
- $this->table = $this->get_table();
- $this->notNullable();
- }
-
- abstract static function get_primary(): string;
- abstract static function get_table(): 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 .= ', ';
}
@@ -137,61 +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;
- }
- private function notNullable(){
- //non-auto-increment not-nullable collumn names query
- $not_null = [];
- $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 = 'panda'";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return false;
- }
- while($tmp = $result->fetch_assoc()){
- if($tmp["is_nullable"] == 'NO'){
- if($tmp["extra"] == "auto_increment")
- continue;
- $not_null[] = $tmp["column_name"];
- }
- $col_names[] = $tmp["column_name"];
- }
- $this->data["not_nullable"] = $not_null;
- $this->data["column_names"] = $col_names;
- return true;
- }
- }
-}
-\ No newline at end of file
+ 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;
+ }
+
+ /// 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;
+ }
+
+ /// 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;
+ }
+
+ /// 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;
+ }
+
+ /// 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;
+ }
+ }
+}
diff --git a/Lollipop/Router.php b/Lollipop/Router.php
@@ -1,86 +1,116 @@
<?php
namespace Lollipop {
- class Router
- {
- protected array $routes = [];
- protected string $path;
- protected Template $temp;
-
- public function __construct($temp) {
- $this->temp = $temp;
- }
-
- 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))
- echo $this->temp->template($fil, $vars);
- return;
- } else {
- echo $this->temp->template($route["func"], $vars);
- return;
- }
- }
- }
-
- echo $this->temp->template("views/login.html", $vars);
- 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)) {
+ return;
+ }
+ $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!";
+ header("Location: /");
+ 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,167 +1,103 @@
-<?php
+<?php
+
namespace Lollipop {
-use ErrorException;
- Class Template{
- function template(string $uri, array $data) : string{
+ 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;
+ }
+
+ 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);
- }
-
- private function eval_tokens(array $tokens, array $data) {
- $funcs = [
- "add" => function(array &$tokens) {
- $right = array_pop($tokens);
- $left = array_pop($tokens);
-
- if (is_null($left) || is_null($right))
- throw new ErrorException("Stack is empty");
+ 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;
+ }
- return $left + $right;
- },
- "sub" => function(array &$tokens) {
- $right = array_pop($tokens);
- $left = array_pop($tokens);
-
- if (is_null($left) || is_null($right))
- throw new ErrorException("Stack is empty");
+ private function parse_template(string $expr, array $data)
+ {
+ $tokens = [];
+ $in_string = false;
+ $buffer = '';
- return intval($left) - intval($right);
- },
- "mul" => function(array &$tokens) {
- $right = array_pop($tokens);
- $left = array_pop($tokens);
-
- if (is_null($left) || is_null($right))
- throw new ErrorException("Stack is empty");
+ 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 intval($left) * intval($right);
- },
- "div" => function(array &$tokens) {
- $right = array_pop($tokens);
- $left = array_pop($tokens);
-
- if (is_null($left) || is_null($right))
- throw new ErrorException("Stack is empty");
+ return $this->eval_tokens($tokens, $data);
+ }
- return intval($left) / intval($right);
- },
- "cat" => function(array &$tokens) {
- $right = array_pop($tokens);
- $left = array_pop($tokens);
-
- if (is_null($left) || is_null($right))
- throw new ErrorException("Stack is empty");
+ 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;
+ }
+ }
- return $left . $right;
- },
-
- "to_int" => function(array &$tokens) {
- $val = array_pop($val);
-
- if (is_null($val))
- throw new ErrorException("Stack is empty");
-
- return inval($val);
- },
-
- "include" => function (array &$tokens) {
- $name = array_pop($tokens);
-
- if ($name == null)
- throw new ErrorException("Stack is empty");
-
- include($name);
- },
- "eval" => function (array &$tokens) {
- $expr = array_pop($tokens);
-
- if (is_null($expr))
- throw new ErrorException("Stack is empty");
-
- return eval("return ($expr);");
- },
- "format_if" => function (array &$stack) {
- $format_false = array_pop($stack);
- $format_true = array_pop($stack);
- $expr = array_pop($stack);
-
- if (is_null($expr) || is_null($format_true) || is_null($format_false))
- throw new ErrorException("Stack is empty");
-
- if ($expr == "")
- return $format_false;
- else
- return str_replace("%%", $expr, $format_true);
- },
- ];
-
- $stack = [];
- foreach ($tokens as $token) {
- if ($token && $token[0] == '!') {
- $val = $funcs[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
@@ -0,0 +1,119 @@
+<?php
+
+namespace Lollipop {
+
+ /// this class contains all built-in functions for the templater
+ class TemplateMethods
+ {
+ public static function add(array &$tokens)
+ {
+ $right = array_pop($tokens);
+ $left = array_pop($tokens);
+
+ if (is_null($left) || is_null($right)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return $left + $right;
+
+ }
+
+ public static function sub(array &$tokens)
+ {
+ $right = array_pop($tokens);
+ $left = array_pop($tokens);
+
+ if (is_null($left) || is_null($right)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return intval($left) - intval($right);
+ }
+
+ public static function mul(array &$tokens)
+ {
+ $right = array_pop($tokens);
+ $left = array_pop($tokens);
+
+ if (is_null($left) || is_null($right)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return intval($left) * intval($right);
+ }
+
+ public static function div(array &$tokens)
+ {
+ $right = array_pop($tokens);
+ $left = array_pop($tokens);
+
+ if (is_null($left) || is_null($right)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return intval($left) / intval($right);
+ }
+
+ public static function cat(array &$tokens)
+ {
+ $right = array_pop($tokens);
+ $left = array_pop($tokens);
+
+ if (is_null($left) || is_null($right)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return $left . $right;
+ }
+
+ public static function to_int(array &$tokens)
+ {
+ $val = array_pop($val);
+
+ if (is_null($val)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return inval($val);
+ }
+
+ public static function include(array &$tokens)
+ {
+ $name = array_pop($tokens);
+
+ if ($name == null) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ include($name);
+ }
+
+ public static function eval(array &$tokens)
+ {
+ $expr = array_pop($tokens);
+
+ if (is_null($expr)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ return eval("return ($expr);");
+ }
+
+ public static function format_if(array &$stack)
+ {
+ $format_false = array_pop($stack);
+ $format_true = array_pop($stack);
+ $expr = array_pop($stack);
+
+ if (is_null($expr) || is_null($format_true) || is_null($format_false)) {
+ throw new ErrorException("Stack is empty");
+ }
+
+ if ($expr == "") {
+ return $format_false;
+ } else {
+ return str_replace("%%", $expr, $format_true);
+ }
+ }
+ }
+}
diff --git a/Lollipop/Utils.php b/Lollipop/Utils.php
@@ -0,0 +1,34 @@
+<?php
+
+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;
+ }
+
+ 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;
+ }
+ }
+}
