Ejemplos de diplo_game::openFromResultSet en PHP

Ejemplo n.º 1

Archivo: class_diplo_game.php Proyecto: netlor/private_diplo

 public static function getLstSigned($id_user)
 {
     $lst = array();
     global $db;
     $sel = "SELECT      DISTINCT g.*\n                FROM        " . self::TABLE_NAME . " g\n                INNER JOIN  " . diplo_player_game::TABLE_NAME . " lk\n                ON          g.id = lk.id_game\n                WHERE       lk.id_player = {$id_user}\n                ORDER BY    g.name";
     $res = $db->query($sel);
     $lst = array();
     while ($r = $res->fetchArray()) {
         $game = new diplo_game();
         $game->openFromResultSet($r);
         $lst[] = $game;
     }
     return $lst;
 }