Untitled

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>

    <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
    <title>Application Form</title>

    <link rel="stylesheet" type="text/css" href="style.css">

</head>
<body>
<?php
    $hostname = "localhost";

    $refno = $_REQUEST['refno'];

    $ss_username = "kuokfoun_ss";
    $ss_password = "P455word!!";
    $ss_dbname = "kuokfoun_ss";

    $oa_username = "kuokfoun_oa";
    $oa_password = "P455word!@#\$%";
    $oa_dbname = "kuokfoun_oa";

echo "ref_no = ".$refno."<BR>";

    //connection to the SS database
    $con=mysqli_connect($hostname,$oa_username,$oa_password,$oa_dbname);
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }

    //execute the SQL query and return records
    $oa_query = mysqli_query($con,"SELECT id FROM tbl_applicant_details WHERE application_reference_no='".$refno."'");
//    $oa_query = mysqli_query($con,"SHOW COLUMNS FROM sys_config");


//-----------
//To build the UPDATE statement based on the columns available in the table
    function build_UPDATEquery($connection, $dbsrc, $dbdest, $table, $idfield, $idvalue){
        $sqlstr="";
        $colquery = mysqli_query($connection,"SHOW COLUMNS FROM ".$table);
        while ($colfield = mysqli_fetch_array($colquery)){
            if ($colfield["Field"]<>"id"){$sqlstr=$sqlstr.$dbdest.'.`'.$table.'`.'.$colfield["Field"]."=".$dbsrc.'.`'.$table.'`.'.$colfield["Field"].", ";}
        }
        $sqlstr = rtrim ($sqlstr,", ")." ";
        $sqlstr = "UPDATE ".$dbsrc.".`".$table."`, ".$dbdest.".`".$table."` SET ".$sqlstr." WHERE ".$dbdest.".`".$table."`.".$idfield."=".$idvalue;
        return $sqlstr;
    }


    //fetch tha data from the database
    while($oa_id = mysqli_fetch_array($oa_query)){
        echo "Synching ID... ".$oa_id["id"]."<br>";
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_applicant_details", "id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_course_details", "tbl_applicant_details_id", $oa_id["id"]));
echo build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_guardian_info", "tbl_applicant_details_id", $oa_id["id"])."<br>";
          mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_guardian_info", "tbl_applicant_details_id", $oa_id["id"]));
echo "Affected Rows".mysqli_affected_rows($con)."<BR>";
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_sibling_details", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_sibling_particulars", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_education", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_exam_results", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_cocurricular", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_prizes_awards", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_financial_assistance_kf", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_financial_assistance_others", "tbl_applicant_details_id", $oa_id["id"]));
//        mysqli_query($con, build_UPDATEquery($con, $oa_dbname, $ss_dbname, "tbl_referees", "tbl_applicant_details_id", $oa_id["id"]));
        echo "Sync Complete for ID ".$oa_id["id"]."<br>";
    }


$con->close();
?>

</body>

</html>