我有两张桌子,一张是问题,一张是答案。我想知道我是否可以通过一个函数来抓取和回应它们。所以基本上循环遍历问题并回显问题+答案。
Questions
+------+-------------------------------+
| q_id | question |
+------+-------------------------------+
| 1 | What is your favorite color? |
+------+-------------------------------+
Answers
+------+------+-----------+
| a_id | q_id | answer |
+------+------+-----------+
| 1 | 1 | Green |
+------+------+-----------+
| 2 | 1 | Blue |
+------+------+-----------+
| 3 | 1 | Yellow |
+------+------+-----------+
到目前为止我所做的
function Questionaire()
{
if(!$this->DBLogin())
{
$this->HandleError("Database login failed!");
return false;
}
$result = array();
$conn = $this->connection;
$query = "SELECT * FROM `questions` WHERE status = 1";
$result = $conn->query($query);
while ($row = $result->fetch()) {
$result[] = $row['question'];
}
return $result;
}
像这样吗?
function Questionaire()
{
if(!$this->DBLogin())
{
$this->HandleError("Database login failed!");
return false;
}
$data = array();
$conn = $this->connection;
$query = "SELECT * FROM `questions` WHERE status = 1";
$result = $conn->query($query);
while ($row = $result->fetch()) {
$row['answers'] = [];
$query2 = "SELECT * FROM `answers` WHERE q_id = '$row[q_id]'";
$result2 = $conn->query($query2);
while($row2 = $result2->fetch())$row['answers'][] = $row2;
echo "Question: <pre>".var_export($row, true)."</pre>";
$data[] = $row;
}
return $data;
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句