result_array值未显示在编码器点火器的 foreach 循环中

Question

我只是使用 Codeigniter 触发一个选择查询，当我使用 print_r 函数时显示所有值但是当我使用循环时foreach没有值显示我不知道问题是什么？如何解决此问题？

$this->db->select('*');
    $this->db->from('user_detail');
    $where = "jid='".$jid_final."' and cid='".$cid_final."' and offer='1'";
    $this->db->where($where);
    $sql_user = $this->db->get();
    $result_user = $sql_user->result_array();
    print_r($result_user);
    foreach($result_user as $row_user)
    {
        $user_data = '<tr>
                        <td class="td">'.$row_user['uid'].'</td>
                        <td class="td">'.$row_user['fname'].' '.$row_user['lname'].'</td>
                        <td class="td">'.$row_user['email'].'</td>
                        <td class="td">'.$row_user['phone'].'</td>
                    </tr>';
    }
    echo $user_data;

谢谢

Answer 1

使用 Under 查询，需要检查表中的数据是否，然后将其传递给 foreach 循环。

 $user_data = '';
 $this->db->select('*');
    $where = "jid='".$jid_final."' and cid='".$cid_final."' and offer='1'";
    $this->db->where($where, NULL, FALSE);
    $result_user = $this->db->get('user_detail')->result_array();
    if($result_user) {
    foreach($result_user as $row_user)
    {
        $user_data .= '<tr>
                        <td class="td">'.$row_user['uid'].'</td>
                        <td class="td">'.$row_user['fname'].' '.$row_user['lname'].'</td>
                        <td class="td">'.$row_user['email'].'</td>
                        <td class="td">'.$row_user['phone'].'</td>
                    </tr>';
    }
     echo $user_data;
    } else {
     echo "no data found";
    }

Answer 2

尝试将

值与.连接

起来

$user_data = '';
if(isseet($result_user) && count($result_user) > 0){
foreach($result_user as $row_user)
{
    $user_data .= '<tr>
                    <td class="td">'.$row_user['uid'].'</td>
                    <td class="td">'.$row_user['fname'].' '.$row_user['lname'].'</td>
                    <td class="td">'.$row_user['email'].'</td>
                    <td class="td">'.$row_user['phone'].'</td>
                </tr>';
}
    echo $user_data;
}else{
    echo 'Record not found';
}