Data Access Object Mode
The Data Access Object Mode describes how to create objects that access the data source transparently.
Scenario Design
Design a BaseDao base class to implement the basic query, insert, and update Methods for database operations.
In actual use, you can directly call the base-class database operation method by inheriting BaseDao.
Code: BaseDao database operation base class
[Php]
<? Php
// Data Access Object Mode
// Remove the database access layer as a public access interface, which is convenient for users. It is a common design mode in php.
Class BaseDao {
Private $ db;
Public function _ construct ($ config ){
$ This-> db = mysql_connect ($ config ['user'], $ config ['pass'], $ config ['host']);
Mysql_select_db ($ config ['database'], $ this-> db );
}
Public function query ($ SQL ){
Return mysql_query ($ SQL, $ this-> db );
}
}
Code: Data Operations on UserDao user data tables, inherited from BaseDao
[Php] www.2cto.com
<? Php
Include ("UserDao. php ");
Class UserDao extends BaseDao {
Public function addUser (){
$ SQL = "INSERT INTO user (username) VALUES ('initphp ')";
Return $ this-> query ($ SQL );
}
}
$ UserDao = new UserDao;
$ UserDao-> addUser ();
Author: initphp