Articles

Select a category from the menu on the right, or browse the latest articles below.

Latest Articles

SQL Update Multiple Rows

Posted in SQL on 10th June 2008

Occasionally it is useful to update multiple rows in a table using SQL. Rather than hammer the database with multiple queries using a PHP loop or similar, you can combine the updates into a single query.

Read Article...

PHP Singleton Object Registry

Posted in PHP on 17th May 2008

This article takes a look at the concept of Singletons in PHP programming, and shows you how to use them to create an Object Registry.

Read Article...

PHP Database Abstraction Layer

Posted in PHP on 10th May 2008

If you've ever had to re-work a project to utilise a different database provider, you will know that the process can be hugely time consuming, involving changing every instance of database-specific functions such as mysql_query() throughout your code. In this article I will show you how to create a database abstraction layer that will allow you to change database provider by changing just one line of code.

Read Article...

Breadcrumb Navigation Using PHP

Posted in PHP on 03rd May 2008

Breadcrumb navigation is an extremely useful addition to any site where ease of use and accessibility are important. It provides links back to each previous page that the user navigated through in order to get to the current page. This article demonstrates how to create dynamic breadcrumb navigation using PHP.

Read Article...