The ramblings of a Coding MadMan
Many websites using search engine optimised URL’s require a single point of entry and for this they use the Apache ErrorDocument 404 call. This means every page is redirected to a control page which can then analyse the URI Request and decide which page to load.
I have decided to start a series on PHP Tips and Tricks, and I may even throw in a few other bits and bobs that I have come across. To start with, I’m going to be covering PHP shortcuts that every beginner should know (I didn’t find these out until much later in my PHP experience!) and a few other tidbits.
Whilst working on a database query for part of my project, I had to join a few tables in a query. It was nothing out of the ordinary, however after some alterations and debugging later, I found out the query execution time took over 2 seconds! This was incredibly worrying, so I started performing some immense debugging and I couldn’t for the life of me figure out why this query should be executing to slowly.
I plan on sharing my experiences predominantly from a development point of view on a few projects I’m currently working on. I develop some medium-ish e-commerce sites using everyone’s favourite PHP and MySQL combo. I hope to leave a few coding tips that I have picked up along the way and rant about any annoyances I come across as well. To get me started, I share the wonders and not so wonders of Windows Live Writer (Blogging Tool).