albumTable.php
<?php namespace Album\Model; use Zend\Db\TableGateway\AbstractTableGateway; use Zend\Db\Adapter\Adapter; use Zend\Db\ResultSet\ResultSet; class AlbumTable extends AbstractTableGateway { protected $table = 'aii_user'; public function __construct(Adapter $adapter) { $this->adapter = $adapter; $this->resultSetPrototype = new ResultSet(); $this->resultSetPrototype->setArrayObjectPrototype(new Album()); $this->initialize(); } public function fetchAll() { $resultSet = $this->select(); return $resultSet; } public function getAlbum($id) { $id = (int) $id; $rowset = $this->select(array('id' => $id)); $row = $rowset->current(); if (!$row) { throw new \Exception("Could not find row $id"); } return $row; } public function checkReg($aii_username) { $aii_username = $aii_username; $rowset = $this->select(array('aii_username' => $aii_username)); $row = $rowset->current(); if ($row) { throw new \Exception("this username already reg"); } return true; } //检查该用户名是否被注册 public function checkLogin($aii_username,$aii_password) { $aii_username = $aii_username; $aii_password=$aii_password; $rowset = $this->select(array('aii_username' => $aii_username,'aii_password'=>$aii_password)); $row = $rowset->current(); if (!$row) { throw new \Exception("the username or password is wrong"); } return true; } //验证登录 public function saveAlbum(Album $album) { $data = array( 'aii_username' => $album->aii_username, 'aii_password' => $album->aii_password, ); $this->checkReg($data['aii_username']); $id = (int)$album->id; if ($id == 0) { $this->insert($data); } else { if ($this->getAlbum($id)) { $this->update($data, array('id' => $id)); } else { throw new \Exception('Form id does not exist'); } } } public function deleteAlbum($id) { $this->delete(array('id' => $id)); } }