zendframework2 database gateway and paging simplification-PHP Tutorial-php.cn

zendframework2 database gateway and paging simplification

PHP中文网

Release： 2023-03-13 19:30:02

Original

1761 people have browsed it

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中文网 m.sbmmt.com
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;
            )
    )
);

Copy after login

2. config\autoload\local.php

<?php
//php中文网 m.sbmmt.com
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;
    ),
);

Copy after login

3. module \Application\Module.php

public function getServiceConfig()
{
    return array(
                  &#39;factories&#39;=>array(
                            &#39;Application\Model\Db&#39;=>function($sm){
                                                        $service=new Model\Db($sm);
                                                        return $service;
                            },
                            &#39;Db\Adapter&#39;=>function($sm){
                                                        $configs=$sm->get(&#39;Config&#39;);
                                                        $adapter = new \Zend\Db\Adapter\Adapter($configs[&#39;db&#39;]);
                                                        return $adapter;
                            },
                            &#39;Db\Feature&#39;=>function($sm){
                                                        $configs=$sm->get(&#39;Config&#39;);
                                                        $Feature=new \Application\Model\TableNamePrefixFeature($configs[&#39;db&#39;][&#39;prefix&#39;]);
                                                        return $Feature;
                            },
                            &#39;Db\Padapter&#39;=>function($sm){
                                                        $Padapter=new \Zend\Paginator\Adapter\DbSelect($sm->get(&#39;Application\Model\Db&#39;)->select,$sm->get(&#39;Db\Adapter&#39;));
                                                        return $Padapter;
                            },
                            &#39;Db\Paginator&#39;=>function($sm){
                                                        $Paginator=new \Zend\Paginator\Paginator($sm->get(&#39;Db\Padapter&#39;));
                                                        return $Paginator;
                            },
                ),
                  &#39;abstract_factories&#39;=>array(&#39;Application\Services\CommonDbAbstractFactory&#39;)
    );
}

Copy after login

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; ?>

Copy after login

5. module\Application\src\Application\Services \CommonDbAbstractFactory.php

<?php
//php中文网 m.sbmmt.com
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]);
    }
     
}

Copy after login

6. module\Application\src\Application\Model\Db.php

<?php
//php中文网 m.sbmmt.com
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;
    }
}

Copy after login

7. module\Application\src\Application\Model \TableNamePrefixFeature.php

<?php
//php中文网 m.sbmmt.com
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);
        }
    }
}

Copy after login

8. module\Application\src\Application\Controller\IndexController.php

$this->sm=$this->getServiceLocator();
$this->model=$this->sm->get(&#39;db:model&#39;);
$p=intval($this->getRequest()->getQuery(&#39;p&#39;,1));
$per_page=1;
$result=$this->model->where(&#39;id > 2&#39;)->order(&#39;id DESC&#39;)->limit($per_page)->offset(($p-1)*$per_page)->fetch()->toArray();
$paginator=$this->sm->get(&#39;Db\Paginator&#39;);
$paginator->setCurrentPageNumber($p);
$paginator->setItemCountPerPage($per_page);
\Zend\Debug\Debug::dump($result);
echo $this->sm->get(&#39;ViewRenderer&#39;)->paginationcontrol($paginator, &#39;Sliding&#39;, &#39;pagination/tmpl.phtml&#39;);

Copy after login

[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!