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 vote162 views1 answer
Requires ext-pcntl
PHP
103 votes286 views6 answers
Php str_replace
PHP
0 vote170 views1 answer
The posts pagination
PHP
1 vote169 views3 answers
Required_if laravel
PHP Laravel
2 votes195 views1 answer
Laravel artisan create criteria
PHP Laravel
0 vote167 views1 answer
Acf select multiple choice array in loop
PHP
1 vote216 views1 answer
Laravel mongodb delete
PHP
1 vote183 views3 answers
Check image exist or not in laravel
PHP
0 vote167 views1 answer
Autoload_namespaces.php failed to open stream: Permission denied
PHP
0 vote172 views1 answer
Complete url php
PHP