Any way to use the query builder without a database connection? |
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, 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
|
Welcome Guest, Not a member yet? Register Sign In |