Avatar

“Substitute” SQL’s statements by PHP (Features)

by Auge ⌂, Thursday, May 16, 2019, 10:08 (1808 days ago) @ pdp-7

Hello

What I meant that your PHP controls the pagination in the way that you have this 26 to 50 window you want those posts, as mentioned earlier. But you get those titles one by one from 26 until count is 50 so that way SQL would be much simpler and you just need to ++i and then send that request to DB...

So first it gets number 26 then in PHP ++i and then sql request for 27 and so on ...

No, that would not work well. From where should the PHP-script know, which datasets it should request? Should the script executing additional requests to know, which datasets to request? No, this is a task for the database system.

Hope this makes more sense.

No, it doesn't.

Tschö, Auge

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread