php - 当我在查询中使用 Union All 时，Codeigniter 返回 0 结果

Question

$sql = 'SELECT bind_id, Title, category, image_url, keyword, style_Binder_id, end_user_id, NULL AS cphoto_id, NULL AS cphoto, NULL AS title, NULL AS company_id, DATE FROM styleBinds  
UNION ALL  
SELECT NULL , NULL , NULL , NULL , keyword, style_Binder_id, end_user_id, cphoto_id, cphoto, title, company_id, date_time FROM company_photo  
ORDER BY DATE ASC';
$sql =$this->db->query($query);
if($sql->num_rows > 0){
    $result=$sql->result();
    return $result;
}else{
    echo "0 records";
}

当我在 phpmyadmin 中运行此查询时，它返回 150 个结果

但是在 codeignitor 中它返回 0 个结果...

Answer 1

简单的拼写错误问题。你颠倒了论证和分配。代码应该是

$query=$this->db->query($sql);

if($query->num_rows() > 0){
  return $query->result();
}else{
  return NULL; //controller should decide what to do with no model results
}