Hello people,

Im new to FM, however I have been working with PHP/MySQL for a long time building dynamic websites.

I have this new job where I need to build a site that uses data stored in a FileMaker DB.

After a lot of reading in the last few days, I got as far as buying a dreamweaver plugin called FMstudio, which seems to connect and fetch some data, however the "assistant-like" is slowing me down.

So my question is:

How can I run SQL queries from PHP against a FileMaker database?

(the php and the FM will both be running on the same machine btw)

If I could just run select/update/insert and the like queries into FileMaker I would be running in no time, but for now my wheels are spinning and Im not moving.

Any help would greatly greatly greatly appreciated.

iZeth

Hi there everyone,

any updates on this?

How can I run SQL queries from PHP against a FileMaker database?

I have already enabled the ODBC connector.

How can I make php or an sql browser talk to my FileMaker database and browse the tables?

I would greatly appreciate any help with this.

http://au.php.net/odbc and you're going to need to make sure that your customer / employer is running FMSA and not just FMS.

Anywho, have fun.

As a side note, the FM API is probably better to learn and will only take you a couple of days if you're proficient in SQL and PHP... but if you're desperate to go with ODBC...