I am building a website with multiple platforms of software to support the various functions that we need. And each of these platforms are built in PHP & MySQL.
I need to build a PHP Script that will take data from an HTML form and post it to each of the SQL databases that we use so that the same form doesn't have to be completed for each of them... This will be used to copy user-registration data from 1 platform to another.
HTML Form will collect Name, Email Address, Desired Password etc...
On submit, the form will action the PHP Script which will post the details entered into 3 databases.
All databases are on the SAME server but have different database names and different tables. For instance...
The script will need to take the data entered in the form's "Name" field and post it to the databases as follows:
database1 - table = users, field = name
database2 - table = user_data, field = first_name
database3 - table = users, field = username
I hope that makes sense.
Is there a way I can do this - All of the databases are on the same server and have the same username and password.