Viewing file: demo.php (4.42 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?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();
?>
|