?> '); }); </script> </head> <body> <form method="POST"> Max Score : <input type="text" name="maxScore" value="100"/><br/> Score : <input type="text" name="score" value="<?php echo $score; ?> "/><br/> Point : <input type="number" name="point"/><br/> Grade Range<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 0<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 1<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 1.5<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 2<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 2.5<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 3<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 3.5<br/> ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 4<br/> <input type="submit" name="submit"/> </form> <?php if ($submit) { echo 'Grade Cal = ' . gradeCal($min, $max, $point, $score); } ?> </body> </html>
if ($max[$i] == '' || $max[$i] == null || !isset($max[$i])) { $maxPass = false; break; } } if ($maxPass) { $maxScore = $max[7]; $strSQL = sprintf("\n SELECT\n stu.studentID,stu.firstName,stu.lastName,SUM(stusco.score) AS score\n FROM\n `studentscore` stusco RIGHT JOIN `student` stu ON stusco.studentID = stu.studentID\n WHERE\n stusco.scoreID IN\n (\n SELECT\n scoreID\n FROM\n scoreinfo\n WHERE\n subjectID = '%s' AND\n registerID =\n (\n SELECT\n registerID\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ) OR (stu.studentID IN (\n SELECT\n studentID\n FROM\n `register-student` regstu\n WHERE\n regstu.subjectID = '%s' AND\n regstu.registerID =\n (\n SELECT\n registerID\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ) AND stusco.subjectID IS NULL\n )\n GROUP BY\n studentID\n ", mysql_real_escape_string($subjectID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()), mysql_real_escape_string($subjectID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()), mysql_real_escape_string($subjectID)); $objQuery = mysql_query($strSQL); if ($objQuery && mysql_num_rows($objQuery)) { while ($row = mysql_fetch_assoc($objQuery)) { $preData = $row; if ($row['score'] == '') { $preData['score'] = 0; } $grade = gradeCal(0, $max, 0, $row['score']); $select = '<select name="grade" style="width: 80px;">'; // $select.= '<option value="">--</option>'; $select .= '<option value="' . $grade . '" selected>' . $grade . '</option>'; $select .= '<option value="W">W</option>'; $select .= '</select>'; $preData['grade'] = '<input type="hidden" name="studentID" value="' . $row['studentID'] . '">' . $select; $preData['score'] = $preData['score'] . '/' . $maxScore; $return['data'][] = $preData; } $return['status'] = 'SUCCESS'; } else { $return['status'] = 'FAIL'; $return['strSQL'] = $strSQL; } } else {
durningScore => $confDurningScore, midScore => $confMidScore, finalScore => $confFinalScore ); // Sample Data Generator Begin for($i=0;$i<7;$i++){ $predata['subjectID'] = 'ท99999'; $predata['subjectName'] = 'ทดสอบรายวิชา'; $predata['hour'] = '99'; $predata['weight'] = '9.9'; $predata['durningScore'] = rand(0,60); $predata['midScore'] = rand(0,20); $predata['totalDurningScore'] = $predata['durningScore']+$predata['midScore']; $predata['finalScore'] = rand(0,20); $predata['totalScore'] = $predata['totalDurningScore']+$predata['finalScore']; $predata['grade'] = gradeCal(NULL, array(50,55,60,65,70,75,80,100), '0', $predata['totalScore']); $predata['beg'] = $predata['grade']=='0'?'<input type="text" value="1" />':''; $dataInfoExtra[] = $predata; } // Sample Data Generator End function genData($data){ $res = ''; foreach ($data as $val){ $res.= "<tr>"; $res.= '<td class="lefttext">'.$val['subjectID']."</td>"; $res.= '<td class="lefttext">'.$val['subjectName']."</td>"; $res.= "<td>".$val['hour']."</td>"; $res.= "<td>".$val['weight']."</td>"; $res.= "<td>".$val['durningScore']."</td>"; $res.= "<td>".$val['midScore']."</td>"; $res.= "<td>".$val['totalDurningScore']."</td>";