/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 vote375 views1 answer
Form validation for file type in codeigniter
PHP CodeIgniter
0 vote386 views1 answer
Insert array values in database using codeigniter
PHP CodeIgniter
0 vote390 views1 answer
Encryp with codeigniter 3
PHP CodeIgniter
0 vote397 views5 answers
Codeigniter.com cart
PHP CodeIgniter
4 votes429 views5 answers
Codeigniter 4 base_url
PHP CodeIgniter
0 vote386 views1 answer
CODEIGNITER codeigniter 4 auth
PHP CodeIgniter
0 vote384 views1 answer
Codeigniter 4 radio button isset
PHP CodeIgniter
0 vote400 views1 answer
Converting php to codeigniter
PHP CodeIgniter
2 votes367 views1 answer
Order by in codeigniter
PHP CodeIgniter
8 votes463 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter