Example #1
0
 function obtenerReinosEstudiante()
 {
     //error_reporting(0);
     $configbd = new configbd_model();
     $dbconn4 = $configbd->abrirSesion('estudiante');
     $consult2 = "SELECT * FROM VIEW_REINOS_ESTUDIANTE WHERE K_NICKNAME='" . $_SESSION['codigo'] . "'";
     $resultConsult2 = pg_query($consult2) or die('La consulta fallo: ' . pg_last_error());
     $reinosAvatar = array();
     $i = 0;
     while ($line = pg_fetch_array($resultConsult2, null, PGSQL_ASSOC)) {
         $reino = new Reino_model();
         $reinosAvatar[$i] = $reino->crearReino($line['k_reino'], $line['n_nombre'], "", "", $line['f_creacion'], "", $line['o_imagen'], "", "", $line['n_nombre_profesor']);
         $i++;
     }
     $configbd->cerrarSesion();
     return $reinosAvatar;
 }