หน้าแรก >> ตรวจสอบรายชื่อผู้ลงทะเบียนอบรม
include "../config.inc.php";
$sql_a1 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A1'";
$sqlquery_a1 = mysql_db_query($dbname, $sql_a1);
$numrow_a1 = mysql_num_rows($sqlquery_a1);
$sql_a2 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A2'";
$sqlquery_a2 = mysql_db_query($dbname, $sql_a2);
$numrow_a2 = mysql_num_rows($sqlquery_a2);
$sql_a3 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A3'";
$sqlquery_a3 = mysql_db_query($dbname, $sql_a3);
$numrow_a3 = mysql_num_rows($sqlquery_a3);
$sql_a4 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A4'";
$sqlquery_a4 = mysql_db_query($dbname, $sql_a4);
$numrow_a4 = mysql_num_rows($sqlquery_a4);
$sql_a5 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A5'";
$sqlquery_a5 = mysql_db_query($dbname, $sql_a5);
$numrow_a5 = mysql_num_rows($sqlquery_a5);
$sql_a6 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A6'";
$sqlquery_a6 = mysql_db_query($dbname, $sql_a6);
$numrow_a6 = mysql_num_rows($sqlquery_a6);
$sql_a7 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A7'";
$sqlquery_a7 = mysql_db_query($dbname, $sql_a7);
$numrow_a7 = mysql_num_rows($sqlquery_a7);
$sql_a8 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'A8'";
$sqlquery_a8 = mysql_db_query($dbname, $sql_a8);
$numrow_a8 = mysql_num_rows($sqlquery_a8);
$sql_b1 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B1'";
$sqlquery_b1 = mysql_db_query($dbname, $sql_b1);
$numrow_b1 = mysql_num_rows($sqlquery_b1);
$sql_b2 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B2'";
$sqlquery_b2 = mysql_db_query($dbname, $sql_b2);
$numrow_b2 = mysql_num_rows($sqlquery_b2);
$sql_b3 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B3'";
$sqlquery_b3 = mysql_db_query($dbname, $sql_b3);
$numrow_b3 = mysql_num_rows($sqlquery_b3);
$sql_b4 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B4'";
$sqlquery_b4 = mysql_db_query($dbname, $sql_b4);
$numrow_b4 = mysql_num_rows($sqlquery_b4);
$sql_b5 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B5'";
$sqlquery_b5 = mysql_db_query($dbname, $sql_b5);
$numrow_b5 = mysql_num_rows($sqlquery_b5);
$sql_b6 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B6'";
$sqlquery_b6 = mysql_db_query($dbname, $sql_b6);
$numrow_b6 = mysql_num_rows($sqlquery_b6);
$sql_b7 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B7'";
$sqlquery_b7 = mysql_db_query($dbname, $sql_b7);
$numrow_b7 = mysql_num_rows($sqlquery_b7);
$sql_b8 = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds = 'B8'";
$sqlquery_b8 = mysql_db_query($dbname, $sql_b8);
$numrow_b8 = mysql_num_rows($sqlquery_b8);
?>
จำนวนผู้สมัครอบรม ณ ขณะนี้ |
กลุ่ม A (ห้องละ 50 คน) |
กลุ่ม B (ห้องละ 50 คน) |
ห้อง QS 2101 = if($numrow_a1 >= 50) {echo "เต็ม";}else{ echo $numrow_a1." คน"; }?> |
ห้อง QS 2105 = if($numrow_a5 >= 50) {echo "เต็ม";}else{ echo $numrow_a5." คน"; }?> |
ห้อง QS 2101 = if($numrow_b1 >= 50) {echo "เต็ม";}else{ echo $numrow_b1." คน"; }?> |
ห้อง QS 2105 = if($numrow_b5 >= 50) {echo "เต็ม";}else{ echo $numrow_b5." คน"; }?> |
ห้อง QS 2102 = if($numrow_a2 >= 50) {echo "เต็ม";}else{ echo $numrow_a2." คน"; }?> |
ห้อง QS 2106 = if($numrow_a6 >= 50) {echo "เต็ม";}else{ echo $numrow_a6." คน"; }?> |
ห้อง QS 2102 = if($numrow_b2 >= 50) {echo "เต็ม";}else{ echo $numrow_b2." คน"; }?> |
ห้อง QS 2106 = if($numrow_b6 >= 50) {echo "เต็ม";}else{ echo $numrow_b6." คน"; }?> |
ห้อง QS 2103 = if($numrow_a3 >= 50) {echo "เต็ม";}else{ echo $numrow_a3." คน"; }?> |
ห้อง QS 2107 = if($numrow_a7 >= 50) {echo "เต็ม";}else{ echo $numrow_a7." คน"; }?> |
ห้อง QS 2103 = if($numrow_b3 >= 50) {echo "เต็ม";}else{ echo $numrow_b3." คน"; }?> |
ห้อง QS 2107 = if($numrow_b7 >= 50) {echo "เต็ม";}else{ echo $numrow_b7." คน"; }?> |
ห้อง QS 2104 = if($numrow_a4 >= 50) {echo "เต็ม";}else{ echo $numrow_a4." คน"; }?> |
ห้อง QS 2108 = if($numrow_a8 >= 50) {echo "เต็ม";}else{ echo $numrow_a8." คน"; }?> |
ห้อง QS 2104 = if($numrow_b4 >= 50) {echo "เต็ม";}else{ echo $numrow_b4." คน"; }?> |
ห้อง QS 2108 = if($numrow_b8 >= 50) {echo "เต็ม";}else{ echo $numrow_b8." คน"; }?> |
if($_GET['rounds'] == "")
{
?>
|
}else{
$rounds = $_GET['rounds'];
if($rounds == "A")
{
$round_content = "ทุกวันจันทร์, พุธ เวลา 17.00-19.00 น.";
}else
{
$round_content = "ทุกวันอังคาร, พฤหัสบดี เวลา 17.00-19.00 น.";
}
$sql_chk = "SELECT * FROM training_reg_remedial_undergraduate WHERE rounds ='$rounds'";
$sqlquery_chk = mysql_db_query($dbname, $sql_chk);
$numrow_chk = mysql_num_rows($sqlquery_chk);
?>
กลุ่ม คลิกเพื่อดูวันที่อบรม
|
กด Ctrl + F แล้วใส่ รหัสนิสิต เพื่อค้นหารายชื่อของท่าน |
# |
รหัสนิสิต |
ชื่อ - นามสกุล |
คณะ |
ห้องเรียน |
$sql_show1 = "SELECT * FROM training_reg_remedial_undergraduate where rounds like '$rounds%' ORDER by rounds";
$regist_result1 = mysql_db_query($dbname,$sql_show1);
$i=1;
$room_before ="";
while($array1 = mysql_fetch_array($regist_result1))
{
$room = $array1['rounds'];
if($room == $room_before) { //ส่วนของการ สลับสี
$bg = $bg_old;
} else {
if ($bg_old == "#FFFFFF")
{
$bg = "#FCF3CF";
} else {
$bg = "#FFFFFF";
}
}
$room_before = $room;
$bg_old = $bg ;
if($room == "A1" || $room == "B1")
{
$room_show = "QS 2101";
}else if($room == "A2" || $room == "B2")
{
$room_show = "QS 2102";
}else if($room == "A3" || $room == "B3")
{
$room_show = "QS 2103";
}else if($room == "A4" || $room == "B4")
{
$room_show = "QS 2104";
}else if($room == "A5" || $room == "B5")
{
$room_show = "QS 2105";
}else if($room == "A6" || $room == "B6")
{
$room_show = "QS 2106";
}else if($room == "A7" || $room == "B7")
{
$room_show = "QS 2107";
}else if($room == "A8" || $room == "B8")
{
$room_show = "QS 2108";
}
?>
|
|
|
|
|
$i++;
}
}?>
|
|