Split Eloquent result set into two equally-sized chunks

Question

I have an array full of DB records. It could heaps of elements or very little, it changes regularly.

I need to split the array into two equal parts. The reason is I am then passing these arrays to a Laravel view and displaying them into separate columns.

Here is the DB records being pulled:

$books = Book::where('unitcode', '=', $unitcode['unitcode'])->get();

If the pull works then I'm running this:

return View::make('showbooks')
->with('books', $books);

What I want to do is pass $books1 and $books2 which is actually $books split into 2 parts.

@scrowler Would you please be able to post an answer on its use? I'm quite new to this and am having trouble finding the length of the array to then chunk it. — KriiV
– KriiV, Commented Aug 28, 2014 at 3:45
$books = array_chunk($books, count($books)/2); - split it in half — scrowler
– scrowler, Commented Aug 28, 2014 at 3:46
@scrowler Thanks! Would getting the other half be as simple as: $books = array_chunk($books, count($books)/2, count($books);? — KriiV
– KriiV, Commented Aug 28, 2014 at 3:48
$books would then contain an array with two keys, each key would contain half of the array. You could also do list($books1, $books2) = array_chunk($books, count($books)/2); to get them into variables — scrowler
– scrowler, Commented Aug 28, 2014 at 3:49
if you use array_chunk and it's a odd number of elements, it will create an array with 3 arrays inside of it, not 2 arrays with +1 element in each array. — Ohgodwhy
– Ohgodwhy, Commented Aug 28, 2014 at 3:50

Andrii Kovalenko · Accepted Answer · 2026-01-06 18:56:36Z

25

This is a one liner:

$halved = array_chunk($books, ceil(count($books)/2));

Then $halved[0] will contain the first half of the array. It will always be 1 element larger in the event that the array contains an odd number of elements. Of course, $halved[1] will contain the 2nd half of the array.

edited Jan 6 at 18:56

Andrii Kovalenko

2,3033 gold badges15 silver badges38 bronze badges

answered Aug 28, 2014 at 3:54

Ohgodwhy

50.9k11 gold badges88 silver badges115 bronze badges

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

Comments

Mad Angle · Accepted Answer · 2014-08-28 04:00:59Z

1

I think this will work for you.

<?php
    $books = array("a", "b", "c", "d", "e","f"); // assuming books is an array like this
    $count = count($books); // total count of the array books
    $half = $count/2; // half of the total count
    $books1 = array_slice($books, 0, $half);      // returns first half
    $books2 = array_slice($books, $half);  // returns second half

    print_r($books1);
    print_r($books2);
?>

edited Aug 28, 2014 at 4:00

answered Aug 28, 2014 at 3:52

Mad Angle

2,3301 gold badge18 silver badges33 bronze badges

1 Comment

Mark Miller Over a year ago

If $books has an odd number of elements, one element will be left off... I would remove the 2nd $half parameter for $books2, that way you get the rest of the array from where $books1 ended...

Abdessabour Mtk · Accepted Answer · 2014-08-28 04:04:47Z

0

I think you should take the length of the array using the count method and then loop the items till the middle it should look like this :

<?php 
    $count = count($books);            //getting the count of $books
    $mid = round($count/2);           //getting the mid point of $books
    for($i = 0; $i < $count ; $i++){ //looping through the indexes
        if($i <= mid - 1){          //Checking the position of $i and adding the value
            $books1[] = $books[$i];
        }else{
            $books2[] = $books[$i];
        }
    }
?>

answered Aug 28, 2014 at 4:04

Abdessabour Mtk

3,9182 gold badges16 silver badges21 bronze badges

Comments

Jerre · Accepted Answer · 2018-04-25 14:14:03Z

0

To expand on Ohgodwhy's answer:

Since you're using laravel, here's a more fluent way to achieve this:

$books = collect($books);

$halved = $books->split(ceil($books->count()/2))->toArray();

// Result: [[a, b, c], [d, e, f]]

Take a look at Laravel's various Collection Methods for more available methods to fluently manipulate arrays.

answered Apr 25, 2018 at 14:14

Jerre

1792 silver badges7 bronze badges

Comments

Hans Zhang · Accepted Answer · 2019-08-02 04:23:07Z

0

Use:

$collection->chunk(2);

See: https://laravel.com/docs/5.6/collections#method-chunk

answered Aug 2, 2019 at 4:23

Hans Zhang

5095 silver badges6 bronze badges

Comments

Milad Parirokh · Accepted Answer · 2022-09-02 08:16:49Z

0

splitIn()

The splitIn method breaks a collection into the given number of groups, filling non-terminal groups completely before allocating the remainder to the final group:

$collection = collect([1, 2, 3, 4, 5, 6, 7, 8, 9, 10]);
 
$groups = $collection->splitIn(3);
 
$groups->all();

// [[1, 2, 3, 4], [5, 6, 7, 8], [9, 10]]

answered Sep 2, 2022 at 8:16

Milad Parirokh

811 silver badge4 bronze badges

Collectives™ on Stack Overflow

Split Eloquent result set into two equally-sized chunks

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

splitIn()

Comments

Your Answer

Linked

Collectives™ on Stack Overflow

Split Eloquent result set into two equally-sized chunks

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

splitIn()

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related