I wanna to use mssql in zf3, how to config in global.php if I wanna to use the tablegateway as tutorial

zend-db

#1

Generally, I use mysql as database, and config as follow in the global.php:

return [
    'db' => [
        'driver' => 'Pdo',
        'dsn'    => 'mysql:dbname=dbname;host=localhost;charset=utf8',
    ],
];

and use the tablegateway according the official tutorial.

Recently I need to use mysql as database, I am just familiar to the tablegateway pattern the same as the official tutorial way. How could I config in the global.php and local.php?

Besides, if the configuration for the mssql is done, the usage of the tablegateway is the same? select, insert, update, delete, etc. as well as the paginator…

I found this page https://github.com/zendframework/zendframework/issues/3142 mentioned about this, I will try it out.


#2

In 2013, I used MSSQL in a project and it works fine with ‘Sqlsrv’ driver. I blogged about it about setting it up at https://samsonasik.wordpress.com/2013/03/08/zend-framework-2-working-with-sql-server/ , while I’m not sure if it is still relevant right now