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 votes213 views2 answers
Twig create new array
PHP
0 vote264 views1 answer
Laravel create text file
PHP Laravel
0 vote226 views1 answer
Sql update views +1
PHP
0 vote215 views1 answer
Php 8 union types
PHP
7 votes273 views4 answers
Laravel is route name
PHP Laravel
0 vote225 views2 answers
Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:\newxammp\htdocs\learn\index.php on line 11
PHP
1 vote305 views2 answers
Laravel check if email is verified
PHP
3 votes238 views2 answers
Php remove cookie
PHP
0 vote245 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
0 vote296 views1 answer
Comment ajouter nofollow à un lien spécifique ou à tous les liens WordPress dans the_content
PHP Wordpress