commit 6b9ad8163a7a37c0a96dc5a25a1348e8d7f86df2
parent f61c789548b74fbcd8fd5c1aadf49aab1b24759e
Author: Gerco van Woudenbergh <[email protected]>
Date: Tue, 11 Apr 2023 12:13:32 +0200
autoloader
Diffstat:
7 files changed, 250 insertions(+), 129 deletions(-)
diff --git a/Lollipop/SQLDatabase.php b/Lollipop/SQLDatabase.php
@@ -0,0 +1,114 @@
+<?php
+
+namespace Lollipop;
+
+use mysqli;
+
+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();
+ }
+
+ abstract static function get_primary(): string;
+ abstract static function get_table(): string;
+
+ public function load(string $id): bool
+ {
+ $sql = "SELECT * FROM {$this->table} WHERE {$this->primary} = ?";
+
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->bind_param("s", $id);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ if ($result->num_rows == 0) {
+ return false;
+ }
+
+ $this->data = $result->fetch_assoc();
+ return true;
+ }
+
+ public function save()
+ {
+ if (!$this->changed_keys)
+ return;
+
+ $sql = "UPDATE {$this->table} SET ";
+
+ $values = [];
+ $types = "";
+ foreach ($this->changed_keys as $index => $key) {
+ if ($index > 0)
+ $sql .= ', ';
+ $sql .= "$key = ?";
+ $values[] = $this->data[$key];
+ $types .= 's';
+ }
+
+ $sql .= " WHERE $this->primary = ?";
+ $values[] = $this->data[$this->primary];
+ $types .= 's';
+
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->bind_param($types, ...$values);
+ $stmt->execute();
+
+ $this->changed_keys = [];
+ }
+
+ public function delete()
+ {
+ $sql = "DELETE FROM {$this->table} WHERE {$this->primary} = ?";
+ $stmt = $this->db->conn->prepare($sql);
+ $stmt->bind_param("s", $this->data[$this->primary]);
+ $stmt->execute();
+ $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;
+ }
+}
+
+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, $name)
+ {
+ $cls = new $table_class($this);
+ $cls->load($name);
+ return $cls;
+ }
+}
+?>
+\ No newline at end of file
diff --git a/autoloader.php b/autoloader.php
@@ -0,0 +1,17 @@
+<?php
+ spl_autoload_register(function ($class_name) {
+ $DIR = dirname(__FILE__);
+ $sr = '\\';
+ $filename = $DIR . $sr .$class_name . '.php';
+ if(! file_exists($filename)){
+ $filename = $DIR . $sr .'classes' . $sr . $class_name . '.php';
+ if(! file_exists($filename)){
+ return false;
+ }else{
+ include 'classes' . $sr . $class_name . '.php';
+ }
+ }else{
+ include $class_name . '.php';
+ }
+ });
+?>
+\ No newline at end of file
diff --git a/classes/User.php b/classes/User.php
@@ -0,0 +1,14 @@
+<?php
+class User extends Lollipop\DatabaseObject
+{
+ static function get_table(): string
+ {
+ return "user";
+ }
+
+ static function get_primary(): string
+ {
+ return "email";
+ }
+}
+?>
+\ No newline at end of file
diff --git a/login.php b/login.php
@@ -0,0 +1,94 @@
+<!DOCTYPE html>
+<html>
+<head>
+ <title>Login Page</title>
+ <!-- Add the Bootstrap CSS stylesheet -->
+ <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
+</head>
+<body>
+ <div class="container mt-5">
+ <div class="row justify-content-center">
+ <div class="col-md-6">
+ <div class="card">
+ <div class="card-header">Login</div>
+ <div class="card-body">
+ <form method="POST" action="login.php">
+ <div class="form-group">
+ <label for="email">Email:</label>
+ <input type="email" class="form-control" id="email" name="email" placeholder="Enter email">
+ </div>
+ <div class="form-group">
+ <label for="password">Password:</label>
+ <input type="password" class="form-control" id="password" name="password" placeholder="Enter password">
+ </div>
+ <button type="submit" class="btn btn-primary">Login</button>
+ </form>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <!-- Add the Bootstrap JavaScript library (optional) -->
+ <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
+ <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
+ <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
+ <?php
+ $servername = "86.92.67.21";
+ $username = "friedel";
+ $password = "hailiwa";
+ $dbname = "wap2";
+ $conn = mysqli_connect($servername, $username, $password, $dbname);
+ // perform validation and authentication
+ if (!$conn) {
+ die("Connection failed: " . mysqli_connect_error());
+ }
+
+ // check if a post request was sent
+ if ($_SERVER["REQUEST_METHOD"] == "POST") {
+ // fetch data from the form
+ if(isset($_POST['email']) && isset($_POST['password'])){
+ $email = $_POST['email'];
+ $pwd = $_POST['password'];
+ } else {
+ echo "One of the forms was empty";
+ }
+
+ // create, prepare sql statement and execute sql statement
+ $sql = "select m.email, m.wachtwoord, pm.permissie_id, pm.permissie_naam
+ from medewerkers m
+ join medewerkers_permissie mp on mp.email = m.email
+ join permissie pm on pm.permissie_id = mp.permissie_id
+ where m.email = ?";
+ $stmt= $conn->prepare($sql);
+ $stmt->bind_param("s", $email);
+ $stmt->execute();
+ $result = $stmt->get_result();
+
+ // verification logic and $_SESSION start
+ if(count($row = $result->fetch_assoc()) > 0){
+ if($email == $row['email'] && password_verify($pwd, $row['wachtwoord'])) {
+ session_start();
+ $_SESSION['email'] = $row['email'];
+ mysqli_data_seek($result, 0);
+ $permissions = array();
+ $permissions_names = array();
+ while($row = mysqli_fetch_assoc($result)){
+ array_push($permissions, $row['permissie_id']);
+ array_push($permissions_names, $row['permissie_naam']);
+ }
+ $_SESSION['permissions'] = $permissions;
+ $_SESSION['permissions_names'] = $permissions_names;
+ foreach($_SESSION['permissions'] as $bullshit){
+ echo $bullshit . "<br>";
+ }
+ header('Location: dashboard.php');
+ } else {
+ echo '<p style="color:red">Invalid username or password.</p>';
+ }
+ } else {
+ echo '<p style="color:red">Invalid username or password.</p>';
+ }
+ }
+ ?>
+ </body>
+</html>
+\ No newline at end of file
diff --git a/orm.php b/orm.php
@@ -1,113 +0,0 @@
-<?php
-
-namespace Lollipop;
-
-use mysqli;
-
-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();
- }
-
- abstract static function get_primary(): string;
- abstract static function get_table(): string;
-
- public function load(string $id): bool
- {
- $sql = "SELECT * FROM {$this->table} WHERE {$this->primary} = ?";
-
- $stmt = $this->db->conn->prepare($sql);
- $stmt->bind_param("s", $id);
- $stmt->execute();
- $result = $stmt->get_result();
-
- if ($result->num_rows == 0) {
- return false;
- }
-
- $this->data = $result->fetch_assoc();
- return true;
- }
-
- public function save()
- {
- if (!$this->changed_keys)
- return;
-
- $sql = "UPDATE {$this->table} SET ";
-
- $values = [];
- $types = "";
- foreach ($this->changed_keys as $index => $key) {
- if ($index > 0)
- $sql .= ', ';
- $sql .= "$key = ?";
- $values[] = $this->data[$key];
- $types .= 's';
- }
-
- $sql .= " WHERE $this->primary = ?";
- $values[] = $this->data[$this->primary];
- $types .= 's';
-
- $stmt = $this->db->conn->prepare($sql);
- $stmt->bind_param($types, ...$values);
- $stmt->execute();
-
- $this->changed_keys = [];
- }
-
- public function delete()
- {
- $sql = "DELETE FROM {$this->table} WHERE {$this->primary} = ?";
- $stmt = $this->db->conn->prepare($sql);
- $stmt->bind_param("s", $this->data[$this->primary]);
- $stmt->execute();
- $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;
- }
-}
-
-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, $name)
- {
- $cls = new $table_class($this);
- $cls->load($name);
- return $cls;
- }
-}
-\ No newline at end of file
diff --git a/routing.php b/routing.php
@@ -0,0 +1,5 @@
+<?php
+if($_SERVER['GET'])
+{
+ rout
+};
+\ No newline at end of file
diff --git a/test_orm.php b/test_orm.php
@@ -1,20 +1,6 @@
<?php
-use Lollipop\DatabaseObject;
-require_once "orm.php";
-
-class User extends DatabaseObject
-{
- static function get_table(): string
- {
- return "user";
- }
-
- static function get_primary(): string
- {
- return "email";
- }
-}
+include "autoloader.php";
$db = new Lollipop\SQLDatabase("86.92.67.21", "friedel", "hailiwa", "lollipop");
