Tul xxx Tul

Viewing: Quote.php

<?php
class Quote {
    private $db;
    public function __construct() {
        $this->db = (new Database())->connect();
    }
    public function getAll() {
        $stmt = $this->db->query('SELECT * FROM quotes ORDER BY id ASC');
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    public function getQuoteOfDay() {
        $quotes = $this->getAll();
        if (empty($quotes)) return null;
        $index = (int)date('z') % count($quotes);
        return $quotes[$index];
    }
    public function create($frase, $autor) {
        $stmt = $this->db->prepare('INSERT INTO quotes (frase, autor) VALUES (?, ?)');
        return $stmt->execute([$frase, $autor]);
    }
    public function delete($id) {
        $stmt = $this->db->prepare('DELETE FROM quotes WHERE id = ?');
        return $stmt->execute([$id]);
    }
}

User / IP	: 216.73.216.159
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64