PHP Accessing ESS tables

[Jalz]

Hi Guys,

 

I'm planning on sharing some users data from a sql database within a FileMaker solution I'm building. All of my tables for this solution are in FM and I've been able to access the data on the layouts relatively easily with the API for PHP. However I now need to access this external sql db, if I create a ESS connection to the datasource and attach that dataset to a FM layout, can I use the api for php to query this data? I've not used ess, Im on FM Server 11.

 

I really don't want to do import/export, would be interested to see if anyone has achieved this?

 

Thanks 

[webko]

Haven't tried that....

 

But is there anything intrinsically wrong with directly querying the SQL db? That I have done - in-house admin using FM and ESS, website running off the SQL db...

[Jalz]

Yeah, I'm going to try and attempt querying the SQL database directly - need to install SQL Native client and try and get FileMakers version of PHP to communicate with it,  but as a fallback was kinda interested to see if someone had attempted to do it through ESS.