What's the equivalent of $this->db->last_query() in Codeigniter 4?

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, Jan 31 '20 at 16:47

score 10 · Answer 1 · answered Apr 30 '20 at 11:32

10

This should display the final query:

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

answered Apr 30 '20 at 11:32

DivPusher

156
2
5

score 5 · Answer 2 · answered Jan 31 '20 at 08:52

5

In CI 4 Refer Doc

you can use getLastQuery() as

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

answered Jan 31 '20 at 08:52

Devsi Odedra

5,244
1
23
37

1

What's the $db? It's not defined in the controller. – rostamiani Jan 31 '20 at 10:36
use `$this->db` to get the last query. – NomanJaved Sep 22 '22 at 19:24

score 2 · Answer 3 · edited Nov 22 '21 at 08:59

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 '21 at 08:59

cottton

1,522
14
29

answered Nov 19 '21 at 05:29

Wprog_dy

67
5

Fawad Saboor · Accepted Answer · 2020-02-07T10:05:38.357

1

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

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

edited Feb 07 '20 at 10:05

answered Jan 31 '20 at 11:55

Fawad Saboor

91
4

2

in your case it will be $cityModel->getCompiledSelect(); it attaches with $this->db->getCompiledSelect() – Fawad Saboor Feb 03 '20 at 08:59
Thanks. This worked! please edit your answer. Then I will accept it – rostamiani Feb 04 '20 at 18:18

score 0 · Answer 5 · answered Sep 12 '22 at 11:31

0

Following Code will work in CI 4

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

answered Sep 12 '22 at 11:31

Piyush Bansal

1,635
4
16
39

score 0 · Answer 6 · edited Oct 23 '22 at 22:48

0

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

edited Oct 23 '22 at 22:48

James Risner

5,451
11
25
47

answered Oct 19 '22 at 02:58

Tanay Syed

19
6

Asif Thebepotra · Answer 7 · 2022-12-23T10:04:58.887

0

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 '22 at 10:04

answered Dec 22 '22 at 17:29

Asif Thebepotra

300
3
10

What's the difference between this approach and Piyush's answer from September? Doesn't `$this` translate to `$myModel` in this case? – Jeremy Caney Dec 22 '22 at 17:41
1

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. – Asif Thebepotra Dec 22 '22 at 17:55
1

That's useful to know. I'd recommend [edit]ing your answer to include that information so that it's clear upfront how it differs from Piyush's answer. – Jeremy Caney Dec 23 '22 at 00:45

score -1 · Answer 8 · answered Feb 05 '22 at 10:38

-1

Add this code in your class

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

answered Feb 05 '22 at 10:38

fajarra

11
3

1

Won't this make a new connection, which doesn't yet have a "last query"? – Cristik Feb 05 '22 at 12:33

What's the equivalent of $this->db->last_query() in Codeigniter 4?

8 Answers8