How to write this query in Codeigniter Active Record |
how to write this query in active record format?
SELECT COUNT(TotalBook) AS BooksRow FROM ( SELECT COUNT( BookID ) TotalBook FROM books GROUP BY Title ) src i need help
Honestly, for more complex SQL like this one, I don't worry about the Query Builder unless I really need to for some reason. Something like this works just fine:
Code: $this->db->query('SELECT COUNT(TotalBook) AS BooksRow FROM ( SELECT COUNT( BookID ) TotalBook FROM books GROUP BY Title ) src'); This one doesn't need it, but if you have user-supplied input you should definitely use Query Bindings. However, I believe you can do the following (completely untested): Code: $this->db->select('COUNT(TotalBook) AS BooksRow')
(08-25-2016, 10:41 AM)Thanks for your reply :) and yes i am adding user bindings in it that\s why for security reasons i wanted the active record. i will use "where" and "like" clauses in the sub query can you please also add 1 example of where and like clause in this active record sub query part .kilishan Wrote: Honestly, for more complex SQL like this one, I don't worry about the Query Builder unless I really need to for some reason. Something like this works just fine: |
Welcome Guest, Not a member yet? Register Sign In |