我的Game模型中有一个方法,它检索一个数据库上表中注册的所有游戏的列表,遍历找到的每个游戏并从另一个数据库中获取数据,最后从数据库中获取一个随机图像URL并将其附加到统计对象中。困惑了吗?
不要再困惑了,下面是方法:
public static function getStats($player, $cache = 30) {
// Return a collection of all games registered from the website database
$games = Game::get(['game']);
foreach($games as $game) {
// For each iteration, return the statistics from the games database for that game
// Grab game meta information from the website database, $game->game is the game name.
$list = Game::where('game', $game->game)->remember($cache)->first();
// From the game database, retrieve the statistics
$stats[$game->game] = DB::connection('game')->table($list->stats_table)
->select(DB::raw($list->statistics))
->where('Username', $player)
->remember($cache)
->first();
// Grab a random map image from the game database
$stats[$game->game]['map'] = DB::connection('game')->table('Maps')
->select('Image')
->orderBy(DB::raw('RAND()'))
->remember($cache)
->first();
}
// Finally, return the statistics from the game paired with a random map image from the game
return $stats;
}
我想将映射查询附加到$stats上,这样它就可以放在一个地方,目前该方法失败的原因是:无法将stdClass类型的对象用作数组
如果没有地图,当在$stats上循环时,它是一个以键为游戏名称的游戏统计数组。
如果你仍然感到困惑(我不会责怪你),请留下评论,我会解释更多。
编辑:
以下是我使用->merge()
:的尝试
public static function getStats($player, $cache = 30) {
// Return a collection of all games registered from the website database
$games = Game::get(['game']);
foreach($games as $game) {
// For each iteration, return the statistics from the games database for that game
// Grab game meta information from the website database
$list = Game::where('game', $game->game)->remember($cache)->first();
// From the game database, retrieve the statistics
$stats[$game->game] = DB::connection('game')->table($list->stats_table)
->select(DB::raw($list->statistics))
->where('Username', $player)
->remember($cache)
->first();
// Grab a random map image from the game database
$map = DB::connection('game')->table('Maps')
->select('Image')
->orderBy(DB::raw('RAND()'))
->remember($cache)
->first();
$stats[$game->game] = $stats[$game->game]->merge($map);
}
// Finally, return the statistics from the game paired with a random map image from the game
return $stats;
}
这导致调用未定义的方法stdClass::merge()运行Laravel 4.2。
merge()
merge方法将给定的数组合并到原始集合中。如果给定数组中的字符串键与原始集合中的字符串关键字匹配,则给定数组的值将覆盖原始集合中的值
该方法的唯一参数是应该合并的集合。下面是一个例子。
<?php
// app/routes.php
Route::get('/', function()
{
$a = Album::where('artist','Something Corporate')
->get();
$b = Album::where('artist','Matt Nathanson')
->get();
$result = $a->merge($b);
$result->each(function($album)
{
echo $album->title.'<br />';
});
});
其他
$array = array_merge($stats[$game->game]->toArray(), $map->toArray());
return Response::json($array);