<?php

    class ConexionBD
    {

        protected $Conexion;
        function ConexionBD_Conectarse($Servidor,$Usuario,$Contra)
        {
            $this->$Conexion = new mysqli($Servidor, $Usuario, $Contra);
            if ($this->$Conexion->connect_error) {

             die("Fallo la conexion: " . $this->$Conexion->connect_error);

              }
                echo "Conexion realizada satisfactoriamente\n";
        }

        function ConexionBD_ConectarsePDO($Servidor,$Usuario,$Contra,$BasedeDatos)
        {
            try {
                $this->$Conexion = new PDO("mysql:host=$Servidor;dbname=$BasedeDatos", $Usuario, $Contra);
                $this->$Conexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                echo "Conexion realizada satisfactoriamente";
            }
            catch(PDOException $e)
            {
                echo "Fallo la conexion: " . $e->getMessage();
            }
        }

        function ConexionBD_Seleccionar($Consulta)
        {

            $result = $this->$Conexion->query($Consulta);
        }
        function ConexionBD_Desconectar()
        {
            $this->$Conexion->close();
        }
         function ConexionBD_DesconectarPDO($Consulta)
        {

            $result = $this->$Conexion->query($Consulta);
        }
    }

/*
$driver = 'mysql';
$database = "dbname=CODINGGROUND";
$dsn = "$driver:host=localhost;$database";

$username = 'root';
$password = 'root';

try {
   $conn = new PDO($dsn, $username, $password);
   echo "Database CODINGGROUND Connected\n";
}catch(PDOException $e){
   echo $e->getMessage();
}
*/
$Con = new ConexionBD;
$Con->ConexionBD_ConectarsePDO('localhost','root','root','CODINGGROUND');
$sql = 'SELECT  * FROM users';
$Con->ConexionBD_Desconectar();
//$Resultado= $Con->ConexionBD_Seleccionar($sql);
/*$stmt = $Con->prepare($sql);
$stmt->execute();

while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
  foreach($row as $value)
  {
    echo sprintf("%s, ", $value);
  }
  echo "\n";
}*/
?>