您好,登錄后才能下訂單哦!
如何在PHP中實(shí)現(xiàn)數(shù)據(jù)對(duì)象映射模式?很多新手對(duì)此不是很清楚,為了幫助大家解決這個(gè)難題,下面小編將為大家詳細(xì)講解,有這方面需求的人可以來學(xué)習(xí)下,希望你能有所收獲。
數(shù)據(jù)庫 test ,user 表結(jié)構(gòu):
CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) CHARACTER SET utf8 DEFAULT NULL, `mobile` varchar(11) CHARACTER SET utf8 DEFAULT NULL, `regtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
Common\User.php:
<?php namespace Common; class User{ public $id; public $name; public $mobile; public $regtime; protected $db; //構(gòu)造方法 function __construct($id) { $this->db = new Database\MySQLi(); $conn = $this->db->connect('127.0.0.1', 'root', '', 'test'); $res = $this->db->query("select * from user where id = {$id} limit 1"); $data = $res->fetch_assoc(); $this->id = $data['id']; $this->name = $data['name']; $this->mobile = $data['mobile']; $this->regtime = $data['regtime']; } //析構(gòu)方法 function __destruct() { $this->db->query("update user set name = '{$this->name}', mobile = '{$this->mobile}', regtime = '{$this->regtime}' where id = {$this->id} limit 1"); } }
Common\Databases\MySQLi.php
<?php namespace Common\Database; use Common\IDatabase; class MySQLi implements IDatabase{ protected $conn; function connect($host, $user, $passwd, $dbname){ $conn = mysqli_connect($host, $user, $passwd ,$dbname); $this->conn = $conn; } function query($sql){ $res = mysqli_query($this->conn, $sql); return $res; } function close(){ mysqli_close($this->conn); } }
入口文件 index.php
<?php define('BASEDIR',__DIR__); //定義根目錄常量 include BASEDIR.'/Common/Loader.php'; spl_autoload_register('\\Common\\Loader::autoload'); echo '<meta http-equiv="content-type" content="text/html;charset=utf8">'; /* * 對(duì)對(duì)象屬性的操作就完成了對(duì)數(shù)據(jù)庫的操作 */ $user = new Common\User(1); //讀取數(shù)據(jù) var_dump($user->id, $user->mobile, $user->name, $user->regtime);exit(); $user->mobile = '13800138000'; $user->name = 'Arshavin'; $user->regtime = date("Y-m-d H:i:s",time());
看完上述內(nèi)容是否對(duì)您有幫助呢?如果還想對(duì)相關(guān)知識(shí)有進(jìn)一步的了解或閱讀更多相關(guān)文章,請(qǐng)關(guān)注億速云行業(yè)資訊頻道,感謝您對(duì)億速云的支持。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。