dongye3917 2018-03-01 15:36
浏览 22
已采纳

从包括子模型的DB中获取雄辩的模型

I'm learning PHP and the Laravel framework and i'm getting stuck on loading some data from the database.

I have 2 models, Game and Player

Player model (curently empty):

class Player extends Model
{
}

Game model:

class Game extends Model
{
    public $Players = [];

    public function __construct(array $players = [])
    {
        $this->Players = $players;
    }

    public function SaveGame()
    {
        if($this->save()) {
        Log::info("New game created with id " . $this->id);
        }
        foreach ($this->Players as $key => $player){
            if ($this->Players()->save($player)){
            Log::info("player added to game with id " . $player->id);
            }
        }
    }

    static function GetGame($gameId)
    {
        Return Game::find($gameId);
    }

    public function Players()
    {
        return $this->hasMany(Player::class );
    }
}

And i have a GameController:

class GameController extends Controller
{
   public function create()
    {
        $players = [];
        for ($i = 1; $i <= 3; $i++) {
            $player = new Player();
            array_push($players,$player);
        }

        $game = new Game($players);
        $game->SaveGame();

        return $game;
    }

    public function LoadGame($id)
    {
        $game = Game::GetGame($id);
        return $game;
    }
}

If i call the create() method of my GameController, it creates a game in my Game table and 3 players in the player table with the gameID of the corresponding game so i think the relation works fine.

But if i check the response of the create() method i get only this:

{
"updated_at": "2018-03-01 15:13:37",
"created_at": "2018-03-01 15:13:37",
"id": 3952
}

Also the LoadGame() function returns just the game. Actually i need the game with all its players inside. Something like this:

{
"updated_at": "2018-03-01 15:13:37",
"created_at": "2018-03-01 15:13:37",
"id": 3952,
"players":[
       {"name":"player1"},
       {"name":"player2"},
       {"name":"player3"},
     ],
}

What i'am doing wrong?/How do i get the wished result?

I'm also not sure if the Models are the right place to do the database actions and the controllers are the place to create the objects like i do in the posted code. If my "code structure" is not the best practice, some advice in this is also welcome!

  • 写回答

2条回答 默认 最新

  • dsc80135 2018-03-22 11:24
    关注

    Its so easy!, i found the solution by simply experimenting arround as i could not find a solution on the internet.

    In the Game model I removed the

    • constructor (create own constructor in Laravel seems to be not recommended)
    • SaveGame() (save my game in the controller now)
    • GetGame() (useless, can use Game::find(x) in controller)

    In the GameController i changed my create() function a bit. This is the result:

    public function create()
      {
          $game = new Game();          // creates a new game
          $game->Save();               // saves the new game into the db
    
          for ($i = 1; $i <= 3; $i++) {
              $player = new Player();              // creates a new player
              $game->Players()->Save($player);     // stores the player to the game in the db
          }
    }
    

    I also changed my LoadGame() method in my GameController to

    public function LoadGame($id)
    {
        $game = Game::find($id);        // Instead of doing this in a own method in my model 
        $game->players                  // adds the players to the game object for some reason
        return $game;                   // returns the game (as json) incl. all its players
    }
    

    This results in a json string what contains the game vars including a player array with its players. I dont understand why this is working but it is.

    The weird thing is if i exchange $game->players for $game->Players() or $game->Players (like the has many method in the model) it does not work. Maybe someone can explain me why this is? (as i cant find any clarifying documentation to this)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 运筹优化,gurobi,python
  • ¥20 画CAD几张图片内容如下1111111111111111111111111111111111111111111
  • ¥15 基于python的电影系统推荐
  • ¥20 springmvc重定向和返回json
  • ¥15 数学建模——参会安排怎么做
  • ¥15 电脑键盘实现触摸功能
  • ¥25 matlab无法将表达式转换为双数组怎么解决?
  • ¥15 单片机汇编语言相关程序
  • ¥20 家用射频美容仪技术规格
  • ¥15 大家帮我看看为什么错了