How can I print stored procedure query in codeignitor model?

Question

I want to print SQL query from my stored procedure.

My procedure like:

$Insert-array = my values;

$query = $this->db->query("CALL Category(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,@id)", $Insert-array);

I use print_r($this->db->last_query());.

My result looks like this:

CALL Category(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,@id)

When I use print query statement.. now how can I print the SQL statement query from the stored procedure?

do you mean that you would like to see the stored procedure with the values instead of placeholders? — Professor Abronsius, Nov 01 '19 at 09:05
I think you are asking for queries written inside stored procedure ? — Bilal Siddiqui, Nov 01 '19 at 09:07
If you want to print the actual SQL commands written within the `stored procedure` then you cannot do so automagically — Professor Abronsius, Nov 01 '19 at 09:12
you can enable logs in the sql server for a period and see what reaches the server. — nbk, Nov 01 '19 at 11:30

score 0 · Answer 1 · answered Nov 04 '19 at 05:06

I'll usually include a DEBUG param that defaults to false and I can set to true at run time. Then wrap the debug statements into an "If DEBUG" block.

I also use a logging table with many of my jobs so that I can review processes and timing. My Debug code gets output there as well. I include the calling param name, a brief description, row counts affected (if appropriate), a comments field and a time stamp.

for more about debugging please refer here

How can I print stored procedure query in codeignitor model?

1 Answers1