Welcome Guest, Not a member yet? Register   Sign In
How to implement pagination on number and alphabet at the same time [CI3]
#1

(This post was last modified: 08-08-2019, 08:21 AM by ciadmin.)

Pagination on the number of pages but if i want to view data start with K, i click on 'K' and its jump to page 33 which is a page that starting with k letter. How to implement something like this? 

select all data to find the K starting point look waste of resource (because we need to find other 25 letter starting point too) any better way to implement this?

for example: *REDACTED*
[Image: jqTDttt.jpg]
Reply
#2

I think you will have to do as you say: select all the titles and find the right page number.
But you can cache the result for better performance and not do this at each page load: https://www.codeigniter.com/user_guide/l...ching.html
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/
Reply
#3

Also can you please not post porn site as example!  Dodgy
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/
Reply
#4

(08-08-2019, 07:00 AM)includebeer Wrote: I think you will have to do as you say: select all the titles and find the right page number.
But you can cache the result for better performance and not do this at each page load: https://www.codeigniter.com/user_guide/l...ching.html

Thank you for your suggestion. and sorry about example link ;-;
Reply




Theme © iAndrew 2016 - Forum software by © MyBB