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 vote262 views1 answer
Messagebird php curl send sms example
PHP
23 votes278 views2 answers
String first letter uppercase php
PHP
0 vote262 views1 answer
Header cross origin using php only for our domains and subdomain
PHP
1 vote230 views1 answer
Woocommerce add custom field data to cart page
PHP
5 votes284 views3 answers
Laravel model limit
PHP Laravel
0 vote291 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel
1 vote295 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
0 vote291 views1 answer
Comment ajouter nofollow à un lien spécifique ou à tous les liens WordPress dans the_content
PHP
3 votes228 views1 answer
Php explode end
PHP
2 votes266 views2 answers
Carbon subdays
PHP