Running SQL queries from PHP against FM

[iZeth]

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

[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.

[Genx]

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...