php - 调用未定义的方法 CI_DB_mysql_driver::row_array()

Question

嘿，我是 CI 的新手，所以请原谅!我正在尝试在 codeigniter 中加入 2 个表，但我在代码中遇到了这些错误

Call to undefined method CI_DB_mysql_driver::row_array() in C:\xampp\htdocs\Hostel\application\models\payfees.php on line 16.

我的方法代码是这样的

public function payu($id,$month){
        $where = "where generatebills.student_id='".$id."' and generatebills.month='".$month."'";
                   $query =  $this->db->select('*')
                    ->from('generatebills')
                    ->join('student','student.student_id=generatebills.student_id')
                    ->where($where);
        return $query->row_array();
    }

Answer 1

不要忘记缺少的 ->get() 方法。另外，删除字符串中的 WHERE:

$where = "name='Joe' AND status='boss' OR status='active'";

http://www.codeigniter.com/userguide2/database/active_record.html

我建议改用数组:

public function payu($id,$month)
{
    // $where = "generatebills.student_id='".$id."' and generatebills.month='".$month."'";
    $where = array(
        'generatebills.student_id' => $id,
        'generatebills.month' => $month,
    );

    $query =  $this->db->select('generatebills.*')
        ->from('generatebills')
        ->join('student','student.student_id = generatebills.student_id')
        ->where($where);

    return $query->get()->row_array();
               //  ^
}