                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
<?php
class Setting {
  private $db;

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

  // Get all settings as key-value array
  public function getSettings(){
    $this->db->query('SELECT * FROM settings');
    $results = $this->db->resultSet();
    $settings = [];
    foreach($results as $row){
      $settings[$row->setting_key] = $row->setting_value;
    }
    return $settings;
  }

  // Update a single setting
  public function updateSetting($key, $value){
    $this->db->query('UPDATE settings SET setting_value = :setting_value WHERE setting_key = :setting_key');
    $this->db->bind(':setting_key', $key);
    $this->db->bind(':setting_value', $value);

    if($this->db->execute()){
      return true;
    } else {
      return false;
    }
  }
}