模型是ZF2對數據庫操作的核心內容，也是進行數據過濾、數據交換的功能專區。 ### 7.5.1 添加 Album.php 此文件包括數據交換、表單數據過濾功能；添加 `/module/Album/src/Album/Model/Album.php` 內容如下： ~~~ namespace Album\Model; use Zend\InputFilter\Factory as InputFactory; use Zend\InputFilter\InputFilter; use Zend\InputFilter\InputFilterAwareInterface; use Zend\InputFilter\InputFilterInterface; class Album implements InputFilterAwareInterface { public $id; public $artist; public $title; protected $inputFilter; public function exchangeArray($data){ $this->id = (isset($data['id'])) ? $data['id'] : null; $this->artist = (isset($data['artist'])) ? $data['artist'] : null; $this->title = (isset($data['title'])) ? $data['title'] : null; } public function getArrayCopy(){ return get_object_vars($this); } public function getInputFilter() { if(!$this->inputFilter){ $this->inputFilter = new InputFilter(); $factory = new InputFactory(); $this->inputFilter->add($factory->createInput(array( 'name'=>'id', 'required'=>true, 'filters'=>array( array('name'=>'Int'), ), ))); $this->inputFilter->add($factory->createInput(array( 'name'=>'artist', 'required'=>true, 'filters'=>array( array('name'=>'StripTags'), array('name'=>'StringTrim'), ), 'validators'=>array( array( 'name'=>'StringLength', 'options'=>array( 'encoding'=>'UTF-8', 'min'=>5, 'max'=>100, ), ), ), ))); $this->inputFilter->add($factory->createInput(array( 'name'=>'title', 'required'=>true, 'filters'=>array( array('name'=>'StripTags'), array('name'=>'StringTrim'), ), 'validators'=>array( array( 'name'=>'StringLength', 'options'=>array( 'encoding'=>'UTF-8', 'min'=>5, 'max'=>100, ), ), ), ))); } return $this->inputFilter; } public function setInputFilter(InputFilterInterface $inputFilter) { throw new \Exception('Not used'); } } ~~~ 代碼解釋： public function exchangeArray($data){} 數據轉換 public function getArrayCopy(){} 克隆對象內屬性 public function getInputFilter() {} 過濾器 ### 7.5.2 添加AlbumTable.php 此文件為數據庫操作網關，實現對數據庫的一系列操作；添加文件：`/module/Album/src/Album/Model/AlbumTable.php`，具體內容如下： ~~~ namespace Album\Model; use Zend\Db\TableGateway\TableGateway; use Zend\Db\ResultSet\ResultSet; use Zend\Db\Sql\Select; use Zend\Paginator\Adapter\DbSelect; use Zend\Paginator\Paginator; class AlbumTable { protected $tableGateway; public function __construct(TableGateway $tg) { $this->tableGateway = $tg; } public function fetchAll($paginated=false) { if($paginated){// 分頁 $select = new Select('album'); $rs = new ResultSet(); $rs->setArrayObjectPrototype(new Album()); $pageAdapter = new DbSelect($select,$this->tableGateway->getAdapter(),$rs); $paginator = new Paginator($pageAdapter); return $paginator; } $resultSet = $this->tableGateway->select(); return $resultSet; } public function getAlbum($id) { $id = (int) $id; $rowset = $this->tableGateway->select(array('id'=>$id)); $row = $rowset->current(); if(!$row){ throw new \Exception("Could not find row {$id}"); } return $row; } public function saveAlbum(Album $album) { $data = array( 'artist' =>$album->artist, 'title' =>$album->title ); $id = (int) $album->id; if($id == 0){ $this->tableGateway->insert($data); }else{ if($this->getAlbum($id)){ $this->tableGateway->update($data,array('id'=>$id)); }else{ throw new \Exception("Could not find row {$id}"); } } } public function deleteAlbum($id) { $this->tableGateway->delete(array('id'=>$id)); } } ~~~ 代碼解釋： public function fetchAll($paginated=false){} 獲取數據表中的所有記錄 public function getAlbum($id){} 獲取指定ID的記錄行 public function saveAlbum(Album $album){} 保存數據到數據庫 public function deleteAlbum($id){} 刪除指定ID的記錄行