<?php /*** By Weerachai Nukitram ***/ /*** http://www.ThaiCreate.Com ***/ include "Connect.php"; ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>ThaiCreate.Com ListMenu</title> <script language = "JavaScript"> //**** List Province (Start) ***// function ListSubject(SelectValue) { frmMain.ddlSubject.length = 0 //*** Insert null Default Value ***// var myOption = new Option('','') frmMain.ddlSubject.options[frmMain.ddlSubject.length]= myOption <? $intRows = 0; $strSQL = "SELECT * FROM subject inner join level on subject.id_level=level.id_level"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); $intRows = 0; while($objResult = mysql_fetch_array($objQuery)) { $intRows++; ?> x = <?=$intRows;?>; mySubList = new Array(); strGroup = <?=$objResult["id_level"];?>; strValue = "<?=$objResult["id_sub"];?>"; strItem = "<?=$objResult["sub_name"];?>"; strItem2 = "<?=$objResult["level_name"];?>"; mySubList[x,0] = strItem; mySubList[x,1] = strGroup; mySubList[x,2] = strValue; mySubList[x,3] = strItem2; if (mySubList[x,1] == SelectValue){ var myOption = new Option(mySubList[x,0], mySubList[x,2]) frmMain.ddlSubject.options[frmMain.ddlSubject.length]= myOption } <? } ?> } //**** List Province (End) ***// </script> <SCRIPT language=JavaScript> function check_number() { e_k=event.keyCode //if (((e_k < 48) || (e_k > 57)) && e_k != 46 ) { if (e_k != 13 && (e_k < 48) || (e_k > 57)) { event.returnValue = false; alert("กรุณาใส่ตัวเลขค่ะ"); } } </script> <script> function calc(){ var txt1 = document.getElementById('txtMid'); var txt2 = document.getElementById('txtFinal'); var txt3 = document.getElementById('txtSum'); if(!isNaN(txt1.value) && txt1.value!="" && !isNaN(txt2.value) && txt2.value!=""){ txt3.value = parseInt(txt1.value)+parseInt(txt2.value); } } </script> <SCRIPT language=JavaScript> function sumScore(arr){ document.all["s["+arr+"]"].value=document.all["m["+arr+"]"].value*1+document.all["f["+arr+"]"].value*1; if(document.all["s["+arr+"]"].value>=80) document.all["g["+arr+"]"].value="A"; else if(document.all["s["+arr+"]"].value>=75 && document.all["s["+arr+"]"].value<=79) document.all["g["+arr+"]"].value="B+"; else if(document.all["s["+arr+"]"].value>=70 && document.all["s["+arr+"]"].value<=74) document.all["g["+arr+"]"].value="B"; else if(document.all["s["+arr+"]"].value>=65 && document.all["s["+arr+"]"].value<=69) document.all["g["+arr+"]"].value="C+"; else if(document.all["s["+arr+"]"].value>=60 && document.all["s["+arr+"]"].value<=64) document.all["g["+arr+"]"].value="C"; else if(document.all["s["+arr+"]"].value>=55 && document.all["s["+arr+"]"].value<=59) document.all["g["+arr+"]"].value="D+"; else if(document.all["s["+arr+"]"].value>=50 && document.all["s["+arr+"]"].value<=54) document.all["g["+arr+"]"].value="D"; else if(document.all["s["+arr+"]"].value<54) document.all["g["+arr+"]"].value="E"; if(document.all["f["+arr+"]"].value>="ขส") document.all["g["+arr+"]"].value="ขส"; if(document.all["m["+arr+"]"].value>="มส") document.all["g["+arr+"]"].value="มส"; else if(document.all["m["+arr+"]"].value>="I") document.all["g["+arr+"]"].value="I"; } </SCRIPT> <style type="text/css"> <!-- .style1 { color: #FFFFFF; font-weight: bold; } --> </style> </head> <form name="frmMain" action="" method="post"> <div align="center">ระดับชั้น <select id="ddlLevel" name="ddlLevel" onChange = "ListSubject(this.value)"> <option selected value=""></option> <? $strSQL = "SELECT * FROM level ORDER BY id_level ASC "; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); while($objResult = mysql_fetch_array($objQuery)) { ?> <option value="<?=$objResult["id_level"];?>"> <?=$objResult["level_name"];?> </option> <? } ?> </select> รายวิชา <select id="ddlSubject" name="ddlSubject" style="width:120px"> </select> <input type="submit" name="button" id="button" value="Submit"> </div> </form> <table width="950" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><form name="form1" method="get" action="DemoSave.php"> <table width="900" border="1" align="center" cellpadding="2" cellspacing="2"> <tr bgcolor="#333333"> <td height="30" colspan="7"><div align="center" class="style1">แสดงรายชื่อนักเรียน</div></td> </tr> <tr> <td width="50" height="30"><div align="center">ลำดับ</div></td> <td width="80"><div align="center">รหัส</div></td> <td width="250"><div align="center">ชื่อ-สกุล</div></td> <td width="160"><div align="center">คะแนนสอบกลางภาค</div></td> <td width="160"><div align="center">คะแนนสอบปลายภาค</div></td> <td width="100"><div align="center">รวม</div></td> <td width="100"><div align="center">เกรด</div></td> </tr> <? $Level=$_POST["ddlLevel"]; $Subject=$_POST["ddlSubject"]; $strSQL = "select * from student WHERE id_level='$Level' AND id_sub='$Subject'"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); ?> <? $i=0; while($objResult=mysql_fetch_array($objQuery)) { $i++; ?> <tr> <td height="30"><div align="center"> <? echo $i;?> </div></td> <td><div align="center"><?=$objResult["id_student"];?> <input type="hidden" name="hdId" id="hdId" value="<?=$objResult["id_student"];?>"> </div></td> <td><div align="left"> <?=$objResult["stu_befor"];?> <?=$objResult["stu_name"];?> <?=$objResult["stu_sur"];?> <input type="hidden" name="hdPrefix" id="hdPrefix" value="<?=$objResult["stu_befor"];?>"> <input type="hidden" name="hdFirstName" id="hdFirstName" value="<?=$objResult["stu_name"];?>"> <input type="hidden" name="hdLastName" id="hdLastName" value="<?=$objResult["stu_sur"];?>"> </div></td> <td><div align="center"> <INPUT id=m[1]3 maxLength=4 onchange=sumScore(1); size=4 value=0 name=m[1]> </div></td> <td><div align="center"> <INPUT id=f[1]3 maxLength=4 onchange=sumScore(1); size=4 value=0 name=f[1]> </div></td> <td><div align="center"> <INPUT id=s[1]3 readOnly maxLength=3 size=3 value=0 name=s[1]> </div></td> <td><div align="center"> <INPUT id=g[1]2 readOnly maxLength=2 size=2 value=0 name=g[1]> </div></td> </tr> <?php } // จบ while?> </table> <p align="center"> <input type="submit" name="button2" id="button2" value="ส่งผลการเรียน"> <input type="reset" name="button3" id="button3" value="ยกเลิก"> </p> </form> </td> </tr> </table> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
