Database could not connect to Zend Framework

Question

I'm sorry I'm completely new to Zend Framework 2 with some tutorials I'm trying to connect my DB connection as follows,

Created a file in xampp\htdocs\articlemanager\application\configs\autoload\global.php

Inserted the following Zend DB connection code to global.php

<?php
return array(
    'service_manager' => array(
        'factories' => array(
            'Zend\Db\Adapter\Adapter' => 'Zend\Db\Adapter\AdapterServiceFactory',
        ),
        'aliases' => array(
            'db' => 'Zend\Db\Adapter\Adapter',
        ),
    ),
    'db' => array(
        'driver'    => 'PDO_MYSQL',
        'dsn'       => 'mysql:dbname=articlemanager;host=localhost',
        'username'  => 'root',
        'password'  => '',
        'driver_options' => array(
                        PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
         ),
    ),
);

and In the Indexcontroller (\xampp\htdocs\articlemanager\application\controllers\IndexController.php) tested adding $this->db = $this->getServiceLocator()->get('db'); in the indexAction as follows

public function indexAction()
    {
        $this->db = $this->getServiceLocator()->get('db');
    }

When I refresh page it display as

An error occurred

Application error

Can I know what I missed here?

Also I would like to know My Zend Library is in the \xampp\php\Zend and My global.php file in the xampp\htdocs\articlemanager\application\configs\autoload\global.php is it OK?

Erik · Accepted Answer · 2014-04-02 01:48:56Z

1

Why are you using an Alias on 'Db' ?

Try this, your driver name is different from mine.

In addition, please move your username and password to local.php.. so they do not persist in Git projects

global.php

<?php
return array(
    'db' => array(
        'driver'    => 'Pdo',
        'dsn'       => 'mysql:dbname=articlemanager;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',
        ),
    ),
);

local.php example

<?php
return array(
    'db' => array(
        'username' => 'DB_USERNAME',
        'password' => 'DB_PASSWORD',
     ),
);

answered Apr 2, 2014 at 1:48

Erik

3,2385 gold badges41 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

FR STAR Over a year ago

Thanks, Erik I'll try this and let you know. (FYI: I won't check immediately but as soon I do I'll inform you)

sab0t · Accepted Answer · 2013-09-13 19:57:45Z

0

database connection problems can be a number of different issues that are not necessarily obvious from looking at the creds / db config info.

have you taken a look at any logs? my application has several different logs setup - PHP error, access log, mysql error log, etc. - depending on your application, you may not have this many as discretely defined, but checking any logs you do have will give you a whole lot more information than just "An error has occurred" :)

answered Sep 13, 2013 at 19:57

sab0t

1372 silver badges8 bronze badges

3 Comments

FR STAR Over a year ago

Thank you for this I'll look into that but could you please confirm in my code factories setting path is correct as I mentioned above?

FR STAR Over a year ago

because when I tried to connect via application.ini it's working fine. I really want to know what mistake I'm doing here?

FR STAR Over a year ago

I checked the log files you mentioned but only the access.log has some data for accessing that URL other than that there is no data in php error log or mysql error log.

Collectives™ on Stack Overflow

Database could not connect to Zend Framework

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related