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 votes262 views1 answer
Create multidimensional array php for loop
PHP
0 vote243 views1 answer
WithCount laravel assign generic name
PHP
1 vote261 views1 answer
Laravel create on model
PHP Laravel
0 vote257 views1 answer
Inner join in php opp
PHP
-1 vote252 views2 answers
Laravel OrderBy on Eloquent whereHas relationship
PHP
0 vote297 views1 answer
Laravel creating event get data
PHP
7 votes305 views6 answers
Laravel url
PHP Laravel
0 vote241 views1 answer
Cors prevention
PHP
0 vote278 views2 answers
Undefined variable inside function php
PHP
0 vote296 views1 answer
String to slug php
PHP