Java Client Needs Database Acces Over Internet

[etherkye]

More problems XD

I need my java program to get data from a MySQL database stored on a remote server.

Now i know alot of php and can easily write a php page which can process a POST request, but i have no idea how make it respond.

What i will be needing to do it first to send a single column of a table. The java program will then get details relating to those options, and then start processing whole tables.

What i need to know, is how to get the php and java working so that it is easy to get and process the data row by row.

Can anyone please provide me with either the code needed for both ends, or a link to somewhere where it is explained.

[Steve11235]

First, check to see if MySQL provides SSL encrypted database connections. If so, that will protect you as you access the database. You will also have to tunnel through the firewall to the server, which is easy if the firewall admin agrees to allow it.

As far as PHP and Java, this is a good reason to use JSP. Just kidding. Sorta. Look at this Wikipedia link...

[etherkye]

Thanks. i'll look into them.