How to print SQL statement in codeigniter model

by

You can use this:

$this->db->last_query();

“Returns the last query that was run (the query string, not the result).”

Reff: https://www.codeigniter.com/userguide3/database/helpers.html

More Related Contents:

  1. CodeIgniter MSSQL connection
  2. How to execute my SQL query in CodeIgniter
  3. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  4. how to get client’s IP address in sql database [closed]
  5. Combine multiple sql / mysql queries in one query
  6. Parse error: parse error, expecting `'{” in [closed]
  7. Cleansing User Passwords
  8. CodeIgniter removing index.php from url
  9. Remove index.php From URL – Codeigniter 2
  10. Simple PHP Pagination script [closed]
  11. CodeIgniter PHP Framework – Need to get query string
  12. How to add an ORDER BY clause using CodeIgniter’s Active Record methods?
  13. How can I Use Prepared Statements in CodeIgniter
  14. How do I check if the request is made via AJAX in CodeIgniter?
  15. Codeigniter – Using Multiple Databases
  16. How to create Codeigniter language files from database?
  17. How to get data in function extend controller?
  18. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  19. How to generate unique id in MySQL?
  20. Upload multiple files in CodeIgniter
  21. Codeigniter session data lost after redirect
  22. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  23. Codeigniter CSRF valid for only one time ajax request
  24. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  25. Role Based Access Control
  26. How can I redirect a 404 Error in a custom 404 page using Codeigniter?
  27. Php & Sql Injection – UTF8 POC
  28. Escaping SQL queries in Codeigniter
  29. Aggregated query without GROUP BY
  30. Sending XML data using HTTP POST with PHP

Leave a Comment