//連接數據庫
$link = mysqli_connect("localhost", "root", "123456", "test") 
or die("連接失敗" . mysqli_connect_error());
//接收學生提交的答案
$ans1 = $_GET['ans1'];
$ans2 = $_GET['ans2'];
...
//查詢正確答案
$sql = "SELECT * FROM question WHERE id=1";
$res = mysqli_query($link, $sql);
$row = mysqli_fetch_assoc($res);
$std_ans1 = $row['answer'];
//計算成績
$score = 0;
if($ans1 == $std_ans1) {
$score++;
}
if($ans2 == $std_ans2) {
$score++;
}
...
//將成績存儲入數據庫
$sql = "INSERT INTO result (id, name, score) VALUES ('', '張三', '$score')";
mysqli_query($link, $sql);