编辑:类Zend\Db\Adapter\Adapter未找到

Question

我有一个简单的form，在提交重定向到processAction的AuthController之后，在这个action中，我想创建一个简单的table bar。

编辑：

关于Zend framerwork更新，我在下面的代码中做了一些修改

AuthController.php

<?php

namespace Blog\Controller;
use Zend\Mvc\Controller\AbstractActionController;
use Zend\View\Model\ViewModel;
use Zend\Debug\Debug;
use Blog\Form\LoginForm;
use Zend\Authentication\AuthenticationService;
use Zend\Db\Adapter\AdapterInterface;
use Zend\Db\Sql\Sql;
use Zend\Db\Sql\Ddl;
use Zend\Db\Sql\Ddl\Column;
use Zend\Db\Sql\Insert;
use Zend\Authentication\Adapter\DbTable as DbTableAuthAdapter;

class AuthController extends AbstractActionController
{    
    protected $adapter;
    public function getAdapter()
    {
        if (!$this->adapter) {
            $sm = $this->getServiceLocator();
            $this->adapter = $sm->get('Zend\Db\Adapter\Adapter');
        }
        return $this->adapter;
    }

    public function indexAction()
    {
        return new ViewModel();
    }

    public function processAction()
    {

       $DB = new \Zend\Db\Adapter\Adapter(array(
        'driver' => 'Pdo',
        'database' => 'blog',
        'username' => 'root',
        'password' => 'mysql'
       ));


        $this->adapter = $this->getAdapter();
        $sql = new Sql($this->adapter);
        $table = new Ddl\CreateTable('bar');
        $table->addColumn(new Column\Integer('id'));
        $table->addColumn(new Column\Varchar('name', 255));
        $table->setTable('bar'); 

        $results = $this->adapter->query($sql->getSqlStringForSqlObject($table),  $this->adapter ::QUERY_MODE_EXECUTE);
        return new ViewModel();
    }
}

global.php:

return array(
'db' => array(
    'driver'         => 'Pdo',
    'dsn'            => 'mysql:dbname=blog;host=localhost',
    'driver_options' => array(
        PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
    ),
),
'service_manager' => array(
    'factories' => array(
        'Zend\Db\Adapter\Adapter'
        => 'Zend\Db\Adapter\AdapterServiceFactory',
     ),
  ),
);

Module.php

  <?php
  namespace Blog;

  use Zend\ModuleManager\Feature\AutoloaderProviderInterface;
  use Zend\ModuleManager\Feature\ConfigProviderInterface;

 class Module implements  AutoloaderProviderInterface,ConfigProviderInterface
  {

  public function getAutoloaderConfig()
  {
    return array(
        'Zend\Loader\StandardAutoloader' => array(
            'namespaces' => array(
                __NAMESPACE__ => __DIR__ . '/src/' . __NAMESPACE__,
            ),
        ),
    );
}


public function getConfig()
{
    return include __DIR__ . '/config/module.config.php';
}

public function getServiceConfig()
{
    return array(
        'factories' =>array( 
            'Zend\Db\Adapter\Adapter' => function ($sm) {
                 $config = $sm->get('Config');
                 return new \Zend\Db\Adapter\Adapter($config['db']);

         }
       )
    );
  }
}

Problem:(Updated)

table bar未创建，并显示错误，如

致命错误:在第110行的/var/www/zend2/module/Blog/src/Blog/Controller/AuthController.php中找不到‘Blog\Controller\Zend\Db\Adapter’类

如果我打印

echo $sql->getSqlStringForSqlObject($table);

查询打印如下所示

创建表bar ( id整数NULL，name VARCHAR(255) NULL )

但是桌子不在那里。

错误发生在下面的代码行中，因为它无法识别adapter：

 $results = $this->adapter->query($sql->getSqlStringForSqlObject($table),  $this->adapter ::QUERY_MODE_EXECUTE);

但以这种方式工作：

$results = $this->adapter->query($sql->getSqlStringForSqlObject($table),  $DB ::QUERY_MODE_EXECUTE);

我正在使用Zend 2.4

Answer 1

对于ZF2中的初学者来说，如果没有正确实例化类Zend\Db\Adapter\Adapter，query execute就无法工作。

我纠正了

 $DB = new \Zend\Db\Adapter\Adapter(array(
    'driver' => 'Pdo',
    'database' => 'blog',
    'username' => 'root',
    'password' => 'mysql'
   ));

同样，在代码的下面一行：

$results = $this->adapter->query($sql->getSqlStringForSqlObject($table),  $DB ::QUERY_MODE_EXECUTE);

参考文献致命错误: Zend框架2中找不到类

注意：，我仍然不明白为什么$this->adapter = $this->getAdapter();不工作而不是$DB.Any提示会受到赞赏。

Answer 2

我认为您正在尝试访问不存在的服务。您可以尝试创建一个服务工厂：

config.php

<?php
return [
    'db' => [
        'driver' => 'Pdo',
        'database' => 'blog',
        'username' => 'root',
        'password' => 'mysql'
    ]
];

Module.php

<?php
class Module 
{
    public function getServiceConfig()
    {
        return [
            'factories' => [
                'Zend\Db\Adapter\Adapter' =>  => function ($sm) {
                     $config = $sm->get('Config');
                     return new \Zend\Db\Adapter\Adapter($config['db']);

                },
            ],
        ];
    }
}

然后，您可以使用服务管理器访问服务：

AuthController.php

class AuthController extends AbstractActionController 
{
    public function getAdapter()
    {
       if (!$this->adapter) {
          $sm = $this->getServiceLocator();
          $this->adapter = $sm->get('Zend\Db\Adapter\Adapter');
       }
       return $this->adapter;
    }

    public function processAction()
    {
        $this->adapter = $this->getAdapter();
        $sql = new Sql($this->adapter);

        // other stuff here
    }
}

您可以找到更多的示例这里和这里。