I have a external MySQL database that I need to query/get info with a Appery project.
I found some php restful frameworks like Slim, Recess and Guzzle.
Have anyone used any of them ?
Which would you recommend for better integration with Appery.io ?
Recess - http://www.recessframework.org/
Slim - http://www.slimframework.com
Guzzle- http://docs.guzzlephp.org/en/latest/
Hello,
We can't recommend any specific framework. Appery.io needs working REST services. Maybe someone tried them and could advice...
Hi Katya
Thanks for the reply
But these frameworks can implement REST http service for MySQL databases with PHP, right ?
Cheers!
Hello! Are you sure you need some framework for this purpose? We would recommend you to implement it with php only. First you have to decide what data type you're going to send and return.
Json for data type return. Ok, indeed just php is easier...will search for some good examples. Do you guys know any good one ?By the way the php script would be located at my server ? Or can I store it inside my appery project ?
If it were stored in my web server I will use http appery service call, using my php script url ?
What I did was the following:
I have a mysql database that has the data such as customers, articles, etc.
I used php (on your own webserver of course) to output the data from my mysql database into xml format (or JSON format) and then you can use Appery service to catch the xml (or JSON) output. After that you could link the response to your pages.
Good luck!
Hi Hnto, thanks for the reply. Did you called the php script from Appery service, called the url .php ? And then parsed the json as response ? Do you stored the php script outside Appery ?
Thanks
He Lorenco,
Yes I did. The php file is on my webserver and I call that file within Appery with the service addition. As output I issue JSON or XML.
Good luck.