<? include('config.php'); $erid=$_GET[check]; $s=$_GET[xxx1]; $ex=$_GET[xxx2]; $c=''; //echo "$s $ex</br>"; $sql = "select * from exam_results as er , exam_news as en where er.s_id='$s' and er.ex_id='$ex' and en.id='$ex' and er.questionnum=en.questionnum and c1='$c'"; $objQuery = mysql_query($sql); $num=mysql_num_rows($objQuery); //$objResult = mysql_fetch_array($objQuery); echo $num; ?> <form id="form1" name="form1" method="post" action="exam-check-select-save.php"> <? for($i=1;$i<=$num;$i++) { while($objResult = mysql_fetch_array($objQuery)) { ?> <table width="70%" cellpadding="0" cellspacing="0"> <tr> <td width="9%" align="right" valign="top" scope="col">คำถาม <?=$objResult["er_id"];?></td> <td width="38%" align="left" valign="top" scope="col"> <?=$objResult["question"];?></td> <td width="25%" scope="col">คำตอบของนักศึกษา</td> <td width="33%" scope="col"><?=$objResult["answers"];?></td> </tr> <tr> <td valign="top" scope="col" align="right">เฉลย </td> <td valign="top" scope="col" align="left"> <?=$objResult["answer"];?></td> <td colspan="2" align="center" valign="middle" scope="col">คะแนนที่ได้ <label> <input type="text" name="scores<?=$i;?>" id="scores" /> คะแนน</label></td> </tr> <tr> <td colspan="3" scope="col"> คะแนน <?=$objResult["scoren"];?> คะแนน </LABEL></td> <td scope="col"> </td> </tr> <tr> <td colspan="4" align="right" valign="top" scope="col">—————————————————————————————————————————— </td> <input name="edit_id" type="hidden" id="edit_id" value="<?=$_REQUEST['xxx1']?>" /> <input name="num1" type="hidden" id="num1" value="<?=$_REQUEST['xxx2']?>" /> <input name="num" type="hidden" id="num" value="<?=$num;?>" /> <input name="er_id<?=$i;?>" type="hidden" id="er_id" value="<?=$objResult["er_id"];?>" /> <input type="hidden" name="hdnLine" value="<?=$i;?>"> <input name="scoren<?=$i;?>" type="hidden" id="scoren" value="<?=$objResult["scoren"];?>" /> </tr> <? $i++;}} ?> </table> <center><input id="submit" value="บันทึก" type="submit" name="submit2" /></center> </form>
<? include('config.php'); $n=$_POST[num]; echo "n = $n</br>"; $n1=$_REQUEST["edit_id"]; $n2=$_REQUEST["num1"]; echo "$n1</br> $n2 </br>"; for($i=0; $i<=$n;$i++) { echo "X$i =".$_POST["scores$i"]."คะแนนที่ได้,".$_POST["scoren$i"]."คำถาม</br>"; if($_POST["scores$i"] != "") { $strSQL = "UPDATE exam_results SET score='".$_POST["scores$i"]."' WHERE er_id=".$_POST["er_id$i"].""; $sqll=mysql_query($strSQL ) or die (mysql_error()); //echo "$sqll ><</br>"; } } $scoretotals=0; $scoretotal=$scoretotals+$_POST["scores$i"]; echo "scoretotal=$scoretotal</br>"; //echo "<meta Http-equiv=\"refresh\" Content=\"2; Url=../project2/exam-check.php?id=$n1\">"; ?>
<? include('config.php'); $n=$_POST[num]; echo "n = $n</br>"; $n1=$_REQUEST["edit_id"]; $n2=$_REQUEST["num1"]; echo "$n1</br> $n2 </br>"; $scoretotals=0; echo "$scoretotals</br>"; for($i=1; $i<=$n;$i++) { $scoretotals=$scoretotals+"".$_POST["scores$i"].""; echo "X$i =".$_POST["scores$i"]."คะแนนที่ได้,".$_POST["scoren$i"]."คำถาม</br>"; if($_POST["scores$i"] != "") { $strSQL = "UPDATE exam_results SET score='".$_POST["scores$i"]."' WHERE er_id=".$_POST["er_id$i"].""; $sqll=mysql_query($strSQL ) or die (mysql_error()); //echo "$sqll ><</br>"; } } echo "scoretotal=$scoretotals"; //echo "<meta Http-equiv=\"refresh\" Content=\"2; Url=../project2/exam-check.php?id=$n1\">"; ?>
<? include("../config.php"); ?> <body> <table width="80%" border="1" align="center"> <tr> <th scope="col">er_id</th> <th scope="col">s_id</th> <th scope="col">ex_id</th> <th scope="col">c_id</th> <th scope="col">questionnum</th> <th scope="col">answer</th> <th scope="col">score</th> <th scope="col">total</th> <th scope="col">scoretotal</th> <th scope="col">0</th> </tr> <? $sql_show = "select * from exam_results where s_id='4' and ex_id='T3' order by er_id"; $result_show = mysql_query($sql_show) or die(mysql_error()); while($row_show = mysql_fetch_array($result_show)) { ?> <tr> <td><?=$row_show['er_id']?> </td> <td><?=$row_show['s_id']?> </td> <td><?=$row_show['ex_id']?> </td> <td><?=$row_show['c_id']?> </td> <td><?=$row_show['questionnum']?> </td> <td><?=$row_show['answers']?> </td> <td><?=$row_show['score']?> </td> <td><?=$row_show['total']?> </td> <td><?=$row_show['scoretotal']?> </td> <td><a href="edit.php?edit_id=<?=$row_show['t_id']?>" >แก้ไข</a></td> <td><a href="del.php?del_id=<?=$row_show['t_id']?>" onClick="return confirm('ยืนยันการลบ?');" >ลบ</a></td> </tr> <? $t1=$row_show["score"]; $t1=$t1+$t1; echo "$t1</br>"; $t1++; } ?> </table>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
