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 vote104 views1 answer
Laravel number input positive only
PHP
0 vote102 views1 answer
How to wp create post type in wordpress
PHP
0 vote104 views1 answer
Include string special in php
PHP
0 vote104 views1 answer
Create a custom method laravel model
PHP
5 votes130 views3 answers
Globals in php
PHP
0 vote124 views1 answer
Combine date time php
PHP
15 votes156 views6 answers
Laravel create request
PHP Laravel
37 votes101 views6 answers
Laravel create or update
PHP
38 votes92 views6 answers
Create table laravel
PHP
0 vote112 views1 answer
Cloudinary laravel
PHP Laravel