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

6 votes344 views2 answers
Login selected user laravel
PHP Laravel
0 vote322 views1 answer
Eloquent unique combination
PHP
6 votes323 views1 answer
Laravel check collection not empty
PHP Laravel
2 votes409 views1 answer
Get current user first and last name wordpress
PHP Wordpress
0 vote324 views1 answer
How to serve the port in php
PHP
8 votes342 views4 answers
Join multiple tables in laravel eloquent
PHP Laravel
0 vote325 views1 answer
Get option field acf
PHP
1 vote353 views3 answers
Laravel title dynamic
PHP Laravel
0 vote345 views1 answer
How to calculate age using query builder in laravel?
PHP
0 vote433 views1 answer
Drupal 9 check if UUD is valid
PHP Drupal