public function Listar() { $connection = new ConexionModel(); $query = "select * from sitio;"; $resultado = $connection->ejecutarSelect($query); return $resultado; }
public function Validar($usuario, $pass) { $connection = new ConexionModel(); $query = "SELECT * from login where User='******' and AES_DECRYPT(Pass,'1111')='{$pass}'"; $resultado = $connection->ejecutarSelect($query); return $resultado; }
public function Listar() { $connection = new ConexionModel(); $query = "select cuenta.id,sitio_idsitio as idsitio,aes_decrypt(cuenta.pass,'1111') as pass,sitio.enlace as sitio,email,usuario,ultimaMod,login.User \n from (cuenta inner join sitio on sitio.idsitio=cuenta.sitio_idsitio) inner join \n login on login.Id=cuenta.login_Id;"; $resultado = $connection->ejecutarSelect($query); return $resultado; }