首页 > 解决方案 > 如何按顺序从三个嵌套的 foreach 循环中填充数据?

问题描述

我有 3 个表格“问题”、“答案”和“结果”。我想从 3 个表中一一获取多行并按顺序显示。

程序

$questions = Questions::find_by_qpno($qpno);
$answers = Answers::find_by_apno($apno);
$results = Results::find_by_rno($rno);

foreach($questions as $question) {
  echo "Question";
  echo $question->question;
}

foreach($answers as $answer) {
  echo "Answer";
  echo $answer->answer;
}

foreach($results as $result) {
  echo "Result";
  echo $result->remark;
}

输出

Question
What is software engineering?
Question
What are SDLC models available?

Answer
Software engineering is making softwares
Answer
Waterfall , spiral etc

Remark
It is correct Software engineering is making softwares.
Remark
good Waterfall , spiral etc correct

Question 1
Answer 1
Remark 1

Question 2
Answer 2
Remark 2

需要一种简单的方法来嵌套 3 个 foreach 循环,以便我按照问题-答案-备注的顺序得到它?

注意:我知道我可以从 SQL 查询中计算对象。把$count = count($questions). 并使用 for 循环for($i=1 ; i<=$count ; $i++)并依次遍历这三个。但它看起来很丑。

做这个的最好方式是什么 ?

标签: phploopsoopforeachnested-loops

解决方案


推荐阅读