mint/api-v8/public/app/hostsetting/function.php

<?php
require_once '../config.php';

class Hostsetting
{
    public $dbh;
    public function __construct()
    {
        $dns = _FILE_DB_HOSTSETTING_;
        $this->dbh = new PDO($dns, _DB_USERNAME_,_DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true));
        $this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
    }

    public function get($key)
    {
        if ($this->dbh) {
            $query = "SELECT value FROM "._TABLE_HOSTSETTING_." WHERE key= ? ";
            $stmt = $this->dbh->prepare($query);
            $stmt->execute(array($key));
            $row = $stmt->fetch(PDO::FETCH_NUM);
            if ($row) {
                return $row[0];
            } else {
                return false;
            }
        } else {
            return false;
        }
    }

    public function set($key, $value)
    {
        if ($this->dbh) {
            $query = "UPDATE "._TABLE_HOSTSETTING_." SET value = ? , updated_at = now() WHERE key= ? ";
            $stmt = $this->dbh->prepare($query);
            $stmt->execute(array($value, $key));
            if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
                $error = PDO_ErrorInfo();
                return false;
            } else {
                return true;
            }
        } else {
            return false;
        }
    }
}