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 vote258 views1 answer
Print all session variables php
PHP
39 votes183 views4 answers
Php artisan make:controller --resource command
PHP
0 vote218 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
0 vote235 views1 answer
Pagination javascript php
PHP
1 vote201 views1 answer
How to catch query exception in laravel 8
PHP
18 votes214 views6 answers
Laravel log error
PHP Laravel
10 votes230 views4 answers
Laravel create
PHP Laravel
0 vote200 views1 answer
Uncaught jquery-numerator requires jQuery to be loaded first wordpress
PHP
0 vote201 views1 answer
Strtotime laravel
PHP Laravel
18 votes190 views2 answers
Json stringify php decode
PHP