001.
<?php
002.
session_start();
003.
@
$ses_userid
=
$_SESSION
[ses_userid];
004.
@
$ses_user
=
$_SESSION
[ses_user];
005.
if
(
$ses_userid
<> session_id()
or
@
$ses_user
==
""
) {
006.
echo
"คุณยังไม่ได้ทำการ Log in"
;
007.
echo
"<meta http-equiv='refresh' content='1;URL=index.html' />"
;
008.
}
else
{
009.
?>
010.
<html lang=
"en"
>
011.
<head>
012.
<?php
013.
include
"DBconn.inc.php"
;
014.
015.
mysql_query(
"SET character_set_results=utf8"
);
016.
mysql_query(
"SET character_set_client=utf8"
);
017.
mysql_query(
"SET character_set_connection=utf8"
);
018.
$conn
=
new
mysqli(
$servername
,
$username
,
$password
,
$dbname
);
019.
mysqli_set_charset(
$conn
,
"utf8"
);
020.
if
(
$conn
->connect_error) {
021.
die
(
"Connection failed: "
.
$conn
->connect_error);
022.
}
023.
$sql
=
"SELECT * FROM event where event_id = '"
.
$_GET
['cc
'] . "'
";
024.
$result
=
$conn
->query(
$sql
);
025.
while
(
$row
=
$result
->fetch_assoc()) {
026.
?>
027.
<title>รายชื่อผู้ลงทะเบียนกิจกรรม <?php
echo
$row
[
"event_name"
]; ?></title>
028.
<?php
029.
}
030.
031.
$conn
->close();
032.
?>
033.
<meta charset=
"utf-8"
>
034.
<meta name=
"viewport"
content=
"width=device-width, initial-scale=1"
>
038.
</head>
039.
040.
<body>
041.
<div
class
=
"container"
>
042.
<br />
043.
<?php
044.
include
"DBconn.inc.php"
;
045.
include
"functiondate.php"
;
046.
047.
mysql_query(
"SET character_set_results=utf8"
);
048.
mysql_query(
"SET character_set_client=utf8"
);
049.
mysql_query(
"SET character_set_connection=utf8"
);
050.
$conn
=
new
mysqli(
$servername
,
$username
,
$password
,
$dbname
);
051.
mysqli_set_charset(
$conn
,
"utf8"
);
052.
if
(
$conn
->connect_error) {
053.
die
(
"Connection failed: "
.
$conn
->connect_error);
054.
}
055.
$sql
=
"SELECT * FROM eventl where event_id = '"
.
$_GET
['cc
'] . "'
";
056.
$result
=
$conn
->query(
$sql
);
057.
while
(
$row
=
$result
->fetch_assoc()) {
058.
?>
059.
<h4><p>รายชื่อผู้ลงทะเบียนกิจกรรม <?php
echo
$row
[
"event_name"
]; ?>
060.
<br />
061.
<br />
062.
วันที่ <?php
echo
DateThai(
$row
[
"event_date"
]); ?></p></h4>
063.
<?php
064.
}
065.
066.
$conn
->close();
067.
?>
068.
<br />
069.
<table
class
=
"table table-hover table-striped"
>
070.
<thead>
071.
<tr>
072.
<th>ลำดับที่</th>
073.
<th>ชื่อ - นามสกุล</th>
074.
<th>หน่วยงาน</th>
075.
<th>สถานะเข้าร่วมกิจกรรม</th>
076.
</tr>
077.
</thead>
078.
<tbody>
079.
<?php
080.
include
"DBconn.inc.php"
;
081.
$no
= 1;
082.
mysql_query(
"SET character_set_results=utf8"
);
083.
mysql_query(
"SET character_set_client=utf8"
);
084.
mysql_query(
"SET character_set_connection=utf8"
);
085.
$conn
=
new
mysqli(
$servername
,
$username
,
$password
,
$dbname
);
086.
mysqli_set_charset(
$conn
,
"utf8"
);
087.
if
(
$conn
->connect_error) {
088.
die
(
"Connection failed: "
.
$conn
->connect_error);
089.
}
090.
$sql
=
"SELECT * FROM event_regist where event_id = '"
.
$_GET
['cc
'] . "'
";
091.
$result
=
$conn
->query(
$sql
);
092.
while
(
$row
=
$result
->fetch_assoc()) {
093.
?>
094.
<tr>
095.
<td width=
"10%"
><?=
$no
++ ?></td>
096.
<td><?php
echo
$row
[
"fname"
] .
" "
.
$row
[
"lname"
]; ?></td>
097.
<td><?php
echo
$row
[
"dep_name"
]; ?></td>
098.
<td>
099.
<?php
100.
$result2
= mysqli_query(
$conn
,
"SELECT * FROM event_regist"
);
101.
102.
while
(
$row2
= mysqli_fetch_assoc(
$result2
)) {
103.
104.
?>
105.
<?php
106.
if
(
$row2
[
'event_check'
] ==
'Y'
) {
107.
?>
108.
<input name=
"checkbox"
type=
"checkbox"
id=
"checkbox"
checked=
"checked"
/>
109.
<?php
110.
111.
}
else
{
112.
?>
113.
<input name=
"checkbox"
type=
"checkbox"
id=
"checkbox"
/>
114.
<?php
115.
116.
}
117.
}
118.
?>
119.
</td>
120.
</tr>
121.
<?php
122.
}
123.
124.
$conn
->close();
125.
?>
126.
127.
128.
</tbody>
129.
</table>
130.
131.
</div>
132.
</body>
133.
</html>
134.
<?php
135.
}
136.
?>