PHP设计模式：
PHP设计模式之装饰器模式
PHP设计模式之委托模式
PHP设计模式之外观模式
PHP设计模式之工厂模式
PHP设计模式之解释器模式
PHP设计模式之迭代器模式
PHP设计模式之中介者模式
如下为数据库脚本：
<ol class="dp-sql"> <li class="alt"><span><span>/*!40101 </span><span class="keyword">SET</span><span> NAMES utf8 */; </span></span></li> <li><span> </span></li> <li class="alt"><span>/*!40101 <span class="keyword">SET</span><span> SQL_MODE=</span><span class="string">''</span><span>*/; </span></span></li> <li><span> </span></li> <li class="alt"><span>/*!40014 <span class="keyword">SET</span><span> @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; </span></span></li> <li><span>/*!40014 <span class="keyword">SET</span><span> @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; </span></span></li> <li class="alt"><span>/*!40101 <span class="keyword">SET</span><span> @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=</span><span class="string">'NO_AUTO_VALUE_ON_ZERO'</span><span> */; </span></span></li> <li><span>/*!40111 <span class="keyword">SET</span><span> @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; </span></span></li> <li class="alt"><span>/*<span class="keyword">Table</span><span> structure </span><span class="keyword">for</span><span> </span><span class="keyword">table</span><span> `cd` */ </span></span></li> <li><span> </span></li> <li class="alt"><span><span class="keyword">DROP</span><span> </span><span class="keyword">TABLE</span><span> IF EXISTS `CD`; </span></span></li> <li><span> </span></li> <li class="alt"><span><span class="keyword">CREATE</span><span> </span><span class="keyword">TABLE</span><span> `CD` ( </span></span></li> <li><span> `id` <span class="keyword">int</span><span>(8) </span><span class="op">NOT</span><span> </span><span class="op">NULL</span><span> AUTO_INCREMENT, </span></span></li> <li class="alt"><span> `band` <span class="keyword">varchar</span><span>(500) </span><span class="keyword">COLLATE</span><span> latin1_bin </span><span class="op">NOT</span><span> </span><span class="op">NULL</span><span> </span><span class="keyword">DEFAULT</span><span> </span><span class="string">''</span><span>, </span></span></li> <li><span> `title` <span class="keyword">varchar</span><span>(500) </span><span class="keyword">COLLATE</span><span> latin1_bin </span><span class="op">NOT</span><span> </span><span class="op">NULL</span><span> </span><span class="keyword">DEFAULT</span><span> </span><span class="string">''</span><span>, </span></span></li> <li class="alt"><span> <span class="keyword">PRIMARY</span><span> </span><span class="keyword">KEY</span><span> (`id`) </span></span></li> <li><span>) ENGINE=InnoDB AUTO_INCREMENT=2 <span class="keyword">DEFAULT</span><span> CHARSET=latin1 </span><span class="keyword">COLLATE</span><span>=latin1_bin; </span></span></li> <li class="alt"><span> </span></li> <li><span>/*Data <span class="keyword">for</span><span> the </span><span class="keyword">table</span><span> `cd` */ </span></span></li> <li class="alt"><span> </span></li> <li><span><span class="keyword">insert</span><span> </span><span class="keyword">into</span><span> `CD`(`id`,`band`,`title`) </span><span class="keyword">values</span><span> (1,</span><span class="string">'Never Again'</span><span>,</span><span class="string">'Waster of a Rib'</span><span>); </span></span></li> <li class="alt"><span> </span></li> <li><span>/*<span class="keyword">Table</span><span> structure </span><span class="keyword">for</span><span> </span><span class="keyword">table</span><span> `tracks` */ </span></span></li> <li class="alt"><span> </span></li> <li><span><span class="keyword">DROP</span><span> </span><span class="keyword">TABLE</span><span> IF EXISTS `tracks`; </span></span></li> <li class="alt"><span> </span></li> <li><span><span class="keyword">CREATE</span><span> </span><span class="keyword">TABLE</span><span> `tracks` ( </span></span></li> <li class="alt"><span> `cid` <span class="keyword">int</span><span>(8) </span><span class="keyword">DEFAULT</span><span> </span><span class="op">NULL</span><span>, </span></span></li> <li><span> `tracknum` <span class="keyword">int</span><span>(8) </span><span class="keyword">DEFAULT</span><span> </span><span class="op">NULL</span><span>, </span></span></li> <li class="alt"><span> `title` <span class="keyword">varchar</span><span>(500) </span><span class="keyword">COLLATE</span><span> latin1_bin </span><span class="op">NOT</span><span> </span><span class="op">NULL</span><span> </span><span class="keyword">DEFAULT</span><span> </span><span class="string">''</span><span> </span></span></li> <li><span>) ENGINE=InnoDB <span class="keyword">DEFAULT</span><span> CHARSET=latin1 </span><span class="keyword">COLLATE</span><span>=latin1_bin; </span></span></li> <li class="alt"><span> </span></li> <li><span>/*Data <span class="keyword">for</span><span> the </span><span class="keyword">table</span><span> `tracks` */ </span></span></li> <li class="alt"><span> </span></li> <li><span><span class="keyword">insert</span><span> </span><span class="keyword">into</span><span> `tracks`(`cid`,`tracknum`,`title`) </span><span class="keyword">values</span><span> (1,3,</span><span class="string">'What It Means'</span><span>),(1,3,</span><span class="string">'Brr'</span><span>),(1,3,</span><span class="string">'Goodbye'</span><span>); </span></span></li> <li class="alt"><span> </span></li> <li><span>/*!40101 <span class="keyword">SET</span><span> SQL_MODE=@OLD_SQL_MODE */; </span></span></li> <li class="alt"><span>/*!40014 <span class="keyword">SET</span><span> FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; </span></span></li> <li><span>/*!40014 <span class="keyword">SET</span><span> UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; </span></span></li> <li class="alt"><span>/*!40111 <span class="keyword">SET</span><span> SQL_NOTES=@OLD_SQL_NOTES */; </span></span></li> </ol>
