<?php

/* created by ahmad riadi - mis */

ini_set("memory_limit", "-1");
ini_set('max_execution_time', 0);
date_default_timezone_set('Asia/Jakarta');

class database {
    /* start mysql */

    public $host = "localhost";
    public $uname = "root";
    public $pass = "H3ll0w0rld";
    public $db = "dberems_ces";
    public $port = 6715;
    public $mysql_erems = '';

    /* end mysql */

    /* start sql srv */
    public $hostsqlsrv = "VM-WEBAPPS";
    public $unamesqlsrv = "webappsdb";
    public $passsqlsrv = '$bu5w4yP@ssw0rd';
    public $erems = 'erems';
    public $dbmaster = 'dbmaster';
    public $sqlsrv_erems = '';
    public $sqlsrv_dbmaster = '';

    /* end sql srv */

    function __construct() {
        $this->con_mysql_erems();
        $this->con_sqlsrv_dbmaster();
        $this->con_sqlsrv_erems();
    }

    public function con_mysql_erems() {
        $this->dberems_ces = new mysqli($this->host, $this->uname, $this->pass, $this->db, $this->port);
        if ($this->dberems_ces->connect_error) {
            die("Connection failed: " . $this->dberems_ces->connect_error);
        } else {
            echo "success connection to database $this->db mysql <br/>";
        }
    }

    public function con_sqlsrv_dbmaster() {
        $this->sqlsrv_dbmaster = sqlsrv_connect($this->hostsqlsrv, array("Database" => $this->dbmaster, "UID" => $this->unamesqlsrv, "PWD" => $this->passsqlsrv));
        if ($this->sqlsrv_dbmaster === false) {
            die(print_r(sqlsrv_errors(), true));
        } else {
            echo "success connection to database $this->dbmaster sql server <br/>";
        }
    }

    public function con_sqlsrv_erems() {
        $this->sqlsrv_erems = sqlsrv_connect($this->hostsqlsrv, array("Database" => $this->erems, "UID" => $this->unamesqlsrv, "PWD" => $this->passsqlsrv));
        if ($this->sqlsrv_erems === false) {
            die(print_r(sqlsrv_errors(), true));
        } else {
            echo "success connection to database $this->erems sql server <br/>";
        }
    }

}
