FMPDO is a php class that is designed to replace FileMaker.php when converting legacy FileMaker web applications to use a SQL database. The tables in the legacy solution can be converted to SQL all at once, or individually, as required.

• FMPDO methods calls and responses are the same format as FileMaker.php

• Convert all or some of your tables to SQL

• Choose any major SQL database, easily change databases at a later date (thanks to PDO)

• MySQL and SQLite are already in most PHP builds

FMPDO is free for commercial and non-commercial use, licensed under the business-friendly standard MIT license.

• index.php contains sample calls to supported methods, more formal docs are on the way

• Put the code in a place where your browser can load it (existing web root or create a host)
• Import sample_data/fmpdo.sql into your favorite SQL database
• Edit config.php with your connection settings
• Load index.php with your browser

• Create SQL tables that mirror existing FMP tables
• If you intend to use FileMaker External SQL Sources, ensure that the SQL columns are in the same position as the FileMaker fields
• Add or change the database initialization call

// this is a prototypical FileMaker.php instantiation
$databaseName = 'myDB';
$server = '127.0.0.1';
$userName = 'uname';
$passWord = 'pword';

$fm = new FileMaker($databaseName,$server,$userName,$passWord);

// this is a prototypical FMPDO instantiation
$db_config = array(
    'driver' => 'mysql',
    'host' => '127.0.0.1',
    'port' => '3306',
    'database' => 'fmpdo',
    'user' => 'root',
    'password' => 'root'
);

$fmpdo = new FMPDO($db_config);

// if you are changing all table to SQL at once, you can do this:
$fm = new FMPDO($db_config);

Locate commands that you wish to convert to SQL:

$find = $fm->newFindCommand($fmpLayout); // new find command for FileMaker
$find = $fmpdo->newFindCommand($sqlTable) // a new FmpdoCommandFind object

// subsequent method calls to $find, such as $find->setField() and execute() do not require modification

• Server side scripts not supported
• Relate sets from web layouts with portals need to be broken out into multiple calls (but the resulting Result object behaves the same as the FileMaker "relatedSet".
• Repeating fields not supported (yes Virginia, people have used repeating fields in FileMaker Web Publishing)

• This is alphaware that is incomplete and has known security issues, see https://github.com/rjakes/FMPDO/issues before using in production.