如何制作一个表单,选择问题并将答案保存到数据库中

我正在制作一个从数据库中提出问题和答案的表单,我有几个问题,但我想在每个页面上回答一个问题,然后转到下一个问题.我怎么能做到这一点？我需要一些提示.

我带来问题和答案的代码如下所示:

echo "
";
	$sql= "SELECT pid, qid, question_link FROM question  ORDER BY qid ASC LIMIT 1";

$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_array()) {
	$pid1= $row['pid'];
	$qid1= $row['qid'];
	
	echo $row['question_link']."
";
	}
 
}

	$sql1= "SELECT pid, qid, aid, answer, points FROM answer_det WHERE pid=$pid1 AND qid=$qid1";

$result1 = $mysqli->query($sql1);

if ($result1->num_rows > 0) {
    while($row = $result1->fetch_array()) {
		$answer= $row['answer'];
		$aid= $row['aid'];
	echo "".$answer."
";
	}
 
}

echo "
";