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

2 votes155 views2 answers
Wp is user admin
PHP Wordpress
0 vote140 views1 answer
Yii2 modules commands are not showing in console
PHP
3 votes239 views6 answers
Email verification laravel
PHP Laravel
0 vote144 views1 answer
How to select max write textarea value in php
PHP
2 votes133 views3 answers
Get term id
PHP
0 vote239 views1 answer
Drupal 9 how to pass arguments to custom blocks
PHP Drupal
0 vote136 views1 answer
Php check session status
PHP
1 vote118 views1 answer
Acf taxonomy
PHP
0 vote153 views1 answer
Laravel eloquent set timestamps values upon seed
PHP Laravel
0 vote147 views1 answer
How to log out php
PHP