I need to move 6 variables from a php page on one server to the database on a different domain & server. I own both domains and need to get the identical data into the second database which acts as a type of backup.
I have the following variables in a php page :
$eXcdpack
$eXfname
$eXsname
$eXemailaddress
$eXfullpass
$eXlogoname
These variables are added to the local domain's database as follows :
$con = mysql_connect($dbfName,$dbfUser,$dbfPass);
if (!$con)
die('Could not connect: ' . mysql_error());
mysql_select_db("tsadat_db1", $con);
$comboname = trim($eXfname . " " . $eXsname);
mysql_query("INSERT INTO PassList (CDnumber, CliName, CLIe1, CLIe2, CLIe3, CLIpass, Allow, SendDaily1, SendDaily2, SendDaily3, sendmsg1, sendmsg2, sendmsg3, LogoName) VALUES ('$eXcdpack', '$comboname', '$eXemailaddress', '', '', '$eXfullpass', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N', '$eXlogoname')");
mysql_close($con);
at this point, I need the data to be transferred to the backup server / domain and entered into it's database ( identical structure and table name, but different database name & password which are stored in the $dbf variables ). This needs to happen in the background as the first php page needs to continue with other code. This process must not interrupt the first php page if, for any reason, it cannot be completed ( for example, second server is down, international net connection down, etc )
The first php page then continues to process other code and display output to the user.
I imagine that this solution would require 2 parts :
1. Code to add to the first php page to send the data to the second server / domain.
2. PHP page on the second server / domain to receive the data passed to it and convert back to variables that can then be added to the second database using the same database code.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Linux