$this->db->last_query() returns NULL in Codeigniter 4. How to get query SQL?

Question

I just started learning Codeigniter 4. My query always generates NULL and I don't know why. How can I see the generated SQL Select command just like Codeigniter 3?

In Codeigniter 3 this command does the job:

echo $this->db->last_query();

And this is my controller code in Codeigniter 4 that I need to get the generated query:

$cityModel = new CityModel();
$cities = $cityModel
    ->select('city.name AS cityName')
    ->select('county.name AS countryName')
    ->select('province.name AS provinceName')
    ->join('province', 'city.province_id = province.id', 'left')
    ->join('county', 'city.county_id = county.id', 'left')
    ->result();

Update: I tried this code but it's returning an empty string:

var_export((string)$cityModel->db->getLastQuery());

"My query always generates NULL"? maybe county.name should be country.name. "What's the $db? It's not defined in the controller"? you could define it like this: $db=$this->db; — Vickel
– Vickel, Commented Jan 31, 2020 at 16:47

DivPusher · Accepted Answer · 2020-04-30 11:32:45Z

14

This should display the final query:

$cityModel->getLastQuery()->getQuery()

answered Apr 30, 2020 at 11:32

DivPusher

1962 silver badges5 bronze badges

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

Comments

Devsi Odedra · Accepted Answer · 2020-01-31 08:52:06Z

5

In CI 4 Refer Doc

you can use getLastQuery() as

$query = $db->getLastQuery();
echo (string)$query;

answered Jan 31, 2020 at 8:52

Devsi Odedra

5,3421 gold badge25 silver badges38 bronze badges

2 Comments

rostamiani Over a year ago

What's the $db? It's not defined in the controller.

NomanJaved Over a year ago

use $this->db to get the last query.

Asif Thebepotra · Accepted Answer · 2022-12-23 10:04:58Z

4

This worked for me

$myModel = new MyModel();// your any model
    
$myModel->db->getLastQuery()->getQuery();

$this->db is not directly accessible from controller, but if you have any Model instance then you can have the full access to db object.

edited Dec 23, 2022 at 10:04

answered Dec 22, 2022 at 17:29

Asif Thebepotra

3404 silver badges12 bronze badges

3 Comments

Jeremy Caney Over a year ago

What's the difference between this approach and Piyush's answer from September? Doesn't $this translate to $myModel in this case?

Asif Thebepotra Over a year ago

In My Case, $this->db was not accessible from Controller, I need to create instance for it. But I tried with my Model instance and it worked.

Jeremy Caney Over a year ago

That's useful to know. I'd recommend editing your answer to include that information so that it's clear upfront how it differs from Piyush's answer.

cottton · Accepted Answer · 2021-11-22 08:59:04Z

2

This code will help you to get the last query in codeigniter 4.

 $this->db = \Config\Database::connect();
 $data = $builder->get()->getResult();
 echo $this->db->getLastQuery(); die;

edited Nov 22, 2021 at 8:59

cottton

1,64716 silver badges32 bronze badges

answered Nov 19, 2021 at 5:29

Wprog_dy

655 bronze badges

Comments

Fawad Saboor · Accepted Answer · 2020-02-07 10:05:38Z

0

You can use getCompiledSelect it will return the query SELECT command.

$sql = $cityModel->getCompiledSelect();
echo $sql;

edited Feb 7, 2020 at 10:05

answered Jan 31, 2020 at 11:55

Fawad Saboor

894 bronze badges

2 Comments

Fawad Saboor Over a year ago

in your case it will be $cityModel->getCompiledSelect(); it attaches with $this->db->getCompiledSelect()

Fasil Palanthodi Over a year ago

Not work for a join query?

Piyush Bansal · Accepted Answer · 2022-09-12 11:31:19Z

0

Following Code will work in CI 4

$this->db->getLastQuery()->getQuery();

answered Sep 12, 2022 at 11:31

Piyush Bansal

1,7334 gold badges17 silver badges39 bronze badges

1 Comment

Fasil Palanthodi Over a year ago

Worked for me, it returning the query.

fajarra · Accepted Answer · 2022-02-05 10:38:13Z

-1

Add this code in your class

$db = \Config\Database::connect();
$query = $db->getLastQuery();
echo $query;

answered Feb 5, 2022 at 10:38

fajarra

113 bronze badges

1 Comment

Cristik Over a year ago

Won't this make a new connection, which doesn't yet have a "last query"?

James Risner · Accepted Answer · 2022-10-23 22:48:56Z

-1

Simply just use $this->db->getLastQuery();

edited Oct 23, 2022 at 22:48

James Risner

6,09711 gold badges33 silver badges60 bronze badges

answered Oct 19, 2022 at 2:58

Tanay Syed

156 bronze badges

Collectives™ on Stack Overflow

$this->db->last_query() returns NULL in Codeigniter 4. How to get query SQL?

8 Answers 8

Comments

2 Comments

3 Comments

Comments

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

2 Comments

3 Comments

Comments

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related