php - 数据库返回我最后一个 id

Question

我想在 tcpdf 中显示表中的所有数据，但是这段代码返回了我最后一个 id。

$students = $this->db->get_where('enroll', array(
    'class_id' => $class_id , 
    'year' => $running_year
))->result_array();

foreach($students as $row):

    $id = $this->db->get_where('student', array(
        'student_id' => $row['student_id']
    ))->row()->student_id;

    $nume = $this->db->get_where('student', array(
        'student_id' => $row['student_id']
    ))->row()->name;

endforeach; 

$html =<<<EOD
$id <br/>
$nume
<br/>

我希望查看

id1
name1
id2
name2

... 显示最后一个 id 但从第一个到倒数第二个不显示。我在下面提供的代码在 PHP 中运行良好。

<?php                  
$students = $this->db->get_where('enroll' , array(
    'class_id' => $class_id , 
    'year' => $running_year
))->result_array();

foreach($students as $row):
?>

<tr>
<th class="stil">
<?php echo $count++;?></th>
<td class="stil"><?php 
echo $this->db->get_where('student' , array(
    'student_id' => $row['student_id']
))->row()->student_id;
?></td>

PHP 生成一个带有一些结果的页面。

标签： phphtmlcodeignitertcpdf