/PHP/CodeIgniter/Codeigniter order by random

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 vote196 views6 answers
Update codeigniter
PHP CodeIgniter
0 vote207 views1 answer
Codeigniter abort 404
PHP CodeIgniter
0 vote172 views1 answer
Imagelib thourgh class in codeigniter
PHP CodeIgniter
0 vote228 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
0 vote214 views1 answer
Codeigniter update or create
PHP CodeIgniter
1 vote186 views3 answers
Codeigniter 4 builder last query
PHP CodeIgniter
0 vote220 views1 answer
Codeigniter crud generator
PHP CodeIgniter
0 vote226 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter
8 votes253 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote221 views1 answer
Codeigniter form open
PHP CodeIgniter