<?php
  //config.banco.php
class DatabaseManager {

    private $CLAS_NAME = "DatabaseManager";
    private $dbo_servername = "127.0.0.1";
    private $dbo_username = "root";
    private $dbo_password = "";
    private $dbo_database = "cpdos";

    protected $db_conx = null; //link conexao com banco

    public function __construct(){
        $msgLog = 'A classe "'.$CLAS_NAME. '" foi instanciada!';
        error_log(date('Y-m-d H:i:s')." ".$msgLog."<br>n", 3, "./logs.database.log");
    }

    public function __destruct(){
        $msgLog = 'A classe "'.$CLAS_NAME.'" foi destruída.<br />';
        error_log(date('Y-m-d H:i:s').$msgLog."<br>n", 3, "./logs.database.log");
    }

    public function __toString(){

    }

    public function abreConexao(){
        if($db_conx==null){
            $db_conx = mysqli_connect($dbo_servername,$dbo_username,$dbo_password,$dbo_database);
            if (mysqli_connect_errno()) {
                $msgLog = "Failed to connect to MySQL: " . mysqli_connect_error();
                error_log(date('Y-m-d H:i:s')." ".$msgLog."<br>n", 3, "./logs.database.log");
                echo $msgLog;

                return false;
            }

            mysqli_query($db_conx,"SET NAMES 'utf8'");
            mysqli_query($db_conx,'SET character_set_connection=utf8');
            mysqli_query($db_conx,'SET character_set_client=utf8');
            mysqli_query($db_conx,'SET character_set_results=utf8');
        }
      return true;
    }

    public function autoDestruir(){
        unset($this);
    }

    public function fechaConexao(){
        if($db_conx!=null){
            mysqli_close($db_conx);
        }
    }

    protected function execSQL($sql){
        $rs = mysqli_query($db_conx,$sql) or die('Error: ' . mysqli_error($db_conx));
        if($rs){
            return true;
        }
        else return mysqli_error($db_conx);
    }

}