<?php
    class Bd_Conexao
    {
        //para alterar estes valores vá ao arquivo configDB
       private static $instancia = NULL; //se der prob mudar p private
       private $server = SERVER;
       private $user = USER;
       private $password =PASSWORD ;
       public static $conexao; //retirar static
       public static $status ="Zerada!"; //retirar static

       protected function __construct()
       {
            if(self::$conexao==NULL){

               self::$conexao = mysqli_connect($this->server, $this->user, $this->password) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
               self::$status = "Iniciada!";
           }
           //$this->ver();
          //return self::$conexao;

       }

       function  __toString() {
           return self::$status;
       }
       //singleton da conexao

       public function getConexao()
       {   //self::getInstancia();
           if((self::$conexao==null) ||(self::$conexao==false)){

            //self::$conexao = mysqli_connect($this->server, $this->user, $this->password) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
            echo "Conexao inexistente!![] <br>";

           }else{echo "Conexao ok!![ ] <br>";}
           //$this->ver();
          return self::$conexao;
       }

       //singleton da classe my_deprecated
       public static function getInstancia()
       {
           if(self::$instancia==NULL)       {
             self::$instancia = new self;

             echo "Nova instancia!![] <br>";
           }else{
               echo "instancia ja existente!![] <br>";
           }
           //self::ver();
           return self::$instancia;
       }

       public function query($sql)
       {
           self::$status = "Requerida Query!";
           //echo var_dump(self::$conexao);
           //return self::$conexao->query($sql)  or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           //mysqli_set_charset(self::$conexao,'utf8');
           $result = mysqli_query(self::$conexao,$sql) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return $result;
        }

       public function prepare($sql)
       {
           $result = mysqli_prepare(self::$conexao,$sql) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return $result;
       }

       public function multiquery($sql)
       {
           mysqli_set_charset($this->getConexao(),'utf8');
           $r = mysqli_multi_query( $this->getConexao(),$sql) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return $r;
        }

       public function select_db($db)
       {   //$this->getConexao();
           self::$status = "Requerira BD!";
           $r = mysqli_select_db(self::$conexao, $db) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return  $r;
        }

      //TRANSACTIONS
       public function transaction()
       {
           $r = mysqli_autocommit(self::$conexao, FALSE) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return  $r;
        }

        public function commit()
       {
           $r = mysqli_commit(self::$conexao) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return  $r;
        }

        public function rollback()
       {
           $r = mysqli_rollback(self::$conexao) or die("erro: ".mysqli_error(self::$conexao)." num: ".mysqli_errno(self::$conexao));
           return  $r;
        }

        public function __destruct()
       {
           if(self::$conexao){mysqli_close(self::$conexao) or die("Houve um erro ao fechar a conexão"); }
           self::$conexao = "Finalizada!";
           return $r;
       }
    }
    ?>