Fetch specific data form array laravel

Question

I can echo all data form this array but how can I get fetch the first data and second data separately? I echo this get all user_id, I want to separately save user_id in somewhere.

    <?php
        use App\AssignSubmission;

        $user = auth()->user();
        $AssignSubmissions = AssignSubmission::with('submissions')->where('user_id', $user->id)->get();
    foreach ($AssignSubmissions as $AssignSubmission)
    {
        echo $AssignSubmission->submissions->user_id;
    }
    ?>

I can echo all data from this array but now I only want to echo the specific data I want — Donald Donald
– Donald Donald, Commented Oct 28, 2018 at 4:16
Try like this echo $AssignSubmission->submissions[0]->user_id;. echo $AssignSubmission->submissions->[1]user_id; — Amol Rokade
– Amol Rokade, Commented Oct 28, 2018 at 4:54
Use the ->limit(2)->get() to limit your query. Then echo all items in your foreach — Philip
– Philip, Commented Oct 28, 2018 at 4:54
@AmolRokade ->submissions looks like it's a relation, not a array or am I missing some advanced Laravel syntax? :) — Philip
– Philip, Commented Oct 28, 2018 at 4:56

Philip · Accepted Answer · 2018-10-28 17:20:36Z

1

->submissions is a relation, so you can easily limit the number of items you're getting with the query builder using ->limit(2) before the ->get(). Then only the first 2 get loaded.

If you need all others as well, then you might instead want to use a counter inside your foreach that will trigger a break; call inside a if statement inside the foreach loop:

var $cnt = 0;
foreach(....) {
    $cnt++;
    if ($cnt > 2) break;
    ...
}

For more information, have a look at Laravel's documentation on:

edited Oct 28, 2018 at 17:20

answered Oct 28, 2018 at 5:03

Philip

2,9982 gold badges27 silver badges38 bronze badges

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

2 Comments

Donald Donald Over a year ago

yes it is relation what if I just want the 2nd data

Philip Over a year ago

Use ->offset(1)->limit(1)->get(). This is all in Laravel’s excellent documentation on Database, have a look there for more details and info.

Collectives™ on Stack Overflow

Fetch specific data form array laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related