Codeigniter query result

Codeigniter raw query

    $sql="Select * from my_table where 1";    
    $query = $this->db->query($SQL);
    return $query->result_array();

Source: stackoverflow.com

Codeigniter query result

$query = $this->db->query("SELECT * FROM users;");

foreach ($query->result('User') as $user)
{
        echo $user->name; // access attributes
        echo $user->reverse_name(); // or methods defined on the 'User' class
}

Source: codeigniter.com

Similar codes

0 vote287 views1 answer
Livewire pagination bootstrap
PHP
0 vote281 views6 answers
Create global function laravel
PHP
3 votes281 views2 answers
Valdidate laravel if falid
PHP
4 votes378 views4 answers
Wordpress get theme uri
PHP Wordpress
0 vote316 views1 answer
Search WordPress with custom field
PHP Wordpress
1 vote269 views1 answer
Get child theme path in wordpress
PHP
1 vote308 views2 answers
How to remove token while logout using laravel 8
PHP Laravel
0 vote271 views1 answer
Fibers - PHP 8.1
PHP
8 votes291 views6 answers
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
PHP
7 votes280 views6 answers
Create project laravel
PHP