Laravel将SQL检索转换为字符串

Question

我有一个类似的检索语句

$training = $this->training
->Join('training_schedules','trainings.id','=','training_schedules.training_id')
->select('trainings.title','training_schedules.start_date')
->where('training_schedules.id','=',$schedule_id)
->get()->first();

$spd->registerRowFormatter( $formatter );
$spd->saveExcel('training_participants', 'Participants List of '.$training);

哪个返回结果

Participants List of {"title":"Pelatihan","start_date":"2021-02-24 15:44:00"}

有人知道我应该怎么做才能得到Participant list of Pelatihan | (start_date)作为我的结果吗？

Answer 1

为什么不直接获取属性？

$spd->saveExcel(
'training_participants',
'Participants List of '.$training->title.' | ('.$training->start_date.')'
);

或使用":

$spd->saveExcel(
'training_participants',
"Participants List of {$training->title} | ({$training->start_date})"
);