Zend Framework 2 - Database connection

Question

Trying to wrap my head around the new concepts of Zend Framework 2.0.

I'm trying to connect to a database, and to get that connection in a controller or model. Nothing fancy, just the pure connection to run queries against.

So this is my current code:

//module.config.php
return array(
    'db' => array(
        'driver'         => 'Pdo',
        'dsn'            => 'mysql:dbname=DBNAME;host=HOSTNAME,
        'driver_options' => array(
            PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
        ),
        'username' => 'USERNAME',
        'password' => 'PASSWORD',
    ),
    'service_manager' => array(
        'factories' => array(
            'translator' => 'Zend\I18n\Translator\TranslatorServiceFactory',
            'Zend\Db\Adapter\Adapter' => 'Zend\Db\Adapter\AdapterServiceFactory',
        ),
    ),
);

What am I doing wrong?

mysql:dbname=DBNAME;host=HOSTNAME is missing ' at end ?

Svetoslav
– Svetoslav

2013-04-26 11:23:16 +00:00
Commented Apr 26, 2013 at 11:23 — Svetoslav
– Svetoslav, Commented Apr 26, 2013 at 11:23

user773440 · Accepted Answer · 2013-04-26 11:28:51Z

9

Create db.local.php in your ./config/autoload folder and add the following content

return array(
'db' => array(
    'driver'         => 'Pdo',
    'dsn'            => 'mysql:dbname=zenBlog;host=localhost',
    'username'       =>'root',
    'password'      =>'',
    'driver_options' => array(
        PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
    ),
),
'service_manager' => array(
    'aliases' => array(
'db' => 'Zend\Db\Adapter\Adapter',
),
),);

in your controller $this->getServiceLocator()->get('db'); to access to database.

answered Apr 26, 2013 at 11:28

user773440

8681 gold badge12 silver badges23 bronze badges

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

3 Comments

grubolsch Over a year ago

Thanks a lot, its working! Could you also tell me how to access this connection to a Model/any other class?

TMH Over a year ago

How would this be modified to contain 2 separate connections, would it be copy the db array and db entry in aliases and just rename them to e.g. db2?

user773440 Over a year ago

I haven't tried it ,but I think it can be done by copying and renaming aliases

Pawan Kumar · Accepted Answer · 2016-10-04 16:51:28Z

0

This is how my local.php in config\autoload\local.php looks like.

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

Now use this to create a database adapter:

$adapter = $this->getServiceLocator()->get('adapter');

Create a sql statetment and put in variable $sql. Now do this:

$statement = $adapter->createStatement($sql);
$result = $statement->execute();

Hope this helps.

edited Oct 4, 2016 at 16:51

answered Oct 10, 2014 at 7:43

Pawan Kumar

2,2702 gold badges17 silver badges10 bronze badges

1 Comment

Kzqai Over a year ago

Typo there, I think, should be 'dsn' not 'dbn'

Collectives™ on Stack Overflow

Zend Framework 2 - Database connection

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related