src/App/Models/product.php | ●●●●● patch | view | raw | blame | history | |
src/Framework/Model.php | ●●●●● patch | view | raw | blame | history |
src/App/Models/product.php
@@ -3,31 +3,8 @@ use App\Database; use PDO; class Product { public function __construct(private Database $database) { } public function getData(): array { $pdo = $this->database->getConnection(); $stmt = $pdo->query("SELECT * FROM product"); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function find(string $id) { $conn = $this->database->getConnection(); $sql = "SELECT * FROM product WHERE id = :id"; $stmt = $conn->prepare($sql); $stmt->bindValue(":id", $id, PDO::PARAM_INT); $stmt->execute(); return $stmt->fetch(PDO::FETCH_ASSOC); } } use Framework\Model; class Product extends Model {} ?> src/Framework/Model.php
New file @@ -0,0 +1,33 @@ <?php namespace Framework; use App\Database; use PDO; abstract class Model { public function __construct(private Database $database) { } public function findAll(): array|bool { $pdo = $this->database->getConnection(); $stmt = $pdo->query("SELECT * FROM product"); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function find(string $id) { $conn = $this->database->getConnection(); $sql = "SELECT * FROM product WHERE id = :id"; $stmt = $conn->prepare($sql); $stmt->bindValue(":id", $id, PDO::PARAM_INT); $stmt->execute(); return $stmt->fetch(PDO::FETCH_ASSOC); } } ?>