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

7 votes144 views1 answer
Laravel wher in
PHP Laravel
0 vote75 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP
0 vote105 views1 answer
Mysqli_test
PHP
1 vote132 views1 answer
Laravel api form request validation 404
PHP Laravel
8 votes102 views6 answers
Relationship in laravel
PHP
0 vote119 views1 answer
Numeros positivos input laravel
PHP
6 votes122 views3 answers
Laravel collection put
PHP
6 votes129 views4 answers
Laravel blade foreach index value
PHP
5 votes95 views6 answers
Array sort php
PHP
0 vote129 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel