23 lines
717 B
PHP
23 lines
717 B
PHP
<?php
|
|
namespace app\Models;
|
|
|
|
use PDO;
|
|
|
|
class SystemSettingModel extends Model {
|
|
|
|
public function getSetting($key, $default = '') {
|
|
$stmt = $this->db->prepare("SELECT setting_value FROM system_settings WHERE setting_key = ?");
|
|
$stmt->execute([$key]);
|
|
$row = $stmt->fetch(PDO::FETCH_ASSOC);
|
|
return $row ? $row['setting_value'] : $default;
|
|
}
|
|
|
|
public function setSetting($key, $value) {
|
|
$sql = "INSERT INTO system_settings (setting_key, setting_value)
|
|
VALUES (?, ?)
|
|
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value)";
|
|
$stmt = $this->db->prepare($sql);
|
|
return $stmt->execute([$key, $value]);
|
|
}
|
|
}
|