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 vote163 views1 answer
Laravel import xml to database
PHP
0 vote223 views1 answer
Pure Intersection Types - PHP 8.1
PHP
-1 vote218 views1 answer
Authenticate user with phone laravel
PHP Laravel
1 vote221 views3 answers
Laravel function to check if image exist or not
PHP Laravel
2 votes251 views6 answers
Laravel 8 ui auth
PHP Laravel
7 votes171 views2 answers
Laravel how to check if there are record exists
PHP
0 vote192 views3 answers
Php decrement variable by 1
PHP
0 vote187 views1 answer
Retrievemultipleimage from database in laravel
PHP
1 vote207 views1 answer
Laravel validation in controller
PHP Laravel
3 votes197 views1 answer
Phone number validation, laravel
PHP