Tips
Professional PHP
It’s important to remember what sets a professional PHP developer apart from the pack that floods your average help channel.
Too often I run into reviewing or helping a “professional” developer, and I can’t help but mutter “you’re doing it wrong…”
PHP & MySQL Tip #2 - Better Way of Pagination
I’ve seen this come up a few times in #php on irc.gamesurge.net - how to find the total number of rows found, while using the LIMIT clause on a query.
I’ve seen people respond with some seriously incorrect solutions, such as ‘Simply load all of the results into an array and only show X amount’ or ‘Simple run another query without the LIMIT clause and count those rows.’
Those two, common, solutions are sadly not the best solution.
Read on to discover my solution.