01.
<?php
02.
include
(
"connect_db.php"
);
03.
$strSQL
=
"SELECT * FROM EV_ANSWER WHERE STUDENTCODE = '"
.
$_GET
[
"student_code"
].
"' and OFFICERID = '"
.
$_GET
[
"OFFICERID"
].
"' and COURSECODE = '"
.
$_GET
[
"COURSECODE"
].
"'"
;
04.
$objParse
= oci_parse (
$objConnect
,
$strSQL
);
05.
oci_execute (
$objParse
,OCI_DEFAULT);
06.
$objResult
= oci_fetch_array(
$objParse
);
07.
if
(
$objResult
)
08.
{
09.
for
(
$i
=1;
$i
<=(int)
$_POST
[
"line"
];
$i
++)
10.
{
11.
$strSQL
=
"update EV_ANSWER set CHOICEID = '"
.
$_POST
[
"q_no"
.
$i
].
"', TQF_ID ='"
.
$_POST
[
"id"
.
$i
].
"' where STUDENTCODE = '"
.
$_GET
[
"student_code"
].
"' and OFFICERID = '"
.
$_GET
[
"OFFICERID"
].
"' and COURSECODE = '"
.
$_GET
[
"COURSECODE"
].
"' "
;
12.
$objParse
= oci_parse (
$objConnect
,
$strSQL
);
13.
oci_execute(
$objParse
);
14.
if
(
$objResult
)
15.
{
16.
echo
"<body onload=\"window.alert(' แก้ไขการประเมินเรียบร้อยแล้ว..');return history.go(-2)\">"
;
17.
}}}
18.
else
19.
{
20.
for
(
$i
=1;
$i
<=(int)
$_POST
[
"line"
];
$i
++)
21.
{
22.
23.
24.
25.
$str
=
"INSERT INTO EV_ANSWER"
;
26.
$str
.=
"(\"STUDENTCODE\",\"OFFICERID\",\"COURSECODE\",\"TQF_ID\",\"CHOICEID\",\"CLASSID\",\"STATUS\")"
;
27.
$str
.=
"VALUES "
;
28.
$str
.=
"('"
.
$_GET
[
"student_code"
].
"','"
.
$_GET
[
"OFFICERID"
].
"','"
.
$_GET
[
"COURSECODE"
].
"','"
.
$_POST
[
"id"
.
$i
].
"','"
.
$_POST
[
"q_no"
.
$i
].
"','"
.
$_POST
[
"CLASSID"
].
"','"
.
$_GET
[
"STATUS"
].
"')"
;
29.
$objParse
= oci_parse(
$objConnect
,
$str
);
30.
$objExecute
= oci_execute(
$objParse
,OCI_DEFAULT);
31.
}
32.
include
(
"connect_db.php"
);
33.
$strSQL
=
"INSERT INTO EV_COMMENT "
;
34.
$strSQL
.=
"(\"COMMENTEXT\",\"OFFICERID\",\"STUDENTCODE\",\"COURSECODE\",\"CLASSID\") "
;
35.
$strSQL
.=
"VALUES "
;
36.
$strSQL
.=
"('"
.
$_POST
[
"COMMENT"
].
"','"
.
$_GET
[
"OFFICERID"
].
"','"
.
$_GET
[
"student_code"
].
"','"
.
$_GET
[
"COURSECODE"
].
"','"
.
$_POST
[
"CLASSID"
].
"')"
;
37.
$objParse
= oci_parse(
$objConnect
,
$strSQL
);
38.
$objExecute
= oci_execute(
$objParse
, OCI_DEFAULT);
39.
if
(
$objExecute
)
40.
{
41.
oci_commit(
$objConnect
);
42.
echo
"<body onload=\"window.alert(' บันทึกการประเมิน..');return history.go(-2)\">"
;
43.
}
44.
else
45.
{
46.
oci_rollback(
$objConnect
);
47.
echo
"Error Save ["
.
$strSQL
.
""
;
48.
echo
"<body onload=\"window.alert(' เกิดข้อผิดพลาด..!!');return history.go(-1)\">"
;
49.
}
50.
}
51.
oci_close(
$objConnect
);
52.
?>