commit 0cedbc177bce864d55723eec04cfb7b70b83154f
parent f645cb6b89a2ad954019c5c5dc4433cd4a9b4075
Author: MoiBaguette <[email protected]>
Date: Wed, 12 Apr 2023 16:14:35 +0200
debugs
Diffstat:
2 files changed, 55 insertions(+), 2 deletions(-)
diff --git a/Lollipop/DatabaseObject.php b/Lollipop/DatabaseObject.php
@@ -29,7 +29,7 @@ namespace Lollipop {
public function load(string $id): bool
{
- $sql = "SELECT * FROM {$this->table} WHERE {$this->primary} = ?";
+ $sql = "SELECT * FROM {$this->table} WHERE {$this->primary} LIKE ?";
$stmt = $this->db->conn->prepare($sql);
$stmt->execute([$id]);
@@ -137,7 +137,7 @@ namespace Lollipop {
if ($i > 0) {
$sql .= ' AND ';
}
- $sql .= " $key = ?";
+ $sql .= " $key LIKE ?";
$params[] = $value;
$i++;
}
diff --git a/searchuser.php b/searchuser.php
@@ -0,0 +1,53 @@
+<?php
+ include "navbar.php";
+ include "utils/autoloader.php";
+?>
+<html>
+ <head>
+ <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ </head>
+<body>
+ <form class="d-flex" action="searchuser.php" method="post">
+ <input class="form-control me-2" type="search" name="search" placeholder="Search" aria-label="Search">
+ <button class="btn btn-outline-success" type="submit">Search</button>
+</form>
+ <?php
+ if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['search'])) {
+ $search = $_POST['search'];
+ $search = array('email' => "%" . $search . "%");
+ $db = new Lollipop\SQLDatabase("86.92.67.21", "friedel", "hailiwa", "lollipop");
+ $u = $db->loadtable(User::class);
+ $u->all_where($search);
+ $data = $u->getData();
+ // verification logic and $_SESSION start
+ if(count($data) > 0){
+ echo "<table class=\"table table-striped\">
+ <thead>
+ <tr>
+ <th>E-mail</th>
+ <th>First name</th>
+ <th>Last name</th>
+ <th>Action</th>
+ </tr>
+ </thead>
+ <tbody>";
+ foreach ($data as $user) {
+ $link = "/alteruser.php?email=" . $user['email'];
+ echo "<tr>";
+ echo "<td>" . $user['email'] . "</td>";
+ echo "<td>" . $user['fname'] . "</td>";
+ echo "<td>" . $user['lname'] . "</td>";
+ echo "<td><a href='" . $link . "'>Edit</a></td>";
+ echo "</tr>";
+ }
+ echo"
+ </tbody>
+ </table>";
+ }else{
+ echo "No users with this email address were found.";
+ }
+ }
+ ?>
+ </body>
+</html>
+
