如何包装mysqli选择查询结果的文本



我什至不知道该问什么。

我有这个代码

$limitValue = $_POST['count'];
$type = $_POST['topic'];
$qType = join("','", $type);
$sql = "SELECT question_id, questionType, question, answerA, answerB, answerC, answerD
FROM questions
WHERE questionType IN ('$qType')
ORDER BY RAND() LIMIT $limitValue";
$result  = mysqli_query($link, $sql);
if (mysqli_num_rows($result) > 0) {
// output data from each row
while ($row = mysqli_fetch_array($result)) {
$qID = $row['question_id'];
$a = $row['answerA'];
$b = $row['answerB'];
$c = $row['answerC'];
$d = $row['answerD'];
$rA = $row['rightAnswer'];
echo "QID: " . $row["question_id"]. "<br>".
"Question Type: " . $row["questionType"]. "<br><br>" .
"Question: " . $row["question"]. "<br><br><br>";
echo "<input type = 'Radio' Name = 'Answer[$qID]' value ='A' > A. <span><span> $a &nbsp;&nbsp;rn<br><br>";
echo "<input type = 'Radio' Name = 'Answer[$qID]' value ='B' > B. <span><span> $b &nbsp;&nbsp;rn<br><br>";
echo "<input type = 'Radio' Name = 'Answer[$qID]' value ='C' > C. <span><span> $c &nbsp;&nbsp;rn<br><br>";
echo "<input type = 'Radio' Name = 'Answer[$qID]' value ='D' > D. <span><span> $d &nbsp;&nbsp;rn<br><br><br><hr>";
/* echo "A) " .$row["answerA"]. "<br>" . "B) " .$row["answerB"]. "<br>" . "C) " .$row["answerC"].  "<br>" . "D) " .$row["answerD"]. "<br><br><br>";*/
}
}
mysqli_free_result($result);
echo "<input name='submit' type='submit' value='See Results'>rn";
mysqli_close($link);
?>

当输出太长时,它会将其放在远离单选按钮的下一行。就像您在这里看到的选项 A 一样。

如何换行?

它会推送到下一行,因为您在A.旁边给出了<span><span>。 而不是<span><span>尝试&nbsp;&nbsp;. 这将为您提供不间断的空间。

问题出在数据库中。有些人将内容输入数据库,这会导致段落分隔符,(

).所以代码很好,只是数据是问题所在。感谢那些提供帮助的人。

最新更新