Direct SQL query from Model in Codeigniter 4 [duplicate]

Question

I'm trying to execute a SQL query directly from Model in CI 4

Controller:

$homemodel = new \App\Models\home_model();

$data['list'] = $homemodel->myquery();

Model:

 public function myquery(){

  $query = "SELECT id FROM tab_anagr WHERE var = 1";
        
  $query=$this->db->query($query);
      
  return $query->result_array();
                
 }

Does'nt work and I receive this error:

Call to undefined method CodeIgniter\Database\MySQLi\Result::result_array()

I would like to receive the array for the view.

I would like to use raw code "SELECT a1, a2 FROM tab1 WHERE x = a" ect ect — Henry8
– Henry8, Commented Nov 23, 2020 at 14:12
that's all in the docs Generating Query Results - Result Arrays — Vickel
– Vickel, Commented Nov 23, 2020 at 18:19

Ahmad Almosallam · Accepted Answer · 2020-11-23 13:53:26Z

4

You should use $query->getResultArray() to get the result as an array, if you want it as object you can use $query->getResult()

answered Nov 23, 2020 at 13:53

Ahmad Almosallam

3043 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ahmad Almosallam Over a year ago

$sql = "SELECT * FROM some_table WHERE id IN ? AND status = ? AND author = ?";  $db->query($sql, [[3, 6], 'live', 'Rick']);

Collectives™ on Stack Overflow

Direct SQL query from Model in Codeigniter 4 [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related