将数据库结果转换为Codeigniter中的数组 [英] converting database result into array in codeigniter

问题描述

我是Codeigniter的新手，我正在尝试制作一个具有admin，主持人和用户角色的登录身份验证系统.

I am new to codeigniter and I am trying to make a login authentication system with the role of admin, moderator, and user.

我的问题是我试图在数据库中的列角色"上设置一个条件.但是我不知道如何使用和比较列角色的价值.

My problem is that I am trying to set a condition on 'role' which is a column in database. But I don't know how to use and compare the value of column role.

我编写了以下代码，但出现错误:

I wrote the following code but I am getting error:

[严重性:错误消息:调用数组中的成员函数result_array()]

[Severity: Error Message: Call to a member function result_array() on array]

我的代码是:

<?php
// step no 4 create a new controller where form post after submission.
class verify extends CI_Controller{
     function __construct(){
        parent::__construct();
         $this->load->helper('url');
         $this->load->model('user');
     }
    function login(){
        //step no 5 create a new method in verify controller 
     
       $username = $this->input->post('username');
       $userpass = $this->input->post('password');
       //step 9 take value back in answer variable from model and print message 
      $answer = $this->user->usergetdata($username,$userpass,'admin');   
     $data = $answer->result_array();


        if($answer){
            if($data[0]['role']=='admin'){
              redirect('admin_page');  
            }
            
            
        }else
        {
            echo "username or Password is wrong";
        }
    }
    
}

?>

<!-- begin snippet: js hide: false console: true babel: false -->

推荐答案

模型中

$res = $this->db->get(); 
return $res->result_array();

然后申请

foreach($answer as $a)
{
  var_dump( $a );
} 

使用 $ a 获取值

这篇关于将数据库结果转换为Codeigniter中的数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！