/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 vote291 views1 answer
Database interaction in codeigniter
PHP CodeIgniter
0 vote247 views2 answers
Codeigniter4 route optional parameter
PHP CodeIgniter
0 vote257 views1 answer
Return only one column data from table in codeigniter
PHP CodeIgniter
0 vote248 views1 answer
Execute sql query codeigniter
PHP CodeIgniter
0 vote247 views1 answer
Codeigniter get parameter from url
PHP CodeIgniter
0 vote238 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP CodeIgniter
1 vote247 views1 answer
Create controller codeigniter 3
PHP CodeIgniter
0 vote236 views1 answer
Php artisan spark not working in codeigniter
PHP CodeIgniter
0 vote254 views1 answer
Where condition in array in codeigniter
PHP CodeIgniter
2 votes274 views3 answers
Codeigniter last insert id
PHP CodeIgniter