Laravel 5 how to get many random rows using collections

Question

Based on how get random row laravel-5 I adjusted my query, but still not receiving the expected result.

I have 20 articles in the database and want to get randomly only 3 of them and show them on the page.

My class is just like the following:

public function article()
{
    $article = DashArticle::where('category', '=', 0)->get()->random(3);

    $articleTitle0       = $article[0]->titel;
    $articleAutor0       = $article[0]->autor;
    $articleAbstract0    = $article[0]->abstract;
    $articleSource0      = $article[0]->source;
    $articleTitle1       = $article[1]->titel;
    $articleAutor1       = $article[1]->autor;
    $articleAbstract1    = $article[1]->abstract;
    $articleSource1      = $article[1]->source;
    $articleTitle2       = $article[2]->titel;
    $articleAutor2       = $article[2]->autor;
    $articleAbstract2    = $article[2]->abstract;
    $articleSource2      = $article[2]->source;

    return compact(
        'articleTitle0', 'articleAutor0', 'articleAbstract0', 'articleSource0',
        'articleTitle1', 'articleAutor1', 'articleAbstract1', 'articleSource1',
        'articleTitle2', 'articleAutor2', 'articleAbstract2', 'articleSource2'
    );
}

And here part of the view:

<div id="a-slide" class="carousel slide auto panel-body">
    <ol class="carousel-indicators out">
        <li class="active" data-slide-to="0" data-target="#a-slide"></li>
        <li class="" data-slide-to="1" data-target="#a-slide"></li>
        <li class="" data-slide-to="2" data-target="#a-slide"></li>
    </ol>
    <div class="carousel-inner">
        <div class="item active" style="padding: 0 16px;">
            <p style="font-size: 16px; font-weight: bold;">{!! $articleTitle0 !!}</p>
            <p class="text-muted">{!! $articleAutor0 !!}</p>
            <p><strong>Abstract:</strong><br />{!! $articleAbstract0 !!}</p>
            <p>
                <a href="$articleSource !!}" target="_blank">
                    {!! $articleSource0 !!}
                </a>
            </p>
        </div>

        <div class="item" style="padding: 0 16px;">
            <p style="font-size: 16px; font-weight: bold;">{!! $articleTitle1 !!}</p>
            <p class="text-muted">{!! $articleAutor1 !!}</p>
            <p><strong>Abstract:</strong><br />{!! $articleAbstract1 !!}</p>
            <p>
                <a href="{!! $articleSource1 !!}" target="_blank">
                    {!! $articleSource1 !!}
                </a>
            </p>
        </div>

The problem is when I let the random = 3 ($article = DashArticle::where('category', '=', 0)->get()->random(3); I get following error: "Undefined offset: 1"

and when I user random = 20 (the total number of rows in the table) it works but I don't become any random articles but always the first 3 lines of the table.

I would appreciate any help! Thanks!

Przemysław Jan Wróbel · Accepted Answer · 2015-10-01 09:42:27Z

12

The problem is that random method preserves keys from original collection. To avoid this you should get a pure values:

$article = DashArticle::where('category', '=', 0)->get()->random(3)->values();

answered Oct 1, 2015 at 9:42

Przemysław Jan Wróbel

3042 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kiran Subedi · Accepted Answer · 2015-10-01 10:13:22Z

1

You can get random rows by like this :

public function article()
{
    $article = DashArticle::orderBy(DB::raw('RAND()'))->take(3)->get();

    //pass data to view 
    if(view()->exists('article.list')){
        return view('article.list',compact('article'));
    }
}

answered Oct 1, 2015 at 10:13

Kiran Subedi

2,2844 gold badges20 silver badges35 bronze badges

Comments

ehsan houshmand · Accepted Answer · 2019-02-27 08:03:20Z

0

Try this

$article = DashArticle::where('category', '=', 0)->get()->shuffle()->all();

answered Feb 27, 2019 at 8:03

ehsan houshmand

4134 silver badges7 bronze badges

Collectives™ on Stack Overflow

Laravel 5 how to get many random rows using collections

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related