PHP Design Pattern Series-Data Access object mode

• Data Access Object mode

The data Access object pattern describes how to create objects that transparently access the data source.

• Scene design

1. Design a Basedao base class to implement some basic query,insert,update methods of database operation
2. In the actual use of the process, inherit Basedao, you can directly call the base class database operation method

• Code: Basedao Database Operations base class

<?PHP//data Access Object mode//separate the database access layer as a common access interface, user-friendly, is a common design pattern in PHP          classBasedao {Private $db;  Public function__construct ($config) {               $this->db =mysql_connect($config[' User '],$config[' Pass '],$config[' Host ']); mysql_select_db($config[' Database '],$this-db); }                     Public functionQuery$sql) {              return mysql_query($sql,$this-db); }      }  

Code: Userdao Data manipulation of user data tables, inheriting Basedao

<?PHPinclude("userdao.php"); classUserdaoextendsBasedao { Public functionAddUser () {$sql= "INSERT into user (username) VALUES (' initphp ')"; return $this->query ($sql); }      }            $UserDao=NewUserdao; $UserDao->adduser ();

Transferred from: http://blog.csdn.net/initphp/article/details/7678831

PHP Design Pattern Series-Data Access object mode