doubingqi5829 2018-10-25 04:55
浏览 110
已采纳

PHP Codeigniter调用未定义的方法CI_DB_sqlsrv_driver :: result()

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

This is the code which gives an 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');
  }
}

The Error is

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

  • 写回答

1条回答 默认 最新

  • douba6361 2018-10-25 07:55
    关注

    Try be changing $this->db->result(); as $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.

    Or you can use it as:

    $data = $this->db->get()->result();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 编写vba代码实现数据录入工作
  • ¥15 做过TCL海信电视小米电视相关影视会员软件私我
  • ¥15 Mapreduce是正常的,在运行其他jar包时并没有任何问题,只是在做LogCount.jar 时出的问题。如图所示
  • ¥15 ImportError: DLL load failed while importing _iterative: 找不到指定的模块。
  • ¥15 如何通过交互分析得出某高危患者对放疗获益更多
  • ¥15 相关性分析中,p<0.05, r=0.29,怎么评价相关性呢
  • ¥15 docker部署Mongodb后输入命令报错?
  • ¥15 将下列流程图转变成python程序代码
  • ¥15 我需要全国每个城市的最新小区名字等数据。
  • ¥15 开发一个小区生态的小程序