Rails中PHP应用程序的界面

Question

I've got a pure, working, PHP application with its own specific and complicated MSSQL database.

In Rails, I want to receive data from this app without any SQL adapters, because it's too complicated to run queries directly from Rails.

For example, there is a getCustomersWithAccounts method it PHP database that returns array of clients. How can I get this array from my Rails app?

Maybe use the PHP-CLI and run /usr/bin/php5 get_customers.php, which will print the JSON array. But how to implement this from Rails?

Now I use shared memcached keys.

Answer 1

Your solution of using shared memcached keys is one way to go to transport data from one to the other.

Another solution that might give you some more flexibility would be having the Rails app query the PHP app over HTTP. Basically you would be building a webservice API for yourself, you could return JSON or XML, or whatever format is most useful to the Rails app.