Difference between #95 and #96 of
Yii v2 snippet guide III

Revision #96 has been created by rackycz on Aug 14, 2022, 7:35:24 PM with the memo:

Microsoft Access MDB
« previous (#95) next (#97) »

Changes

Title unchanged

Yii v2 snippet guide III

Category unchanged

Tutorials

Yii version unchanged

2.0

Tags unchanged

tutorial,yii2,beginer

Content changed

[...]
composer require codeception/module-webdriver --dev
```

PS: There is also this file [ChromeDriver](https://chromedriver.chromium.org/downloads) but I am not really sure if it is an alternative to "codeception/module-webdriver" or when to use it. I havent studied it yet.

If you want to see the code coverage, do what is described in the documentation (link above). Plus make sure that your PHP contains [xDebug](https://gist.github.com/odan/1abe76d373a9cbb15bed)! And mind the difference in settings of xDebug2 and xDebug3! If xDebug is missing, you will receive error "No code coverage driver available".
 
 
**Microsoft Access MDB**
 
---
 
Under Linux I havent suceeded, but when I install a web server on Windows (for example XAMPP Server) I am able to install "Microsoft Access Database Engine 2016 Redistributable" and use *.mdb file.
 
 
So first of all you should install the web server with PHP and you should know wheather you are installing 64 or 32bit versions. Probably 64. Then go to page [Microsoft Access Database Engine 2016 Redistributable](https://www.microsoft.com/en-us/download/details.aspx?id=54920) (or find newer is available) and install correspoinging package (32 vs 64bit)
 
 
Then you will be able to use following DSN string in DB connection:
 
 
```
 
$file = "C:\\xampp\\htdocs\\Database1.mdb";
 
 
// ...
 
 
'dsn' => "odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=$file;Uid=;Pwd=;",
 
'username' => '',
 
'password' => '',
 
'charset' => 'utf8',
 
 
// And use this to query a table:
 
$data = Yii::$app->db->createCommand("SELECT * FROM TableX")->queryAll();
 
var_dump($data);
 
```
 
8 0
4 followers
Viewed: 189 578 times
Version: 2.0
Category: Tutorials
Tags: beginer, tutorial, yii2
Written by: rackycz
Last updated by: rackycz
Created on: Jan 21, 2021
Last updated: a year ago
Update Article
Revert to #95 | Revert to #96

Revisions

View all history