Archive for September 2011

 
 

DELETE with JOIN

This article will explain how to delete data from one table based on data in another table – how to use JOIN in DELETE queries.


| Read more …

MySQL JOIN Explained

While selecting data from MySQL server, we can join tables in three basic ways. Using JOINLEFT JOIN and/or RIGHT JOIN. In this post, I’ll try to put all those three in practice.

| Read more …

Iterator for collections in PHP

In this article, I’ll try to explain how to use PHP’s Iterator and IteratorAggregate interfaces to create objects that can act as array in your code, simplify loading and protect your data. We’ll also create an example on how to create “loadable” collection – a collection or array that loads only when it’s needed. But first, we have to create our base classes that will provide the base functions for our Collection class.

| Read more …

Singleton pattern in PHP

Here’s a small tutorial and example PHP code on how to maintain a single instance of one object (Singleton pattern) throughout the script. You might have a complex script with bunch of objects flying around and it’s hard to keep them all available in global context. Here’s a simple OOP solution to a single object instance in PHP5.


| Read more …

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close