Apply DAO Generator to PHP and MySQL_PHP Tutorial

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

Data Access Objects (DAO) provide an abstract interface to the database, allowing developers to access common database operations without knowing the details of the database schema - in fact, Data Access Objects implement the low-level data of the application Separation of access logic and high-level business logic. This separation is important because it allows these two important application layers to be relatively independent of each other, allowing us to often scale them independently. After using DAO, the changed business logic can use the same DAO interface, and the modification of the logic will 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:

• Install DAO Generator for PHP and MySQL
• Generate a DAO artifact using the 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

　1. DAO Generator for PHP and MySQL

Usually, we will use a specific language to generate various classes 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 we can use these classes to query and update the MySQL database using the DAO design pattern. The installation and use of this tool are very simple, but if you want to use it efficiently, you need to have a little understanding of the DAO mechanism.

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

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

　2. Extract the downloaded file 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. Architecture of DAO Generator: This figure shows the architecture and data flow of DAO Generator for PHP and MySQL

http://www.bkjia.com/PHPjc/486446.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/486446.htmlTechArticleThis article will reveal how to use the DAO design pattern to generate PHP classes that can complete various common MySQL database operations. Data Access Object (DAO) provides an abstract interface for the database, allowing development...