Rails中PHP应用程序的界面

问题描述:

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.

我有一个纯粹的,有效的PHP应用程序,它有自己特定而复杂的MSSQL数据库。 p>

在Rails中,我希望从没有任何SQL适配器的应用程序接收数据,因为直接从Rails运行查询太复杂了。 p>

例如,有 一个 getCustomersWithAccounts code>方法,它返回返回客户端数组的PHP数据库。 如何从我的Rails应用程序中获取此数组? p>

也许使用PHP-CLI并运行 / usr / bin / php5 get_customers.php code>,这将打印 JSON数组。 但是如何从Rails实现呢? p>

现在我使用共享的memcached密钥。 p> div>

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.