CodeIgniter Forums

Full Version: Any way to use the query builder without a database connection?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi All -


I'm hoping to use the CI query builder (we're in v3) to generate SQL statements. The only problem is that we don't actually have a connection to run them in. Our application sends queries via a web service to have them run against a cloud-hosted MySQL instance (passing the select statement as the HTTP body).

Is there any way to use CI's query builder to simply generate the SQL statement and to return the assembled statements as strings?

Thanks in advance -

Trent
@trentwritescode,

Checkout the $this->db->get_compiled_select() [link: https://codeigniter.com/user_guide/datab...cting-data ] feature.
(03-25-2019, 10:56 AM)php_rocs Wrote: [ -> ]@trentwritescode,

Checkout the $this->db->get_compiled_select() [link: https://codeigniter.com/user_guide/datab...cting-data ] feature.

Unfortunately, this requires a properly-configured database connection –– something we do not have.
The framework unit testing has a mock database that might be the trick...
https://github.com/codeigniter4/CodeIgni...t/Database
I'll keep this in mind when we moved to CI4. Thanks!