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

2 votes276 views5 answers
Laravel drop table migration
PHP Laravel
3 votes1.1K views2 answers
Validate phone number with dial code laravel 8
PHP
0 vote400 views2 answers
Undefined index token in get_request_headers
PHP
2 votes288 views1 answer
Laravel scheduler every 2 hours
PHP Laravel
3 votes278 views4 answers
Delete multiple row by model in laravel
PHP
0 vote283 views2 answers
Laravel bootstrap navbar active
PHP
1 vote255 views1 answer
Php check if function exists
PHP
0 vote403 views1 answer
Limiter la révision des articles WordPress
PHP Wordpress
4 votes257 views3 answers
Php define()
PHP
3 votes258 views1 answer
Memory limit php ini_set
PHP