PHPackages                             airmoi/yii2-fmconnector - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. airmoi/yii2-fmconnector

ActiveYii2-extension[File & Storage](/categories/file-storage)

airmoi/yii2-fmconnector
=======================

FileMaker ODBC and PHP-API integration

2.5(5y ago)81.8k1[3 issues](https://github.com/airmoi/yii2-fmpconnector/issues)MITPHP

Since May 11Pushed 1y ago3 watchersCompare

[ Source](https://github.com/airmoi/yii2-fmpconnector)[ Packagist](https://packagist.org/packages/airmoi/yii2-fmconnector)[ RSS](/packages/airmoi-yii2-fmconnector/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (10)Dependencies (2)Versions (34)Used By (0)

Yii2 FileMaker Connector
========================

[](#yii2-filemaker-connector)

FileMaker ODBC connector and PHP-API integration

Installation
------------

[](#installation)

The preferred way to install this extension is through [composer](http://getcomposer.org/download/).

Either run

```
php composer.phar require --prefer-dist airmoi/yii2-fmconnector "*"

```

or add

```
"airmoi/yii2-fmconnector": "*"

```

to the require section of your `composer.json` file.

Usage
-----

[](#usage)

1. ODBC connection

Once plugin installed using composer, and ODBC driver configured on the server, Create/Edit your db config file using this lines

```
return [
    'class' => 'airmoi\yii2fmconnector\db\Connection',
    'dsn' => 'fmp:',
    'username' => '',
    'password' => '',
    'charset' => 'utf8',
    'pdoClass' => 'airmoi\yii2fmconnector\db\PDO',
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 86400,
    //'enableQueryCache' => true,
    //'queryCacheDuration' => 1000,
    'schemaMap' => ['fmp' => [
            'class' => 'airmoi\yii2fmconnector\db\Schema',
            /*
             * Customize this option to ignore specific fields (like global/utils fields) which you don't want to get access
             * Ignore theses fields improve query performences
             */
            'ignoreFields' => [
                'FieldType' => ['global%'],
                'FieldClass' => ['Summary'],
                'FieldName' => ['zkk_%',
                    'zgi_%',
                    'zg_%',
                    'zz_%',
                    'zzz_%',
                    'zlg_%',
                    'z_foundCount_cU',
                    'z_listOf_eval_cU',
                ]
            ],
            /*
             * Regexp pattern used to detect if a field is a primary key
             * this pattern while be used against fields names
             */
            'primaryKeyPattern' => '/^zkp(_)?/',
            /*
             * pattern used to detect if a field is a foreign key
             * this pattern while be used against fields names
             * Second match of the pattern must return the foreign key trigram (XXX)
             */
            'foreignKeyPattern' => '/^(zkf|zkp)_([^_]*).*/', //pattern used to detect if a field is a foreign key
        ]
    ]
];
```

1. PHP-API

You may also configure a connection using PHP-API this way

```
[
    'class' => 'airmoi\yii2fmconnector\api\Connection',
    'dsn' => 'fmpapi:host=your_host_ip;dbname=your_db_name',
    'username' => 'db username',
    'password' => 'db passwod',
    'charset' => 'utf8',
    //'schemaCache' => 'cache',
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 3600,
    'options' => [ //Specific connector options
        'dateFormat' => 'd/m/Y',
        'emptyAsNull' => true,
    ],
    'schemaMap' => [
        'fmpapi' => [
            'class' => 'airmoi\yii2fmconnector\api\Schema',
            //'layoutFiltterPattern' =>  '/^PHP_/' //Regex pattern to filter layout's list
        ]
    ]
]

```

1. Customize gii

Add these lines to gii module config to enhance model and CRUD generators

```
'generators' => [
        'model' => [
        'class' => 'yii\gii\generators\model\Generator',
        'templates' => [
            'FileMakerAPI' => '@app/vendor/airmoi/yii2-fmconnector/gii/api/templates/',
            'FileMakerODBC' => '@app/vendor/airmoi/yii2-fmconnector/gii/odbc/templates/',
        ]
    ],
     'crud' => [ // generator name
        'class' => 'airmoi\yii2fmconnector\gii\api\crud\Generator', // generator class
        /*'templates' => [ //setting for out templates
            'myCrud' => '@app/myTemplates/crud/default', // template name => path to template
        ]*/
    ]
],
```

###  Health Score

37

—

LowBetter than 83% of packages

Maintenance25

Infrequent updates — may be unmaintained

Popularity25

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity74

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~69 days

Recently: every ~53 days

Total

28

Last Release

2149d ago

Major Versions

1.0.4-beta → 2.0.0-alpha2015-12-16

### Community

Maintainers

![](https://www.gravatar.com/avatar/931b97c20b43bcc827fdd420fda3cca79f6758a6768e2e4ab54d6ff86922d358?d=identicon)[airmoi](/maintainers/airmoi)

---

Top Contributors

[![airmoi](https://avatars.githubusercontent.com/u/2822333?v=4)](https://github.com/airmoi "airmoi (247 commits)")

---

Tags

yii2extensionFileMakerodbcFileMaker API-PHP

### Embed Badge

![Health badge](/badges/airmoi-yii2-fmconnector/health.svg)

```
[![Health](https://phpackages.com/badges/airmoi-yii2-fmconnector/health.svg)](https://phpackages.com/packages/airmoi-yii2-fmconnector)
```

###  Alternatives

[fedemotta/yii2-aws-sdk

This extension provides the AWS SDK integration for the Yii2 framework

15430.4k2](/packages/fedemotta-yii2-aws-sdk)[liyunfang/yii2-upload-behavior

Upload behavior for Yii 2

161.7k](/packages/liyunfang-yii2-upload-behavior)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)