Tul xxx Tul

Viewing: Settings.php

<?php
class Settings {
    private $db;

    public function __construct() {
        $this->db = (new Database())->connect();
        $this->ensureSchema();
    }

    private function ensureSchema() {
        $this->db->exec('CREATE TABLE IF NOT EXISTS settings (
            `key` VARCHAR(100) PRIMARY KEY,
            `value` TEXT NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4');
    }

    public function get($key, $default = null) {
        $stmt = $this->db->prepare('SELECT `value` FROM settings WHERE `key` = ? LIMIT 1');
        $stmt->execute([$key]);
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        if (!$row) return $default;
        return $row['value'];
    }

    public function set($key, $value) {
        $stmt = $this->db->prepare('REPLACE INTO settings (`key`, `value`) VALUES (?, ?)');
        return $stmt->execute([$key, $value]);
    }

    public function getJson($key, $default = []) {
        $val = $this->get($key, null);
        if ($val === null || $val === '') return $default;
        $decoded = json_decode($val, true);
        return (is_array($decoded) || is_object($decoded)) ? $decoded : $default;
    }

    public function setJson($key, $value) {
        return $this->set($key, json_encode($value, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES));
    }
}

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