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.