How to get random row in object variable in Laravel?

Question

Sorry for my bad english, I want to get a single row in my object. And I want that in random order. Im using array_rand() and it only return errors as stated below:

ErrorException: array_rand() expects parameter 1 to be array, object given in file C:\xampp\htdocs\user\TestProject\app\Http\Controllers\TestController.php on line

Here is my object.

"my_list": [
   {
     "id": 1,
     "name": "My Name Test",
     "address": [
         {
            "id": 1,
            "city": "Manila",
            "country": "Philippines" 
         }
     ]
   },
   {
     "id": 2,
     "name": "Your Name Test",
     "address": [
         {
            "id": 2,
            "city": "Cebu",
            "country": "Philippines",
         }
     ]
   }
]

The problem is I want only to get a single row to the my_list which is object and not an array.

Here is my code.

$course = Course::where('id', 1)->with('my_list')->first();
$random_list = array_rand($course->my_list);
return $random_list;

I also try adding number of row in the array_rand like this.

$random_list = array_rand($course->my_list, 1);

But still not working.

What did I missed?

Updated my answer. Could you tell me the reason why it's not working. Any errors being thrown? — Mozammil
– Mozammil, Commented Jan 17, 2019 at 6:25

Mozammil · Accepted Answer · 2019-01-17 06:23:31Z

2

Any Eloquent query returns, by default, a Collection, even for the underlying relationships. Since you are working with one, this should work:

$course->my_list->random();

This will return only one item. If you want more, you could pass an argument to the random() method specifying the count of items you want.

For more information, check the documentation.

edited Jan 17, 2019 at 6:23

answered Jan 17, 2019 at 6:12

Mozammil

8,77017 silver badges30 bronze badges

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

Comments

Pablo · Accepted Answer · 2019-01-17 06:22:20Z

1

This Object is a Laravel collection. Please refer to the collection documentation. https://laravel.com/docs/5.7/collections#method-random

You can try $course->my_list->random()

answered Jan 17, 2019 at 6:22

Pablo

6,0667 gold badges37 silver badges52 bronze badges

1 Comment

MONSTEEEER Over a year ago

This is also the answer of Mr. @Mozammil, tried it and it didn't work.

Skywarth · Accepted Answer · 2019-01-17 06:25:14Z

1

If you still wanna do this with your approach, can you try get_object_vars function to cast object into array.

$array = get_object_vars($object);

so that you can use them as an array in array_rand.

You might get an error, hence that it's an multi-dimensional array. Let me know so i may update.

Update for multidimensional:

Please refer to this.

// The second parameter of json_decode forces parsing into an associative array

$array = json_decode(json_encode($object), true);

edited Jan 17, 2019 at 6:25

answered Jan 17, 2019 at 6:16

Skywarth

8533 gold badges15 silver badges32 bronze badges

Comments

Jinal Somaiya · Accepted Answer · 2019-01-17 06:26:51Z

1

try this:

$course = Course::where('id', 1)
   ->with(['my_list' => function($query) {
       $query->inRandomOrder();
}])->first();
return $course->my_list;

answered Jan 17, 2019 at 6:26

Jinal Somaiya

1,99117 silver badges31 bronze badges

1 Comment

MONSTEEEER Over a year ago

It returns all the row in the my_list, anyway I added ->first(); in the $query->inRandomOrder()->first(), and working now.

Kapitan Teemo · Accepted Answer · 2019-01-17 06:43:47Z

1

Try this method:

$course = Course::where('id', 1)
   ->with(['my_list' => function($query) {
       $query->inRandomOrder()->first();
   }])->first();
return $course->my_list;

this method is more efficient since you will only get 1 row from my_list not like when you use $course->my_list->random() which retrieves all data and from there select a random row.

edited Jan 17, 2019 at 6:43

answered Jan 17, 2019 at 6:21

Kapitan Teemo

2,1641 gold badge14 silver badges26 bronze badges

Comments

Arian Fm · Accepted Answer · 2021-03-18 10:17:41Z

0

$random_list = $course['my_list']->random(number);

ps: number = number of element you want to get ,

edited Mar 18, 2021 at 10:17

answered Mar 18, 2021 at 8:53

Arian Fm

3877 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to get random row in object variable in Laravel?

6 Answers 6

Comments

1 Comment

Comments

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

1 Comment

Comments

Comments

Related