<?php

class database
{

    protected $mysql = [
        'host' => 'host_name',
        'database' => 'db_name',
        'username' => 'db_user',
        'password' => 'db_pass'
    ];

  protected $sqlserver = [
        'host' => 'host_name',
        'database' => 'db_name',
        'username' => 'db_user',
        'password' => 'db_pass'
    ];

    public $mysql_cnn;
    public $sql_server_cnn;


    public function __construct(){

    }

    // connect to mysql database
    public function mysql_connect(){

        $address = $this->mysql['host'];
        $db_name = $this->mysql['database'];
        $db_user = $this->mysql['username'];
        $db_pass = $this->mysql['password'];

        try{
            $this->mysql_cnn = new PDO( "mysql:host=$address;dbname=$db_name", "$db_user", "$db_pass");
            $this->mysql_cnn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        }catch (PDOException $e){
            echo $e->getMessage();
        }
    }

    public function mysql_close(){
        $this->mysql_cnn = null;
    }

    // connect to sql server datbase
    public function sql_server_connect(){

        $address = $this->sqlserver['host'];
        $db_name = $this->sqlserver['database'];
        $db_user = $this->sqlserver['username'];
        $db_pass = $this->sqlserver['password'];

        try{
            $this->sql_server_cnn = new PDO( "sqlsrv:server=$address ; Database=$db_name", "$db_user", "$db_pass");
            $this->sql_server_cnn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        }catch (PDOException $e){
            echo $e->getMessage();
        }
    }

    public function sql_server_close(){
        $this->sql_server_cnn = null;
    }

}