Yii v2 snippet guide II

Comparing #8 with #9

Revision #9 was created by rackycz on Sep 8, 2020, 10:07:38 AM.

Composer and PhpExcel

Content

[...]

**Creating models in Gii for remote MSSQL tables**
---
Once you have added the 2nd database (read above) go to the Model Generator in Gii. Change there the DB connection to whatever you named the connection in yii-config (in the example above it was "db2") and set tablename in format: SCHEMA.TBL_NAME. If MSSQL server has more databases, one of them is set to be the main DB. This will be used I think. I haven't succeeded to change the DB. DB can be set in the DSN string, but it had no effect in my case.

**Using composer-packages ~~(libraries)~~ - for example PhpExcel/PhpSpreadsheet in Yii 2** --- In previous chapters I showed how to use [PhpExcel in Yii 1](https://www.yiiframework.com/wiki/462/yii-for-beginners-2). Now I needed it also in Yii 2 and it was extremely easy.

Note: [PhpExcel](https://github.com/PHPOffice/PHPExcel) is deprecated and was replaced with [PhpSpreadsheet](https://github.com/PHPOffice/PhpSpreadsheet).

```
// 1) Command line:

[...]