/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

2 votes164 views1 answer
Laravel wherin softdelete
PHP
5 votes151 views3 answers
Assign $variable of key value pair array to multiple variables php
PHP
0 vote164 views2 answers
Get wordpress page link by id
PHP Wordpress
12 votes155 views3 answers
Update composer php version
PHP
85 votes149 views4 answers
If value conatins in word check in php
PHP
3 votes171 views1 answer
Laravel eloquent increment
PHP Laravel
2 votes186 views1 answer
If condition inside echo in php
PHP
11 votes165 views6 answers
Convert object to array in php
PHP
0 vote152 views1 answer
Setup cron on macos for laravel
PHP
0 vote267 views1 answer
Laravel eloquent update quantity
PHP Laravel