| commit | author | age | ||
| 766451 | 1 | <?php |
| F | 2 | namespace Framework; |
| 3 | ||
| 4 | use App\Database; | |
| 5 | use PDO; | |
| 6 | abstract class Model | |
| 7 | { | |
| d7a326 | 8 | protected ?string $table; |
| 766451 | 9 | public function __construct(private Database $database) { |
| F | 10 | |
| 11 | } | |
| 12 | public function findAll(): array|bool | |
| 13 | { | |
| 14 | $pdo = $this->database->getConnection(); | |
| 15 | ||
| d7a326 | 16 | $sql = "SELECT * FROM {$this->table}"; |
| F | 17 | |
| 18 | $stmt = $pdo->query($sql); | |
| 766451 | 19 | |
| F | 20 | return $stmt->fetchAll(PDO::FETCH_ASSOC); |
| 21 | } | |
| 22 | ||
| 23 | public function find(string $id) { | |
| 24 | $conn = $this->database->getConnection(); | |
| 25 | $sql = "SELECT * | |
| d7a326 | 26 | FROM {$this->table} |
| 766451 | 27 | WHERE id = :id"; |
| F | 28 | $stmt = $conn->prepare($sql); |
| 29 | $stmt->bindValue(":id", $id, PDO::PARAM_INT); | |
| 30 | $stmt->execute(); | |
| 31 | return $stmt->fetch(PDO::FETCH_ASSOC); | |
| 32 | } | |
| 33 | } | |
| 34 | ||
| 35 | ||
| 36 | ?> | |
