zendframework2 database gateway and paging simplification

In view of the fact that zendframework2 has relatively few tutorials in China, I felt inspired to write this technical article about the zf2 framework, hoping to help those in need.

1. config\autoload\global.php

<?php
//php中文网 www.php.cn
return array(
    &#39;db&#39; => array(
            &#39;driver&#39; => &#39;pdo&#39;,
            &#39;driver_options&#39; => array(
                \PDO::MYSQL_ATTR_INIT_COMMAND => &#39;SET NAMES \&#39;UTF8\&#39;&#39;
            )
    )
);

2. config\autoload\local.php

<?php
//php中文网 www.php.cn
return array(
    &#39;db&#39; => array(
        &#39;dsn&#39; => &#39;mysql:dbname=testdb;hostname=localhost&#39;,
        &#39;username&#39; => &#39;root&#39;,
        &#39;password&#39; => &#39;root&#39;,
        &#39;prefix&#39; => &#39;phpcn_&#39;
    ),
);

3. module \Application\Module.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')
    );
}

4. module\Application\view\pagination\tmpl.phtml

<?php if ($this->pageCount): ?>
    <p class="pageX">
        <?php if (isset($this->previous)): ?>
            <a href="<?php echo $this->url().&#39;?p=&#39;.$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().&#39;?p=&#39;.$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().&#39;?p=&#39;.$this->next;?>">下一页 ></a>
        <?php else: ?>
            <span>下一页 ></span>
        <?php endif; ?>
    </p>
<?php endif; ?>

5. module\Application\src\Application\Services \CommonDbAbstractFactory.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(&#39;:&#39;,$name);
        if(!empty($a[0]) && $a[0]==&#39;db&#39;){
            return true;
        }
        return false;
    }
     
    public function createServiceWithName(ServiceLocatorInterface $locator, $name, $requestedName)
    {
        $a=explode(&#39;:&#39;,$name);
        return $locator->get(&#39;Application\Model\Db&#39;)->get($a[1]);
    }
     
}

6. module\Application\src\Application\Model\Db.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(&#39;Config&#39;);
        $adapter=$this->sm->get(&#39;Db\Adapter&#39;);
        $dbFeature=$this->sm->get(&#39;Db\Feature&#39;);
        $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;
    }
}

7. module\Application\src\Application\Model \TableNamePrefixFeature.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);
        }
    }
}

8. module\Application\src\Application\Controller\IndexController.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');

[This article was published by "Ty80 account", 2017 July 13】

The above is the detailed content of zendframework2 database gateway and paging simplification. For more information, please follow other related articles on the PHP Chinese website!