/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 vote155 views1 answer
Applying multiple order by in codeigniter
PHP CodeIgniter
4 votes220 views2 answers
Codeigniter 3 limit
PHP CodeIgniter
0 vote155 views1 answer
Codeigniter echo set content type
PHP CodeIgniter
0 vote156 views1 answer
Execute sql query codeigniter
PHP CodeIgniter
8 votes213 views4 answers
Codeigniter 4 redirect to home
PHP CodeIgniter
0 vote149 views1 answer
Codeigniter how to know update failed
PHP CodeIgniter
2 votes158 views1 answer
How to use multiple where condition in codeigniter
PHP CodeIgniter
3 votes269 views2 answers
Codeigniter validation text length
PHP CodeIgniter
4 votes225 views5 answers
Codeigniter base_url
PHP CodeIgniter
0 vote163 views1 answer
Return only one column data from table in codeigniter
PHP CodeIgniter