Apply DAOGenerator to PHP and MySQL

This article will reveal how to use the DAO design pattern to generate PHP classes that can complete various common MySQL database operations. The Data Access Object (DAO) provides an abstract interface for the database, so that developers can access common database operations without having to know the details of the database mode, the Data Access Object implements the low-level data access logic of the application "> <LINKhref =" http: // www. php100

This article will reveal how to use the DAO design pattern to generate PHP classes that can complete various common MySQL database operations.

The Data Access Object (DAO) provides an abstract interface for the database, allowing developers to access common database operations without having to know the details of the database mode-in fact, the Data Access Object separates the application's low-level data access logic from the high-level business logic. This separation is very important because it allows the two important application layers to be relatively independent from each other, so that we can often expand them separately. After DAO is used, the same DAO interface can be used for the changing business logic, and modifications to the logic will not affect the DAO client-as long as the implementation of this interface is appropriate.

DAO Generator for PHP and MySQL can automatically create DAO classes for MySQL databases. This article describes how:

• Install DAO Generator for PHP and MySQL
• Generate a DAO job that uses a given database (bookstore)
• Use DAO Generator and its factory class to create an application
• Create a transaction that generates multiple SQL operations
• Add a customized DAO function for the generated class

　　I. DAO Generator for PHP and MySQL

Generally, we use a specific language to generate various types for a specific target database. For example, we can use DAO Generator to generate PHP classes for the PHP language and MySQL database, so that these classes can be used to query and update the MySQL database using DAO design mode. This tool is easy to install and use, but to use it efficiently, you need to have a little understanding of the DAO mechanism.

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

1. download the compressed file phpdao-1.7.zip.

2. decompress the downloaded file to the htdocs directory.

3. set a connection for an existing database by specifying the database attribute in the templates/class/dao/SQL/ConnectionProperty. class. php file.

4. run the generate. php script.

5. the tool adds the generated class to the newly created folder named generated.

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

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