Codeigniter order by random

function get_random_page()
{
    $this->db->order_by('id', 'RANDOM');
    or
    $this->db->order_by('rand()');
    $this->db->limit(1);
    $query = $this->db->get('pages');
    return $query->result_array();

}

Source: stackoverflow.com

Similar codes

0 vote200 views1 answer
Updateorinsert laravel for large data
PHP Laravel
0 vote245 views1 answer
Export txt php
PHP
0 vote209 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000]: General error: 3780 Referencing column
PHP
0 vote196 views1 answer
Php find all subclasses of class
PHP
0 vote232 views1 answer
Die laravel
PHP Laravel
0 vote244 views1 answer
You are *required* to use the date.timezone setting or t
PHP
4 votes216 views5 answers
Get specific key value from array php
PHP
0 vote267 views1 answer
Laravel str_pad Consecutivo
PHP Laravel
2 votes214 views6 answers
Laravel sanctum authentication
PHP
0 vote240 views1 answer
Verify laravel string must be null
PHP Laravel