Home arrow PHP arrow Page 3 - Using Visitor Objects with MySQL Data Sets in PHP 5

Revealing the anatomy of a visitor class: creating visitor objects - PHP

If you’re looking for brand new material to help you expand your background in using design patterns with PHP 5, then hopefully this article will suit your needs. Welcome to the final installment of the series “Introducing Visitor Objects in PHP 5.” Composed of three chapters, this series walks you through the key points of creating and using visitor objects with PHP 5, and teaches you how to use them in the context of real-world applications.

  1. Using Visitor Objects with MySQL Data Sets in PHP 5
  2. Visiting database result sets: establishing an interaction between visitors and MySQL
  3. Revealing the anatomy of a visitor class: creating visitor objects
  4. Completing the round trip: defining the structure of a pagination class
By: Alejandro Gervasio
Rating: starstarstarstarstar / 9
August 16, 2006

print this article



As you learned in the previous section, building a MySQL result processing class capable of accepting a visitor object is in fact a straightforward process. Nevertheless, the structure of the visitor class itself hasn't been defined yet. Thus, considering this condition, it's very convenient to start modeling its general signature.

But how will this be done? That's a simple question to answer. First I'll define an abstract visitor class, and then I'll derive a subclass from it, which will implement concretely the corresponding methods.

Therefore, here is the base abstract class that defines the general structure of visitor objects:

// define abstract 'Visitor' class
abstract class Visitor{
    abstract function visitMySQLResult(Result $resultObj);

As you can appreciate, the above abstract class has only one relevant method, that is "visitMySQLResult()", which defines the generic behavior of the class in question. However, it should be noticed how this method accepts an object of type "Result" as its unique incoming argument, in order to do its business.

Since the previous "Visitor" base class shouldn't present big difficulties with understanding its structure, now let me show you the respective subclass that will be provided with the concrete ability to inspect MySQL result sets. Please, take a look at the signature of this new child class:

// define subclass 'MySQLResultVisitor'
class MySQLResultVisitor extends Visitor{
    private $resultObj;
    public function visitMySQLResult(Result $resultObj){
        return $resultObj->countRows();

Now you'll have to agree with me that the previous sub class is highly comprehensive. After all, its whole functionality is based simply on taking a result object as incoming parameter, and returning the number of rows present in the record set by using its "countRows()" method. True to form, this visitor in particular isn't very demanding with reference to its visited objects, but it shows in a clear fashion how the visitor pattern can be applied in this specific situation. This isn't rocket science at all!

Fine, at this stage you hopefully learned how a MySQL processing class can be coded in such a way that it can accept a visitor object. In addition, you also saw how the proper visitor class was defined. So, the question that comes now is: what's the next step?

Well, as I expressed right at the beginning of this article, my intention was to create a visitor object which will be capable of establishing an interaction between several MySQL result sets and a PHP-based pagination system. Based on that prerequisite, in the following section I'll create a comprehensive pagination class which will use a single visitor object to paginate the pertinent MySQL data sets.

To find out how this process will be done, please click on the link below and keep reading.

>>> More PHP Articles          >>> More By Alejandro Gervasio

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: