Does CI3 db object offer SQL_CALC_FOUND_ROWS functionality? |
So I have a crazy search that shows paginated results. Obviously, it's extra work to have to create one query for the search and another just to get the number of TOTAL results. Does the CI3 db class provide any similar sort of functionality to SQL_CALC_FOUND_ROWS?
What does everyone think about the suggestion here on the old forum which suggests this: Code: $this->db->select("SQL_CALC_FOUND_ROWS *", FALSE); // Second param disables escaping and allows SQL_CALC_FOUND_ROWS to work/code] |
Messages In This Thread |
Does CI3 db object offer SQL_CALC_FOUND_ROWS functionality? - by sneakyimp - 01-30-2015, 10:05 AM
|