PHP利用Laravel ORM从Mysql读取存储json的字段,有的返回数组,有的返回字符串。
public function index(){
$this->checkPermission('applications/game/index');
$games = Game::select('id','name','logo','languages','version','pay_configs','advertisement','link','disabled')->get();
var_dump($games[0]['advertisement']);
//string(78) "{"zh":"\u751f\u6b7b\2","en":"Battle 2","tr":"Battle 2"}"
var_dump($games[0]['name']);die();
//array(3) { ["zh"]=> string(13) "生死" ["en"]=> string(14) "Battle 2" ["tr"]=> string(14) "Battle 2" }
return $this->success(['games' => $games]);
}
表结构如下:
CREATE TABLE `games` (