PHP Codeigniter调用未定义的方法CI_DB_sqlsrv_driver :: result（） [英] PHP Codeigniter Call to undefined method CI_DB_sqlsrv_driver::result()

问题描述

我已将SQL Server 2014与CodeIgniter连接。但是当我运行查询时，它给出了该错误。

I have Connected SQL Server 2014 with CodeIgniter. but when I run a query it gives that error.

这是给出错误的代码。

 function index()
  {
    $this->form_validation->set_rules('username', 'Username','required');
    $this->form_validation->set_rules('password', 'Password','required');
    if($this->form_validation->run() == TRUE)
    {
        $username = $_POST['username'];
        $password = $_POST['password'];
        $this->db->select('*');
        $this->db->from('student');
        $this->db->where(array('student_id'=>$username,'password'=>$password));
        $query = $this->db->get();
        $data = $this->db->result();
        if($data)
        {
          echo "<pre> ";
          print_r($data);
        }
    }
  $this->login('login');
  }
}

错误是

致命错误：调用
中未定义的方法CI_DB_sqlsrv_driver :: result（）D：DXampp\htdocs\CI_Portal\application\models＼第14行上的＼my_model.php

Fatal error: Call to undefined method CI_DB_sqlsrv_driver::result() in D:\Xampp\htdocs\CI_Portal\application\models\my_model.php on line 14

推荐答案

尝试更改 $ this-> db-> result（）; 为 $ query-> result（）;

$this->db->select('*');
$this->db->from('student');
$this->db->where(array('student_id' => $username, 'password' => $password));
$query = $this->db->get();
$data = $query->result();

在实际获得表结果之后，结果资源就存在了。

The result resource is there after you actually get the table results.

或者您可以将其用作：

$data = $this->db->get()->result();

这篇关于PHP Codeigniter调用未定义的方法CI_DB_sqlsrv_driver :: result（）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！