aswi2021mr-proper-gitlab/application/model/DB.php @ 2eab68b9

<?php
class DB {
    // (A) CONNECT TO DATABASE
    public $error = "";
    private $pdo = null;
    private $stmt = null;
    function __construct () {
        try {
            $this->pdo = new PDO(
                "pgsql:host=".DB_HOST.";dbname=".DB_NAME,
                DB_USER, DB_PASSWORD, [
                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
                ]
            );
        } catch (Exception $ex) { die($ex->getMessage()); }
    }

    // (B) CLOSE CONNECTION
    function __destruct(){
        if ($this->stmt!==null) { $this->stmt = null; }
        if ($this->pdo!==null) { $this->pdo = null; }
    }

    // (C) RUN A SELECT QUERY
    function select($sql, $params){
        $result = false;
        try {
            $this->stmt = $this->pdo->prepare($sql);
            if (array_key_exists("lemma", $params)) {
                $this->stmt->bindParam(':lemma',$params['lemma'], PDO::PARAM_STR);
            }
            if (array_key_exists("word", $params)) {
                $this->stmt->bindParam(':word',$params['word'], PDO::PARAM_STR);
            }
            if (array_key_exists("position1", $params)) {
                $this->stmt->bindParam(':position1',$params['position1'], PDO::PARAM_INT);
            }
            if (array_key_exists("position2", $params)) {
                $this->stmt->bindParam(':position2',$params['position2'], PDO::PARAM_INT);
            }
            if (array_key_exists("positiondetail", $params)) {
                $this->stmt->bindParam(':positiondetail',$params['positiondetail'], PDO::PARAM_INT);
            }
            if (array_key_exists("tag", $params)) {
                $this->stmt->bindParam(':tag',$params['tag'], PDO::PARAM_STR);
            }
            if (array_key_exists("manuscript", $params)) {
                for ($x = 0; $x < count($params["manuscript"]); $x += 1) {
                    $this->stmt->bindParam(':manuscript'.$x,$params["manuscript"][$x], PDO::PARAM_INT);
                }
            }
            $this->stmt->execute();
            $result = $this->stmt->fetchAll();
            return $result;
        } catch (Exception $ex) {
            $this->error = $ex->getMessage();
            return false;
        }
    }
}

// (D) DATABASE SETTINGS - CHANGE TO YOUR OWN!
define('DB_HOST', 'localhost');
define('DB_NAME', 'dalimil2');
define('DB_CHARSET', 'utf8');
define('DB_USER', 'postgres');
define('DB_PASSWORD', 'a');