001.
<!doctype html>
002.
<html>
003.
<head>
004.
<!-- Required meta tags -->
005.
<meta charset=
"utf-8"
>
006.
<meta name=
"viewport"
content=
"width=device-width, initial-scale=1, shrink-to-fit=no"
>
007.
008.
<title>e-Project IVEB</title>
012.
013.
<meta name=
"viewport"
content=
"width=device-width, initial-scale=1, shrink-to-fit=no"
>
014.
<!-- Bootstrap CSS -->
016.
<script src=
"script.js"
></script>
017.
<script>
018.
019.
020.
</script>
021.
022.
<meta http-equiv=
"X-UA-Compatible"
content=
"IE=edge"
>
023.
<meta name=
"viewport"
content=
"width=device-width, initial-scale=1"
>
024.
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
025.
026.
<!-- Latest compiled
and
minified CSS -->
028.
029.
<!-- Optional theme -->
031.
033.
034.
<!-- Latest compiled
and
minified JavaScript -->
036.
037.
<script src=
"script.js"
></script>
038.
039.
<!-- HTML5 shim
and
Respond.js
for
IE8 support of HTML5 elements
and
media queries -->
040.
<!-- WARNING: Respond.js doesn't work
if
you view the page via file:
041.
<!--[
if
lt IE 9]>
044.
<![
endif
]-->
045.
046.
</head>
047.
048.
<body>
049.
<div
class
=
"alert alert-primary"
role=
"alert"
align=
"right"
>
050.
สถาบันการอาชีวศึกษากรุงเทพมหานคร Institute of Vocational Education, Bangkok
051.
052.
</div>
053.
<div
class
=
"card-header"
>
054.
<h5><center>
055.
ผลงานที่ลงทะเบียนเข้าร่วมนำเสนอในงานการประชุมทางวิชาการและนวัตกรรมเทคโนโลยีบัณฑิต ครั้งที่ 5 ประจำปีการศึกษา 2563
056.
</center></h5>
057.
</div>
058.
<div
class
=
"container"
style=
"width:1500px;"
>
059.
<h2
class
=
"text-primary"
>การนำเสนอภาคโปสเตอร์ (Poster Presentation) </h2>
060.
<?php
061.
if
(
$_POST
[
"submitAd"
] ==
"true"
){
062.
include
"connect.php"
;
063.
for
(
$i
=1;
$i
<=
$_POST
[
"hdnLine"
];
$i
++)
064.
{
065.
066.
$sql3
=
"UPDATE project SET award = '"
.
$_POST
[
"award$i"
].
"' WHERE idProject = '"
.
$_POST
[
"idProject$i"
].
"'"
;
067.
$query3
= mysqli_query(
$link
,
$sql3
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
068.
069.
}
070.
071.
072.
073.
}
074.
075.
076.
?>
077.
<form method=
"post"
action=
""
>
078.
<table width=
"101%"
class
=
"table table-hover"
>
079.
<thead>
080.
<tr>
081.
<th scope=
"col"
> </th>
082.
<th scope=
"col"
> </th>
083.
<th scope=
"col"
> </th>
084.
<th scope=
"col"
> </th>
085.
<th scope=
"col"
> </th>
086.
<th scope=
"col"
> </th>
087.
<th scope=
"col"
> </th>
088.
<th scope=
"col"
> </th>
089.
</tr>
090.
<tr>
091.
<th width=
"92"
scope=
"col"
>#</th>
092.
<th width=
"152"
scope=
"col"
>วิทยาลัย</th>
093.
<th width=
"189"
scope=
"col"
>สาขาวิชา</th>
094.
<th width=
"287"
scope=
"col"
>ชื่อภาษาไทย</th>
095.
<th width=
"302"
scope=
"col"
>ชื่อภาษาอังกฤษ</th>
096.
<th width=
"215"
scope=
"col"
>ผู้จัดทำ</th>
097.
<th width=
"252"
scope=
"col"
>idProject</th>
098.
<th width=
"252"
scope=
"col"
>รางวัล</th>
099.
</tr>
100.
</thead>
101.
<tbody>
102.
<?php
103.
$idSubj
=
$_GET
[
'idSubj'
];
104.
$idProtype
=
$_GET
[
'idProtype'
];
105.
include
"connect.php"
;
106.
$sqlOral
=
"SELECT project.`idProject`, project.`NamePrTH`, project.`NamePrEng`, project.`filePDF`, project.`fileWord`, project.`mobile`, college.`nameEducat`, subject.`nameSubject` FROM project, college, subject WHERE project.`idProtype`='$idProtype' AND project.`idSubject` = '$idSubj' AND college.`idEducat`=project.`idED` AND subject.`idSubject`=project.`idSubject` ORDER BY subject.`idSubject`"
;
107.
$objQueryOral
= mysqli_query(
$link
,
$sqlOral
);
108.
$numProOral
=mysqli_num_rows(
$objQueryOral
);
109.
$i
=1;
110.
while
(
$objResultOral
= mysqli_fetch_array(
$objQueryOral
))
111.
{
112.
113.
114.
?>
115.
<tr>
116.
<th scope=
"row"
><?php
echo
$i
;?></th>
117.
<td><?php
echo
$objResultOral
[
"nameEducat"
]; ?> </td>
118.
<td><?php
echo
$objResultOral
[
"nameSubject"
]; ?> </td>
119.
<td><?php
echo
$objResultOral
[
"NamePrTH"
]; ?> </td>
120.
<td><?php
echo
$objResultOral
[
"NamePrEng"
]; ?></td>
121.
<td><?php
$sqlName
=
"SELECT GROUP_CONCAT(CONCAT(prefix, firstname, ' ' , lastname)SEPARATOR ', ') AS FullName,idProject FROM student WHERE idProject = '"
.
$objResultOral
[
"idProject"
].
"'"
;
122.
$objQueryName
= mysqli_query(
$link
,
$sqlName
);
123.
while
(
$objResultName
= mysqli_fetch_array(
$objQueryName
))
124.
$name
=
$objResultName
[
"FullName"
];
125.
{
echo
$name
;
" ,"
;
126.
?></td>
127.
<td><input
class
=
"form-control"
type=
"text"
placeholder=
"Default input"
name=
"idProject<?=$i; ?>"
value=
"<?php echo $objResultOral["
idProject
"]; ?>"
> </td>
128.
<td>
129.
<span
class
=
"form-group"
>
130.
<select
class
=
"form-control"
name=
"award<?=$i; ?>"
id=
"award"
style=
""
>
131.
<option value=
"No"
>ไม่ติดอันดับ</option>
132.
<option value=
"A1"
>รางวัลชนะเลิศ</option>
133.
<option value=
"A2"
>รางวัลรองชนะเลิศอันดับ 1</option>
134.
<option value=
"A3"
>รางวัลรองชนะเลิศอันดับ 2</option>
135.
</select>
136.
137.
</span>
138.
</td>
139.
</tr>
140.
<?php
$i
++; };;} ?>
141.
</tbody>
142.
</table>
143.
<input type=
"submit"
name=
"submitAd"
id =
"submitAd"
class
=
"btn btn-warning btn-xs"
value=
"บันทึกผล"
/>
144.
<input type=
"hidden"
name=
"hdnLine"
value=
"<?php echo $i;?>"
>
145.
146.
</form>
147.
<h3
class
=
"text-info"
> </h3>
148.
</div>
149.
<div
class
=
"modal fade"
id=
"edit_user"
tabindex=
"-1"
role=
"dialog"
aria-labelledby=
"myModalLabel"
><div
class
=
"modal-dialog"
role=
"document"
><div
class
=
"modal-content"
>
150.
</div>
151.
</div>
152.
</div>
153.
</body>
154.
</html>