Angesichts der Tatsache, dass es in China relativ wenige Tutorials für zendframework2 gibt, wurde ich dazu inspiriert, diesen technischen Artikel über das zf2-Framework zu schreiben, in der Hoffnung, den Bedürftigen zu helfen.
1. configautoloadglobal.php
<?php
//php中文网 www.php.cn
return array(
'db' => array(
'driver' => 'pdo',
'driver_options' => array(
\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
)
)
);Nach dem Login kopieren
2. configautoloadlocal.php
<?php
//php中文网 www.php.cn
return array(
'db' => array(
'dsn' => 'mysql:dbname=testdb;hostname=localhost',
'username' => 'root',
'password' => 'root',
'prefix' => 'phpcn_'
),
);Nach dem Login kopieren
3. ModulApplicationModule.php
public function getServiceConfig()
{
return array(
'factories'=>array(
'Application\Model\Db'=>function($sm){
$service=new Model\Db($sm);
return $service;
},
'Db\Adapter'=>function($sm){
$configs=$sm->get('Config');
$adapter = new \Zend\Db\Adapter\Adapter($configs['db']);
return $adapter;
},
'Db\Feature'=>function($sm){
$configs=$sm->get('Config');
$Feature=new \Application\Model\TableNamePrefixFeature($configs['db']['prefix']);
return $Feature;
},
'Db\Padapter'=>function($sm){
$Padapter=new \Zend\Paginator\Adapter\DbSelect($sm->get('Application\Model\Db')->select,$sm->get('Db\Adapter'));
return $Padapter;
},
'Db\Paginator'=>function($sm){
$Paginator=new \Zend\Paginator\Paginator($sm->get('Db\Padapter'));
return $Paginator;
},
),
'abstract_factories'=>array('Application\Services\CommonDbAbstractFactory')
);
}Nach dem Login kopieren
4. moduleApplicationviewpaginationtmpl.phtml
<?php if ($this->pageCount): ?>
<p class="pageX">
<?php if (isset($this->previous)): ?>
<a href="<?php echo $this->url().'?p='.$this->previous;?>">< 前一页</a> |
<?php else: ?>
<span>< 前一页</span> |
<?php endif; ?>
<?php foreach ($this->pagesInRange as $page): ?>
<?php if ($page != $this->current): ?>
<a href="<?php echo $this->url().'?p='.$page;?>"><?php echo $page;?></a> |
<?php else: ?>
<?php echo $page; ?> |
<?php endif; ?>
<?php endforeach; ?>
<?php if (isset($this->next)): ?>
<a href="<?php echo $this->url().'?p='.$this->next;?>">下一页 ></a>
<?php else: ?>
<span>下一页 ></span>
<?php endif; ?>
</p>
<?php endif; ?>Nach dem Login kopieren
5. moduleApplicationsrcApplicationServicesCommonDbAbstractFactory.php
<?php
//php中文网 www.php.cn
namespace Application\Services;
use Zend\ServiceManager\AbstractFactoryInterface;
use Zend\ServiceManager\ServiceLocatorInterface;
class CommonDbAbstractFactory implements AbstractFactoryInterface
{
public function canCreateServiceWithName(ServiceLocatorInterface $locator, $name, $requestedName)
{
$a=explode(':',$name);
if(!empty($a[0]) && $a[0]=='db'){
return true;
}
return false;
}
public function createServiceWithName(ServiceLocatorInterface $locator, $name, $requestedName)
{
$a=explode(':',$name);
return $locator->get('Application\Model\Db')->get($a[1]);
}
}Nach dem Login kopieren
6. moduleApplications rcApplicationModelDb. php
<?php
//php中文网 www.php.cn
namespace Application\Model;
use Zend\Db\TableGateway\TableGateway;
use Zend\ServiceManager\ServiceManager;
class Db
{
public function construct(ServiceManager $sm){
$this->sm=$sm;
}
public function get($tablename=null)
{
$configs=$this->sm->get('Config');
$adapter=$this->sm->get('Db\Adapter');
$dbFeature=$this->sm->get('Db\Feature');
$this->db=new TableGateway($tablename,$adapter,$dbFeature);
$this->select=$this->db->getSql()->select();
return $this;
}
public function fetch(){
return $this->db->selectWith($this->select);
}
public function getSql(){
return $this->select;
}
public function getTableGateway(){
return $this->db;
}
public function select($where = null){
return $this->db->select($where);
}
public function insert($set){
return $this->db->insert($set);
}
public function update($set, $where = null){
return $this->db->update($set,$where);
}
public function delete($where){
return $this->db->delete($where);
}
public function call($functionName,$args){
$this->select=call_user_func_array(array($this->select,$functionName),$args);
return $this;
}
}Nach dem Login kopieren
7. moduleApplicationsrcApplicationModelTableNamePrefixFeature.php
<?php
//php中文网 www.php.cn
namespace Application\Model;
use Zend\Db\TableGateway\Feature\AbstractFeature;
class TableNamePrefixFeature extends AbstractFeature
{
protected $prefix=null;
public function construct($prefix=null)
{
if(null!==$prefix) {
$this->setPrefix($prefix);
}
}
public function setPrefix($prefix)
{
$this->prefix=$prefix;
}
public function postInitialize()
{
if(null!==$this->prefix){
$this->tableGateway->getSql()->setTable($this->prefix.$this->tableGateway->table);
}
}
}Nach dem Login kopieren
8. moduleApplicationsrcApplicationControllerIndexController.php
$this->sm=$this->getServiceLocator();
$this->model=$this->sm->get('db:model');
$p=intval($this->getRequest()->getQuery('p',1));
$per_page=1;
$result=$this->model->where('id > 2')->order('id DESC')->limit($per_page)->offset(($p-1)*$per_page)->fetch()->toArray();
$paginator=$this->sm->get('Db\Paginator');
$paginator->setCurrentPageNumber($p);
$paginator->setItemCountPerPage($per_page);
\Zend\Debug\Debug::dump($result);
echo $this->sm->get('ViewRenderer')->paginationcontrol($paginator, 'Sliding', 'pagination/tmpl.phtml');
Nach dem Login kopieren
[Dieser Artikel wurde von „Ty80 Account“ geschrieben, veröffentlicht am 13. Juli 2017]
Das obige ist der detaillierte Inhalt vonzendframework2 Datenbank-Gateway und Paging-Vereinfachung. Für weitere Informationen folgen Sie bitte anderen verwandten Artikeln auf der PHP chinesischen Website!
