", "practice");
if (mysqli_connect_errno()) {
//printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
//printf("#connect successfully
\n");
if(isset($_GET["inst"]))
{
$serial = "\"".$_GET["inst"]."\"";
if( !(isset($_GET["code"])))
{
//echo "not API
";
$query = "SELECT OpCode FROM status WHERE SerialNo = $serial";
//echo "#query
=>
$query
";
if ($result = mysqli_query($link, $query))
{
if ($row = mysqli_fetch_row($result))
{
$service_code = "\"$row[0]\"";
echo "service_code:$row[0]";
//echo "
insert service_code to log
";
$query = "INSERT INTO log(Time,SerialNo,OpCode) VALUES (\"$time\", $serial, $service_code)";
//echo "#query
=>
$query
";
mysqli_query($link, $query);
//printf("Insert New Record sucessfully
");
}
else
{
//echo "
insert wrong service_code to log
";
$query = "INSERT INTO log(Time,SerialNo,OpCode,msg) VALUES (\"$time\", $serial, \"\",\"wrong serial\")";
mysqli_query($link, $query);
//printf("Insert New wrong record sucessfully
");
}
mysqli_free_result($result);
mysqli_free_result($row);
}
}
else
{
//echo "is API
";
$service_code = "\"".$_GET["code"]."\"";
if($service_code == "\"666\"")
{
//echo "
insert API's service code to log
";
$query = "INSERT INTO log(Time,SerialNo,OpCode) VALUES (\"$time\", $serial, $service_code)";
mysqli_query($link, $query);
//printf("Insert into log sucessfully
");
//printf("update status to 666
");
$query="UPDATE status SET OpCode = $service_code WHERE SerialNo = $serial";
mysqli_query($link, $query);
//printf("update successfully.
Affected rows (UPDATE): %d
", mysqli_affected_rows($link));
}
else if($service_code == "\"400\"")
{
if(isset($_GET["msg"]))
{
$msg="\"".$_GET["msg"]."\"";
$query = "INSERT INTO log(Time,SerialNo,OpCode,msg) VALUES (\"$time\", $serial, $service_code,$msg)";
mysqli_query($link, $query);
//printf("Insert 400 sucessfully
");
//printf("update status to 000
");
$query="UPDATE status SET OpCode = \"000\" WHERE SerialNo = $serial";
mysqli_query($link, $query);
//printf("update successfully.
Affected rows (UPDATE): %d
", mysqli_affected_rows($link));
}
}
else if($service_code == "\"777\"")
{
//echo "
insert API's service code to log
";
$query = "INSERT INTO log(Time,SerialNo,OpCode) VALUES (\"$time\", $serial, $service_code)";
mysqli_query($link, $query);
//printf("Insert into log sucessfully
");
//printf("update status to 000
");
$query="UPDATE status SET OpCode = \"000\" WHERE SerialNo = $serial";
mysqli_query($link, $query);
//printf("update successfully.
Affected rows (UPDATE): %d
", mysqli_affected_rows($link));
}
}
}
else
{
//printf("no serial");
}
mysqli_close($link);
?>