/PHP/Laravel 8 selecet the 2nd to the last record

Laravel 8 selecet the 2nd to the last record

        $news1 = DB::table('posts')->where('xstatus',1)->where('status','published')->orderBy('seq','DESC')->skip(0)->first();
        $news2 = DB::table('posts')->where('xstatus',1)->where('status','published')->orderBy('seq','DESC')->skip(1)->first();
        $news3 = DB::table('posts')->where('xstatus',1)->where('status','published')->orderBy('seq','DESC')->skip(2)->first();

Laravel get second last record

$row = News::count();
        $newsid = $row -2;
        $news1 = News::all()->last();
        $news2 = News::orderBy('created_at', 'desc')->skip($newsid)->take($newsid)->first();
        return view('user/start', compact('news1', 'news2', 'newsid'));

Source: stackoverflow.com

Similar codes

0 vote274 views2 answers
Launch uikit modal from php
PHP
0 vote258 views1 answer
Wordpress remove current post in sidebar php
PHP
20 votes283 views6 answers
Array random php
PHP
0 vote336 views1 answer
Laravel weekly data
PHP Laravel
23 votes301 views5 answers
Php capitalize each word
PHP
19 votes344 views3 answers
Header refresh page php
PHP
34 votes254 views8 answers
Laravel log
PHP
0 vote265 views1 answer
Laravel print executed query
PHP
0 vote265 views1 answer
Laravel api get controller
PHP Laravel
10 votes368 views4 answers
Wordpress log errors
PHP Wordpress