how to connect and query a MySql database

[Matt Christenson]

I am really trying to figure out the best way to connect to a MySql database and run query's. I am trying to set up the REST service, but I just cannot get it set up properly. I have tried to look for documentation on how to set this up, but I just cannot find any useful information. Any suggestions?
Thank you!

[Alena Prykhodko]

Hello Matt!

You can connect to any data source available on the Internet as long as it’s exposed via REST API.
We recommend to use RestXpress http://www.exadel.com/restxpress

[Paul Birch]

So does that mean that in order to use appery.io with an external mySQL database, we need to license and install RestXpress @ $2,500/year ?

[maxkatz]

That's one option..you do get 30 days trial. You can also use any other tool that will expose your database via REST APIs.

[Corinne]

Im using Apperys rest services to connect to php scripts on my server. You cant connect directly with mysql.

I wont run JS on my server so php is a better option.

Works perfectly!!

[Koning Voetbal]

Hi Corinne,

Can you give me a small example how to use Appery's Rest Service to connect to php?

I have a mysql database on our own server with a login system.

I want to build an app to connect to this database (a website version is already running for a few years).

As I understand you connect from Appery to a php file in which you goiive all the database query's. How to get this results to appery?

Any help would be appriciated!

Kind regards,

Arie

[Kateryna Grynko]

Hi Arie,

Answered here:
https://getsatisfaction.com/apperyio/...