Apply DAO Generator to PHP and mysql_php tutorials

This article will reveal how to use the DAO design pattern to generate PHP classes that can perform a variety of common MySQL database operations.

The data Access Object (DAO) provides an abstract interface to the database, which allows developers to access common database operations without needing to know the details of the database schema-in fact, data access objects implement the separation of low-level data access logic from the application and high levels of business logic. This separation is important because it makes these two important application tiers relatively independent of each other, allowing us to expand them on a regular basis. With DAO, the changed business logic can use the same DAO interface, while the modification of the logic does not affect the DAO client-as long as the implementation of the interface is appropriate.

DAO Generator for PHP and MySQL can automatically create DAO classes for MySQL databases. In this article, we'll show you how to:

• Installing the DAO Generator for PHP and MySQL
• Build a DAO artifact that uses a given database (bookstore)
• Create an application using the DAO Generator tool and its factory class
• Create a transaction that generates multiple SQL operations
• Add a custom DAO function to the generated class

　　A. DAO Generator for PHP and MySQL

Typically, we use a specific language to generate various classes for specific target databases. For example, we can use DAO Generator to generate PHP classes for the PHP language and MySQL database to use these classes to query and update the MySQL database using the DAO design pattern. The installation and use of this tool is simple, but to use it efficiently, you need a little bit of understanding of the DAO mechanism.

You can download the DAO Generator for PHP and MySQL with the address http://www.phpdao.com/. To install it, you can follow these steps:

1. Download the compressed document Phpdao-1.7.zip.

2. Extract the downloaded files to the Htdocs directory.

3. Set up a connection for an existing database by specifying the database properties in the templates/class/dao/sql/connectionproperty.class.php file.

4. Run the generate.php script.

5. The tool adds the generated classes to the newly created folder named generated.

Figure 1 below shows the architecture of the DAO Generator for PHP and MySQL.

Figure 1. DAO Generator Architecture: This diagram shows the architecture and data flow of the DAO generator for PHP and MySQL

http://www.bkjia.com/PHPjc/486446.html www.bkjia.com true http://www.bkjia.com/PHPjc/486446.html techarticle This article will reveal how to use the DAO design pattern to generate PHP classes that can perform a variety of common MySQL database operations. The data Access Object (DAO) provides an abstract interface for the database, which makes development ...

