mysql - Codeigniter 中的 fetch_row 替代方案

Question

我如何在 Codeigniter 中获得它？如果我尝试使用相同的方法，它会显示 fatal error :非对象 'fetch_row'，请帮助我在 codeigniter 中为 fetch_row 使用替代方法。

$sql = "SELECT DISTINCT attnDate 
        FROM tbl_attendance
        ORDER BY attnDate";
$res = $g_link->query($sql);   // mysqli query

while ($row = $res->fetch_row()) {
    $dates[] = $row[0];
}

获取 $dates 如下:

Array
(
    [0] => 2015-11-25
    [1] => 2015-11-29
    [2] => 2015-11-30
    [3] => 2015-12-01
    [4] => 2015-12-02
    [5] => 2015-12-03
    [6] => 2015-12-05
    [7] => 2015-12-06
    [8] => 2015-12-07
    [9] => 2015-12-08
    [10] => 2015-12-09
    [11] => 2015-12-10
    [12] => 2015-12-12
)

当我在 codeigniter 中尝试时:型号:

public function raw_attendance_Status(){
        $this->db->distinct();
        $this->db->select('attnDate');
        $this->db->from('tbl_attendance');
        $this->db->order_by('attnDate');
        $query = $this->db->get();
        return $query->result();
    }

Controller :

public function rawAttendance(){
        $data['date1'] = $this->AttendanceModel->raw_attendance_Status();
        $this->load->view('attendance/rawAttendance', $data);
      }

Answer 1

我想使用 result_array() 可以为您做到这一点!

 $this->db->distinct();
 $this->db->select('attnDate');
 $this->db->from('tbl_attendance');
 $this->db->order_by('attnDate');
 $query = $this->db->get();
 return $query->result_array();