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

3 votes284 views1 answer
Get soft deleted data laravel
PHP
0 vote218 views2 answers
Wp max revisions
PHP Wordpress
1 vote220 views3 answers
Print query statement in laravel
PHP Laravel
0 vote243 views3 answers
Laravel disable Logging
PHP Laravel
1 vote217 views1 answer
Hex to dec php
PHP
0 vote208 views1 answer
Php heredoc variable substitution
PHP
0 vote269 views1 answer
Laravel bootstrap-auth setup
PHP Laravel
3 votes290 views1 answer
Get soft deleted data laravel
PHP Laravel
12 votes276 views6 answers
Laravel relationship
PHP
3 votes188 views4 answers
Class 'App\Http\Controllers\Response' not found
PHP