| | |
| | | use PDO; |
| | | abstract class Model |
| | | { |
| | | protected ?string $table; |
| | | public function __construct(private Database $database) { |
| | | |
| | | } |
| | |
| | | { |
| | | $pdo = $this->database->getConnection(); |
| | | |
| | | $stmt = $pdo->query("SELECT * FROM product"); |
| | | $sql = "SELECT * FROM {$this->table}"; |
| | | |
| | | $stmt = $pdo->query($sql); |
| | | |
| | | return $stmt->fetchAll(PDO::FETCH_ASSOC); |
| | | } |
| | |
| | | public function find(string $id) { |
| | | $conn = $this->database->getConnection(); |
| | | $sql = "SELECT * |
| | | FROM product |
| | | FROM {$this->table} |
| | | WHERE id = :id"; |
| | | $stmt = $conn->prepare($sql); |
| | | $stmt->bindValue(":id", $id, PDO::PARAM_INT); |