insert data in two different databases using ajax

Question

Does anyone knows how to insert data in two different databases at the same time using ajax?
In add form there is multiple data that needs to be filled but they are splited in two different databases, so when I press add button it should save data in both databases.

Answer 1

Two different databases or two different tables in database?

Answer 2

two different databases

Answer 3

Eric Kazhus

You can make two different connection for each database.

Answer 4

Already have done that! I have 2 insert into functions too that should save data in one database and other data in second database, but I think problem is in ajax/javascript code part that I have. thought if there is some kind of example which to follow because couldnt find anything useful in internet.

Answer 5

Eric Kazhus

Check these links and tell if you face any problem

https://codingstatus.com/how-to-insert-data-using-ajax-in-php/

https://steemit.com/utopian-io/@sogata/how-to-insert-data-to-mysql-from-php-using-jquery-ajax

Answer 6

We can do this without ajax also

In jdbc i will create 2 methods

Method 1 is working with oracle

Method 2 is working with mysql

Passing data will be depend upon tablename and fields available in database

Answer 7

Method 2 is working with mysql

Can You provide an example please?