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 vote252 views1 answer
Php partisan run backup run
PHP
55 votes239 views18 answers
Php generate random number string
PHP
0 vote301 views1 answer
Time zone set in codeigniter
PHP CodeIgniter
1 vote256 views1 answer
Composer require laravel/ui not working laravel 8
PHP Laravel
-1 vote316 views1 answer
Codeigniter 4 query builder select
PHP CodeIgniter
0 vote312 views1 answer
Db seed in controller
PHP
0 vote245 views1 answer
String match percentage php
PHP
5 votes257 views2 answers
How to remove first element in array php
PHP
1 vote294 views1 answer
I cannot login to my CPanel hosted Laravel Application, my SSL has expired
PHP
0 vote276 views1 answer
Convert text file to json php
PHP