Laravel 4.2 - can't get random rows from database

GRowing

Can someone explain to me why this works

$profile = Profile::all()->random(8);

and this doesn't work

$profile = Profile::where('gender_id', '=', 1)->random(8);

I get the error saying

Call to undefined method Illuminate\Database\Query\Builder::random()

Marcin Nabiałek

You should use:

$profile = Profile::where('gender_id', '=', 1)->get()->random(8);

Because random() function gets random items from collection. Reference

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

How can I select 2 different random rows from a table?

From Dev

Can't pass variable from routes to view in laravel 4

From Dev

Can't retrieve value from object in laravel 4

From Dev

How can I select a random entry from a database using Laravel 4's Eloquent ORM?

From Dev

Can't get values from json stored in database

From Dev

QSqlQueryModel can't get Time from database

From Dev

Can't get parmalink from Wordpress database

From Dev

Can't get elements from database twice

From Dev

get random rows from RDD

From Dev

How to echo random rows from database?

From Dev

Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database

From Dev

Can't get JSON input for Laravel4 POST

From Dev

Can I use a database from Laravel 3 with Laravel 4?

From Dev

Get random data from database,

From Dev

Can't pass variable from routes to view in laravel 4

From Dev

Laravel 4 pagination - Can't get past page 1

From Dev

How can I select a random entry from a database using Laravel 4's Eloquent ORM?

From Dev

Can't get values from json stored in database

From Dev

Laravel 4 database.php can't access DB

From Dev

Laravel 4 can't get data from Angular Ajax

From Dev

QSqlQueryModel can't get Time from database

From Dev

Reading from database in Laravel 4

From Dev

dynamic random rows from table database

From Dev

Can't delete rows from database

From Dev

Can't fetch rows from MySQL database

From Dev

how to join bigger table T1 to a smaller T2 with random repeating rows from T2

From Dev

sqlalchemy: can't get any data from database

From Dev

Can't manage to export multiple rows from database to XML

From Dev

Can't get last_insert_id from database with Eloquent

Related Related

  1. 1

    How can I select 2 different random rows from a table?

  2. 2

    Can't pass variable from routes to view in laravel 4

  3. 3

    Can't retrieve value from object in laravel 4

  4. 4

    How can I select a random entry from a database using Laravel 4's Eloquent ORM?

  5. 5

    Can't get values from json stored in database

  6. 6

    QSqlQueryModel can't get Time from database

  7. 7

    Can't get parmalink from Wordpress database

  8. 8

    Can't get elements from database twice

  9. 9

    get random rows from RDD

  10. 10

    How to echo random rows from database?

  11. 11

    Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database

  12. 12

    Can't get JSON input for Laravel4 POST

  13. 13

    Can I use a database from Laravel 3 with Laravel 4?

  14. 14

    Get random data from database,

  15. 15

    Can't pass variable from routes to view in laravel 4

  16. 16

    Laravel 4 pagination - Can't get past page 1

  17. 17

    How can I select a random entry from a database using Laravel 4's Eloquent ORM?

  18. 18

    Can't get values from json stored in database

  19. 19

    Laravel 4 database.php can't access DB

  20. 20

    Laravel 4 can't get data from Angular Ajax

  21. 21

    QSqlQueryModel can't get Time from database

  22. 22

    Reading from database in Laravel 4

  23. 23

    dynamic random rows from table database

  24. 24

    Can't delete rows from database

  25. 25

    Can't fetch rows from MySQL database

  26. 26

    how to join bigger table T1 to a smaller T2 with random repeating rows from T2

  27. 27

    sqlalchemy: can't get any data from database

  28. 28

    Can't manage to export multiple rows from database to XML

  29. 29

    Can't get last_insert_id from database with Eloquent

HotTag

Archive