PHP函数来自两个表的两个循环

乔治

我有两张桌子,一张是问题,一张是答案。我想知道我是否可以通过一个函数来抓取和回应它们。所以基本上循环遍历问题并回显问题+答案。

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] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章