[PHP] pobierz, plaintext 
<?php
 
class Database 
{
    private $server = 'KONRADSQLEXPRESS';
    private $db = "health";
    private $login = "health";
    private $pass = "health";
    
    private $link = null;
    private static $instance;
    
    public function __construct()
    {
        try {
            $this->link = new PDO ('mssql:host='.$this->server.';dbname='.$this->db, $this->login, $this->pass);
        } catch (PDOException $e) {
            die($e->getMessage() . "<br />" . $e->getTraceAsString());
        }
    }
    
    public static function getInstance()
    {
        if ( self::$instance ) return self::$instance;
        return self::$instance = new Database();
    }
    
    public function query($query, $values)
    {
        $stmt = $this->link->prepare($query);
        $stmt->execute($values);
 
        return $stmt->fetchAll();
    }
}
 
?>
[PHP] pobierz, plaintext