01.
<?php
02.
include
(
'connect.php'
);
03.
04.
date_default_timezone_set(
'Asia/Bangkok'
);
05.
06.
if
(isset(
$_POST
[
'saveMgstatus'
])) {
07.
$u_id
=
$_POST
[
'user_id'
];
08.
$created
=
$_POST
[
'created'
];
09.
$time
=
$_POST
[
'time'
];
10.
$status
=
$_POST
[
'status'
];
11.
$maxDegree
=
$_POST
[
'maxDegree'
];
12.
$global_num
=
$_POST
[
'global_num'
];
13.
saveMgstatus(
$conn
,
$u_id
,
$created
,
$time
,
$maxDegree
,
$global_num
,
$status
);
14.
15.
echo
"degree = "
.
$maxDegree
.
"and"
;
16.
echo
$_POST
[
'maxDegree'
];
17.
echo
"degree = $maxDegree"
;
18.
}
19.
function
saveMgstatus(
$conn
,
$u_id
,
$created
,
$time
,
$maxDegree
,
$global_num
,
$status
)
20.
{
21.
$sql
= "INSERT INTO `mgstatus` (`mgid`, `user_id`, `created`, `time`, `degree`, `
count
`, `status`) VALUES
22.
(NULL,
'$u_id'
,
'$created'
,
'$time'
,
'$maxDegree'
,
'$global_num'
,
'$status'
);";
23.
24.
if
(
$conn
->query(
$sql
) === TRUE) {
25.
echo
"New record created successfully"
;
26.
}
else
{
27.
echo
"Error: "
.
$sql
.
"<br>"
.
$conn
->error;
28.
}
29.
}
30.
31.
32.
?>