如何从Laravel 5.2中的数据库中获取最新数据
I have a database with these column :
id|company_id|company_name|create_at|updated_at|deleted_at
For example in mydatabase now, I already have 5 data. Then I just want to take 3 newest data from my database. What command should I use? Right now I'm just using
$comIn = new CompanyInfo;
$modalData = $comIn->where('company_id',$cid)->get();
$modalData
contains all of the five data available, actually I can create another variable to put the last 3 data from $modalData
. But I just want to do it by mysql command, Could I really do that ? What should I put in where
('company_id,$cid, bla bla bla bla bla...??)->get();
我有一个包含以下列的数据库: p>
id | company_id | company_name | create_at | updated_at | deleted_at
code> pre>
例如,在mydatabase中,我已经拥有5个数据。 然后我只想从我的数据库中获取3个最新数据。 我应该使用什么命令? 现在我只是使用 p>
$ comIn = new CompanyInfo;
$ modalData = $ comIn-> where('company_id',$ cid) - > get ();
code> pre>
$ modalData code>包含所有可用的五个数据,实际上我可以创建另一个变量来放置最后3个数据 $ modalData 代码>。 但我只是想通过mysql命令来做,我能真的这样做吗? 我应该放在哪里 p>
('company_id,$ cid,bla bla bla bla bla ?? ??) - > get(); code>
div>
Do like this it will do the work
$comIn = new CompanyInfo;
$modalData = $comIn->where('company_id',$cid)->orderBy('id','desc')->take(3)->get();