Using the DAO Generator for PHP and MySQL
Data access object (DAO) provides an abstract interface to a database—giving developers access to common database operations without them having to know the database schema details—essentially, data access object separate the business logic and data tiers of an application. This separation is important, because these two important application tiers should know almost nothing about each other, and you can expect both to evolve frequently and independently. With DAO in place, changing business logic can use the same DAO interface, while changes to persistence logic does not affect DAO clients—as long as the interface remains correctly implemented.
The DAO generator for PHP and MySQL automates the process of creating DAO classes for MySQL databases. In this article, you’ll see how to:
- Install the DAO generator for PHP and MySQL
- Generate a DAO artifact using a given database (bookstore)
- Create an application using DAO generator tool and its factory classes
- Create a transaction spanning multiple SQL operations
- Add a custom DAO function to a generated class
