如何显示三个表的记录，而不需要查询

id_test
testName

id_quest
id_test
question

id_answer
id_quest
answer

    $this->db->select('id_test,testName,description,time,type,sum');
    $this->db->where('id_test',$idTest);
    $query['test'] = $this->db->get('tests')->result()[0];
    $this->db->select('id_quest,inquiry');
    $this->db->where('id_test',$idTest);
    $query['questions'] = $this->db->get('questions')->result();
    $i=0;
    foreach ($query['questions'] as $question) {
        $this->db->select('id_answer,response,value');
        $this->db->where('id_quest',$question->id_quest);
        $query['questions'][$i]->answer = $this->db->get('answer')->result();
        $i++;
    }
    return $query;

您可以做一个像这样更复杂的查询，这样您只需要访问数据库一次:

SELECT 
t.id_test, t.testName, t.description, t.time, t.type, t.sum,
q.id_quest, q.inquiry,
a.id_answer, a.response, a.value
FROM tests AS t
LEFT JOIN questions AS q ON q.id_test = t.id_test
LEFT JOIN answers AS a ON a.id_quest = q.id_quest
WHERE t.id_test = $idTest;

那么你的代码将看起来像这样:

<?php
// your database info here
$db_host = '';
$db_user = '';
$db_pass = '';
$db_name = '';
$con = mysqli_connect($db_host,$db_user,$db_pass,$db_name);
if($con->connect_error)
    die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
$query = "SELECT 
t.id_test, t.testName, t.description, t.time, t.type, t.sum,
q.id_quest, q.inquiry,
a.id_answer, a.response, a.value
FROM tests AS t
LEFT JOIN questions AS q ON q.id_test = t.id_test
LEFT JOIN answers AS a ON a.id_quest = q.id_quest
WHERE t.id_test = ?";
if (!$stmt = $con->prepare($query))
    die('Prepare Error: ' . $con->error);
$idTest = 2;
if (!$stmt->bind_param('i', $idTest))
    die('Bind Parameters Error ' . $stmt->error);
if (!$stmt->execute())
    die('Select Query Error ' . $stmt->error);
while ($stmt->fetch())
{
// get each resulting answer row, complete with associated question id and test id
}
$stmt->close();
$con->close();

从你的问题中我得到的是你想要加入表格。我认为你应该能够做这样的事情:

SELECT test_table.test_name,
       qestion_table.question, 
       answer_table.answers 
FROM test_table
INNER JOIN questions_table 
on questions_table.id_test = test_table.id_test
INNER JOIN answers_table
ON answers_table.id_quest = questions_table.id_quest
WHERE test_table.id_test = ?

这应该将整个结果集作为一个对象返回，而不必多次查询db。

我会完全考虑使用'where_in'而不是在你的数据库中抛出大量查询。

即. .

//...
$this->db->select('id_quest,inquiry'); 
$this->db->where('id_test',$idTest);
$query['questions'] = $this->db->get('questions')->result();
$questionIds = array();
foreach($query['questions'] as $question)
     $questionIds[] = $question->id_quest;
$this->db->select('id_answer,response,value');
$this->db->where_in('id_quest', $questionIds);
$answers = $this->db->get('answer')->result();
$i=0; // <<< Idk what the main purpose of this is, 
      //     but you do know you can simply use '[]' appending to an array, right?
foreach ($answers as $answer) {
    $query['questions'][$i]->answer = $answer;
    $i++;
}

如果性能仍然是一个主要问题。研究一下缓存。CodeIgniter支持得很好。

https://www.codeigniter.com/userguide3/libraries/caching.html

p。还要查看CI中的join命令。https://www.codeigniter.com/userguide2/database/active_record.html