php版本:7.4.8
laravel:5.8
问题1:mysql中查询返回对象,非数组,toArray()无效
解决方法:
//修改这个文件的boot方法
//注意修改引入文件,phpstorm点击即可引入
app/Providers/EventServiceProvider.php
public function boot()
{
parent::boot();
//
Event::listen(StatementPrepared::class, function ($event) {
$event->statement->setFetchMode(\PDO::FETCH_ASSOC);
});
}
//这么取就可以了
$data = DB::table('blogUser')->where('phone', $phone)->select("username", "phone", "mail", "created_time", "updated_time")->get()->toArray();