## 8-1 數據對象映射模式之簡單案例實現 ### 1. 創建`user`表 ~~~ -- 創建用戶表 CREATE TABLE IF NOT EXISTS `user`( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(30) NOT NULL DEFAULT '', `passwd` VARCHAR(32) NOT NULL DEFAULT 'e10adc3949ba59abbe56e057f20f883e', `created_time` INT(10) NOT NULL DEFAULT 0 )ENGINE=InnoDB DEFAULT CHARSET=UTF8; -- 測試數據 INSERT INTO `user` (name, passwd, created_time) VALUES ('Mark', md5('12345'), UNIX_TIMESTAMP()), ('Lily', md5('12345'), UNIX_TIMESTAMP()), ('Lucy', md5('12345'), UNIX_TIMESTAMP()), ('Bob', md5('12345'), UNIX_TIMESTAMP()), ('Tom', md5('12345'), UNIX_TIMESTAMP()), ('Christian', md5('12345'), UNIX_TIMESTAMP()); ~~~ ### 2. 創建`User`類 *D:\wamp\www\demo\oop\framework\Think\User.php* ~~~ <?php namespace Think; class User { public $id; public $name; public $passwd; public $created_time; function __construct($id) { // 創建對象后，自動執行 } function __destruct() { // 對象注銷前，自動執行 } } ~~~ ### 3. 使用構造方法實現數據的讀取操作 *D:\wamp\www\demo\oop\framework\Think\User.php* ~~~ <?php namespace Think; class User { public $id; public $name; public $passwd; public $created_time; protected $db; function __construct($id) { // 創建對象后，自動執行 $this->db = new Database\MySQLi(); $this->db->connect('localhost', 'root', 'root', 'demo'); $ret = $this->db->query('SELECT * FROM `user` WHERE `id` = ' . $id); $this->db->close(); $data = mysqli_fetch_assoc($ret); $this->id = $data['id']; $this->name = $data['name']; $this->passwd = $data['passwd']; $this->created_time = $data['created_time']; } function __destruct() { // 對象注銷前，自動執行 } } ~~~ ### 4. 在入口文件處，獲取數據表中的值 *D:\wamp\www\demo\oop\framework\index.php* ~~~ // 實例化1個用戶表對象：User $user = new Think\User(2); // 獲取對象中的屬性，對象數據表中的一條記錄 echo $user->id."<br/>"; echo $user->name."<br/>"; echo $user->passwd."<br/>"; echo $user->created_time."<br/>"; ~~~ ### 5. 使用析構方法自動保存數據 *D:\wamp\www\demo\oop\framework\index.php* ~~~ // 修改屬性值之后，利用析構方法自動保存 $user->name = '王五'; $user->passwd = md5('123'); $user->created_time = time(); ~~~ *D:\wamp\www\demo\oop\framework\Think\User.php* ~~~ function __destruct() { // 對象注銷前，自動執行 $sql = "UPDATE `user` SET name = '{$this->name}', passwd = '{$this->passwd}', created_time = '{$this->created_time}' WHERE id = {$this->id}"; echo $sql; $this->db->query($sql); $this->db->close(); } ~~~