Java bridge between PHP and Database

Question

First, I will present what it is doing my web-application : The subject of this web-application is different distributed databases and distributed data sistems with a specific type of information. Until now I programed using PHP, JavaScript and JQuery-ui. For databases I used MySQL and PostgreSQL and I thinking to use and Oracle. On short way on my web application the user firstly have to register. If he is accepted by Admin then he have the possiblities :

Connect to HIS database (MySQL, Oracle, Access, PostgreSQL)
Run queries between two, different or not, databases
To connect to his database the user enter information like : host, user, password and name of database. At next step he can see the tables from database. If he select one line he will be able to Update, Create and Delete the content from the selected table.
On this section the user can look for similarities between the two databases (with key words or structures of tables) : one that belongs to him and another one that belongs to the Admin.

I use WampServer, version 2.1 with Apache/2.2.17 and PHP/5.3.5 and I want to do a bridge who will be responsable with the connection to the databases and in which I will comunicate with different databases. The informations from interface will be sent as MySQL queries and in the bridge I will adapt that queries for each type of database.

Can someone to help me ? Soon as possible.

Thank you !

Simon

Mike Thomsen · Accepted Answer · 2011-05-02 16:13:42Z

1

The informations from interface will be sent as MySQL queries and in the bridge I will adapt that queries for each type of database.

This is a very bad idea for two serious reasons:

To implement it, you'd have to write your own SQL parser.
Each major database implements its own dialect of SQL, which means you'll have to know how to translate between their specific syntax and command sets.

answered May 2, 2011 at 16:13

Mike Thomsen

37.7k11 gold badges63 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Simon Zafiu Over a year ago

OK. Thank you for tips. Do you have any idea how should I implement that side of bridge (between PHP and DB) ?

Collectives™ on Stack Overflow

Java bridge between PHP and Database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related