<?php 
//=============================================================================
//CONEXION---------------------------------------------------------------------
//=============================================================================
require_once 'conexion/conexion.php';
$bd = new connexion();
$bd->query("SET NAMES 'utf8'");
//CONSTANTES DE LA NUEVA CONEXION----------------------------------------------
define( 'LLAVE_ENC', 'gestoria2021');
define( 'DESC',     'Base de datos test 2');
define( "HOST_G", 	"185.37.226.136" );
define( "USER_G", 	"testpapelcero" );
define( "PASS_G", 	"@20Testpapelcero20" );
define( "NAME_G", 	"papelcero_test" );
define( "PORT_G", 	"3306" );
define( "BASE", 	"0" );
//CREAR NUEVA CONEXION=========================================================
creaRegistro($bd, DESC, HOST_G, USER_G, PASS_G, NAME_G, PORT_G, LLAVE_ENC, BASE );
/*
//LEER LAS CONBEXIONES=========================================================
$base = datosConexion($bd, LLAVE_ENC);
$conex = new stdClass();
while ($row = $base->fetch_object()){
    //VARIABLES----------------------------------------------------------------
    $var_codigo = $row->CODIGO;
    //LLENO EL JSON------------------------------------------------------------
    $conex->$var_codigo = array(
        'code' => $row->CODIGO,
        'desc' => $row->DESCRIPCION,
        'host' => $row->HOST,
        'user' => $row->USER,
        'pw' => $row->PASS,
        'bbdd' => $row->BBDD,
        'port' => $row->PORT,
        'base' => $row->BASE
    );
}
foreach($conex as $obj_conex){

    $bd = new connexion_ext($obj_conex['host'], $obj_conex['user'], $obj_conex['pw'], $obj_conex['bbdd'], $obj_conex['port']);
    $bd->query("SET NAMES 'utf8'");
    
    print_r($obj_conex['host']);

    unset($bd);
}
*/
//=============================================================================
//FUNCIONES--------------------------------------------------------------------
//=============================================================================
function creaRegistro($bd, $desc, $host, $user, $pass, $name, $port, $llave, $base )
{
    $query = "  INSERT INTO APPS_GESTORIA_CONEXIONES ( DESCRIPCION, HOST, USER, PASS, BBDD, PORT, BASE )
                VALUES ( '$desc', '$host', '$user', aes_encrypt('$pass', '$llave'), '$name', '$port', $base )";
    mysqli_query($bd, $query);
}
function datosConexion($bd, $llave)
{
    $sql =  "SELECT CODIGO, DESCRIPCION, HOST, USER, cast(aes_decrypt(PASS, '$llave') as char) AS PASS, BBDD, PORT, BASE FROM APPS_GESTORIA_CONEXIONES";
    $result = $bd->query($sql);
    return $result;
}
class connexion_ext extends mysqli {
    public function __construct($host,$user,$pass,$name,$port) {
        //parent::__construct(HOST, USER, PASS, NAME, PORT);
        parent::__construct($host,$user,$pass,$name,$port);
        if (mysqli_connect_error()) {
            die('Error de Connexión (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
        }
    }
}
?>