<?php
ini_set('include_path','/var/www/sekret:.');
include_once("eregis.inc");

header("content-type: text/html; charset=UTF-8");
# configuration for database
$_config['database']['hostname'] = $DBHOST;
$_config['database']['username'] = $DBUSER_EREGIS;
$_config['database']['password'] = $DBPASS_EREGIS;
$_config['database']['database'] = $DBNAME_EREGIS;

$link = mysql_connect($_config['database']['hostname'], $_config['database']['username'], $_config['database']['password']);
$objDB = mysql_select_db($_config['database']['database']);
mysql_query("SET NAMES UTF8");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

// $mysqli = new mysqli($_config['database']["hostname"],$_config['database']["username"],$_config['database']["password"],$_config['database']["database"]);
// // mysql_query ("set character_set_results='utf8'");
// mysqli_set_charset($mysqli, "utf8");

$sql = "SELECT
          rg_Student.stdId, 
          rg_Student.stdCode, 
          rg_Student.stdName, 
          rg_Student.stdSurname, 
          rg_Student.stdGPA, 
          rg_Student.stdAdY, 
          rg_Student.stdAdmitDate, 
          rg_Student.stdGraduateY, 
          rg_Student.stdGraduateDate, 
          rg_Student.stdExitExam, 
          SUM(rg_StudentBehavior.sbeCutPoint) AS SumCutPoint, 
          rg_StudentStatus.sstName, 
          rg_Student.stdSstId, 
          rg_Student.stdCurId, 
          rg_Curriculum.curName
          FROM
          rg_Student
          LEFT JOIN 
          rg_StudentBehavior
          ON 
            rg_Student.stdId = rg_StudentBehavior.sbeStdId
          LEFT JOIN
          rg_StudentStatus
          ON 
            rg_Student.stdSstId = rg_StudentStatus.sstId
          LEFT JOIN
          rg_Curriculum
          ON 
            rg_Student.stdCurId = rg_Curriculum.curId
          GROUP BY
          rg_Student.stdCode";

$result = mysql_query($sql);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}

    while($row = mysql_fetch_array($result)) {

    $resultData[] = array(
      'stdCode'  => $row["stdCode"],
      'stdName'  => $row["stdName"],
      'stdSurname'  => $row["stdSurname"],
      'stdGPA'  => $row["stdGPA"],
      'stdAdmitYear'  => $row["stdAdY"],
      'stdAdmitDate'  => $row["stdAdmitDate"],
      'stdGraduateYear'  => $row["stdGraduateY"],
      'stdGraduateDate'  => $row["stdGraduateDate"],
      'stdExitExam'  => $row["stdExitExam"],
      'stdStatus'  => $row["stdSstId"],
      'stdStatusName'  => $row["sstName"],
      'stdCurName'  => $row["curName"],
          );
      }

$host = "110.78.211.57";
$username = "student";
$userpassword = "xyz_OK!!!@db";
$dbname = "regist";
  
$conn = mysqli_connect($host ,$username ,$userpassword ,$dbname);
mysqli_set_charset($conn, "utf8");

if (mysqli_connect_errno())
{
	echo "Database Connect Failed : " . mysqli_connect_error();
} else {
  echo "Database Connected";
}

for ($i = 0; $i < count($resultData); $i++) {
  $sql = "INSERT INTO Student (stdCode, stdName,stdSurname,stdGPA,stdAdmitYear,stdAdmitDate,stdGraduateYear,stdGraduateDate,stdExitExam,stdStatus,stdStatusName,stdCurName)
          VALUES ('".$resultData[$i]['stdCode']."','".$resultData[$i]['stdName']."','".$resultData[$i]['stdSurname']."','".$resultData[$i]['stdGPA']."','".$resultData[$i]['stdAdmitYear']."','".$resultData[$i]['stdAdmitDate']."','".$resultData[$i]['stdGraduateYear']."','".$resultData[$i]['stdGraduateDate']."','".$resultData[$i]['stdExitExam']."','".$resultData[$i]['stdStatus']."','".$resultData[$i]['stdStatusName']."','".$resultData[$i]['stdCurName']."') 
          ON DUPLICATE KEY UPDATE 
          stdName='".$resultData[$i]['stdCode']."',
          stdSurname='".$resultData[$i]['stdSurname']."',
          stdGPA='".$resultData[$i]['stdGPA']."',
          stdAdmitYear='".$resultData[$i]['stdAdmitYear']."',
          stdAdmitDate='".$resultData[$i]['stdAdmitDate']."',
          stdGraduateYear='".$resultData[$i]['stdGraduateYear']."',
          stdGraduateDate='".$resultData[$i]['stdGraduateDate']."',
          stdExitExam='".$resultData[$i]['stdExitExam']."',
          stdStatus='".$resultData[$i]['stdStatus']."',
          stdStatusName='".$resultData[$i]['stdStatusName']."',
          stdCurName='".$resultData[$i]['stdCurName']."';
        ";
  $conn->query($sql);
}

  print("<pre>".print_r($resultData,true)."</pre>");
die();


?>