2 回答

TA貢獻1788條經驗 獲得超4個贊
打印 $select。是否有獲取數據數組
if(is_array($select)){
foreach ($select as $val)
{
$val = trim($val);
if ($val !== '')
{
$this->qb_select[] = $val;
$this->qb_no_escape[] = $escape;
if ($this->qb_caching === TRUE)
{
$this->qb_cache_select[] = $val;
$this->qb_cache_exists[] = 'select';
$this->qb_cache_no_escape[] = $escape;
}
}
}
}

TA貢獻1836條經驗 獲得超5個贊
您的查詢有誤。您可以將登錄功能替換如下。
function login($patient_ext_id,$birth_dttm) {
$this->db->select('xocp_ehr_patient.patient_ext_id, xocp_persons.person_nm, xocp_persons.birthplace, xocp_persons.birth_dttm, xocp_persons.status_cd, xocp_persons.race_nm');
$this->db->from('xocp_ehr_patient');
$this->db->join('xocp_persons', 'xocp_ehr_patient.person_id = xocp_persons.person_id');
/*$this->db->join("xocp_persons","xocp_persons.person_id = xocp_ehr_patient.patient_ext_id","left");*/
$this->db->where('xocp_ehr_patient.patient_ext_id', $patient_ext_id);
$this->db->having("DATE_FORMAT( xocp_persons.birth_dttm, '%Y-%m-%d') = '$birth_dttm'", "",false);
/*$query = $this->db->get('xocp_persons');*/
$query = $this->db->get('');
return $query->num_rows();
}
- 2 回答
- 0 關注
- 194 瀏覽
添加回答
舉報