<table width="750" border="0" cellspacing="1" cellpadding="0"> <tr> <td colspan="11" align="left" style="font-family: 'TH SarabunPSK'; font-size: 22px;"><span style="font-size: 22px">ทะเบียนหลักสูตรที่คัดเลือก</span></td> </tr> <tr> <td width="84" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">รหัสหลักสูตร</td> <td width="100" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">เรื่อง</td> <td width="85" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">วันที่เริ่มอบรม</td> <td width="92" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ชื่อผู้บันทึก</td> <td colspan="3" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">การจัดการข้อมูล</td> <td width="48" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ผู้อบรม</td> <td width="43" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ผู้ตอบ</td> <td width="64" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">% ผู้ตอบ</td> <td width="53" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ลบ</td> </tr> <?php while($data = mysql_fetch_array($query)){ $i = $i+1;?> <tr> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data['Id'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align:left"><?php echo $data['title'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data['sDay'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align:left"><?php echo $data['namesave'];?></td> <td width="56" bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><a href="upd12.php?idbo=<?php echo $data['idbo']; ?>" target="_blank">หลักสูตร</a></td> <td width="41" bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><a href="report12_opennew.php?idbo=<?php echo $data['idbo']; ?>" target="_blank">บันทึก</a></td> <?php $Idper = $data['Id']; $sqlper = "SELECT COUNT(userID) as nums FROM $tblnamequestion WHERE Id_userques = '$Idper'"; $queryper = mysql_query($sqlper); $ss = "SELECT COUNT(Id_user) as number FROM $tblnameusertrain WHERE Id_train = '$Idper'"; $qs = mysql_query($ss); $pser = "SELECT (COUNT(B.userID)/COUNT(A.Id_user))*100 AS ser FROM $tblnameusertrain A LEFT JOIN $tblnamequestion B ON A.Id_train = B.Id_userques WHERE A.Id_train = '$Idper';"; $qser = mysql_query($pser); while($data2 = mysql_fetch_array($queryper)){ $i = $i+1; while($data3 = mysql_fetch_array($qs)){ $i = $i+1; while($data4 = mysql_fetch_array($qser)){ $i = $i+1; $per = number_format($data4['ser'],0);?> <td width="64" bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php if($data4['ser'] <=60){ echo "<font color=\"red\">ผลประเมิน</font>";}else{?><a href="rated_report.php?Id=<?php echo $data['Id']?>" target="_blank" style="color:#390" OnClick="return chkdel();">ผลประเมิน</a><?php }?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data3['number'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data2['nums'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php if($data4['ser'] <=60){ echo "<font color=\"red\">$per %</font>"; } else { echo "<font color=\"green\">$per %</font>"; }}}}?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><a href="delectTB_TRIN.php?Id=<?php echo $data['Id']; ?>" onclick="return confirm('ท่านต้องการลบข้อมูลหลักสูตรนี้ทั้งหมดใช่หรือไม่ !!!')">ลบ</a></td> </tr><?php }?> </table><?php }} else if($ser == 0){ $sqlse = "SELECT * FROM $tblnametrain"; $queryse = mysql_query($sqlse);?><table width="750" border="0" cellspacing="1" cellpadding="0"> <tr> <td colspan="11" align="center" style="font-family: 'TH SarabunPSK'; font-size: 22px;"><div align="left"><span style="font-size: 22px">ทะเบียนหลักสูตรที่คัดเลือก</span></div></td> </tr> <tr> <td width="84" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">รหัสหลักสูตร</td> <td width="100" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">เรื่อง</td> <td width="85" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">วันที่เริ่มอบรม</td> <td width="92" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ชื่อผู้บันทึก</td> <td colspan="3" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">การจัดการข้อมูล</td> <td width="48" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ผู้อบรม</td> <td width="43" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ผู้ตอบ</td> <td width="64" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">% ผู้ตอบ</td> <td width="53" align="center" bgcolor="#FFFF99" style="font-family: 'TH SarabunPSK'; font-size: 22px;">ลบ</td> </tr> <?php while($data = mysql_fetch_array($queryse)){ $i = $i+1;?> <tr> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data['Id'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align:left"><?php echo $data['title'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data['sDay'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align:left"><?php echo $data['namesave'];?></td> <td width="56" bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><a href="upd12.php?idbo=<?php echo $data['idbo']; ?>" target="_blank">หลักสูตร</a></td> <td width="41" bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><a href="report12_opennew.php?idbo=<?php echo $data['idbo']; ?>" target="_blank">บันทึก</a></td> <?php $Idper = $data['Id']; $sqlper = "SELECT COUNT(userID) as nums FROM $tblnamequestion WHERE Id_userques = '$Idper'"; $queryper = mysql_query($sqlper); $ss = "SELECT COUNT(Id_user) as number FROM $tblnameusertrain WHERE Id_train = '$Idper'"; $qs = mysql_query($ss); $pser = "SELECT (COUNT(B.userID)/COUNT(A.Id_user))*100 AS ser FROM $tblnameusertrain A LEFT JOIN $tblnamequestion B ON A.Id_train = B.Id_userques WHERE A.Id_train = '$Idper';"; $qser = mysql_query($pser); while($data2 = mysql_fetch_array($queryper)){ $i = $i+1; while($data3 = mysql_fetch_array($qs)){ $i = $i+1; while($data4 = mysql_fetch_array($qser)){ $i = $i+1; $per = number_format($data4['ser'],0);?> <td width="64" bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php if($data4['ser'] <=60){ echo "<font color=\"red\">ผลประเมิน</font>";}else{?><a href="rated_report.php?Id=<?php echo $data['Id']?>" target="_blank" style="color:#390" OnClick="return chkdel();">ผลประเมิน</a><?php }?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data3['number'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php echo $data2['nums'];?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><?php if($data4['ser'] <=60){ echo "<font color=\"red\">$per %</font>"; } else { echo "<font color=\"green\">$per %</font>"; }}}}?></td> <td bgcolor="#FFFFCC" style="font-size: 20px; font-family: 'TH SarabunPSK'; text-align: center"><a href="delectTB_TRIN.php?Id=<?php echo $data['Id']; ?>" onclick="return confirm('ท่านต้องการลบข้อมูลหลักสูตรนี้ทั้งหมดใช่หรือไม่ !!!')">ลบ</a></td> </tr><?php }?> </table><?php }?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
Load balance : Server 05
