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 vote237 views1 answer
Phpunit/phpunit[dev-master, 9.3.3, ..., 9.4.x-dev] require ext-dom * -> it is missing from your system. Install or enable PHP's dom extension.
PHP
-3 votes269 views8 answers
@foreac laravel
PHP Laravel
-2 votes212 views1 answer
Time dropdown in html
PHP
2 votes291 views1 answer
Laravel test dbms connection
PHP Laravel
0 vote248 views1 answer
33
PHP
4 votes256 views7 answers
Convert a String to a Number in PHP
PHP
0 vote230 views1 answer
Php break out of parent loop
PHP
2 votes236 views2 answers
How to get attachments to emails php
PHP
2 votes201 views1 answer
Call a function in php
PHP
0 vote228 views5 answers
Get recoed between two datetime laravel
PHP Laravel