PHP Query::getOne Examples

Example #1

File: GameController.php Project: jocodev1/colliermvc

 function display($id)
 {
     $game = new Game();
     $game->setId($id);
     $game = Query::getOne($game);
     return $game;
 }

Example #2

File: ArenaController.php Project: jocodev1/colliermvc

 function display($id)
 {
     $arena = new Arena();
     $arena->setId($id);
     $arena = Query::getOne($arena);
     return $arena;
 }

Example #3

File: UserController.php Project: jocodev1/colliermvc

 function display($id)
 {
     $user = new User();
     $user->setId($id);
     $user = Query::getOne($user);
     return $user;
 }

Example #4

File: query.php Project: jocodev1/colliermvc

 function add($obj)
 {
     global $db;
     $table = strtolower(get_class($obj));
     $keys = "";
     $values = "";
     foreach ($obj as $key => $value) {
         if (count($value) == 0) {
             continue;
         }
         $keys .= $key . ', ';
         $values .= "'" . $value . "'" . ', ';
     }
     $keys = rtrim($keys, ', ');
     $values = rtrim($values, ', ');
     $result = $db->exec('INSERT INTO ' . $table . ' (' . $keys . ') VALUES (' . $values . ')');
     $obj->setId($db->lastInsertId());
     $obj = Query::getOne($obj);
     return $obj;
 }