为什么codeigniter在我的行上有记录时返回false？

Question

why codeingiter is returning me null in this case null means false because I havent any record on the tabl, when I have records on my table. i'm new using this framework. I just want to display all my user with their passwords and type of user. by the way i'm creating a multi user login.

class Login extends CI_Controller {
    public function __construct(){
        parent::__construct();
        $this->load->model('User_model');
    }

    public function index(){
            $data['module'] = "Home";
            $this->load->view('header',$data);
            $this->load->view('login');
    }

    public function getAccess(){
        $username = $this->input->post('username');
        $password = $this->input->post('password');
        $array = $this->User_model->login($username,$password);
        echo json_encode($array);
    } 

    public function logout(){
        $this->session->sess_destroy();
        redirect('login');
    }
}

model

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class User_model extends CI_Model {

    public $variable;

    public function __construct(){
        parent::__construct();

    }

    public function login($username,$password){
        $query = $this->db->query("SELECT iduser,name,last_name,username,password,typeuser_idtypeuser from user INNER JOIN typeuser ON user.typeuser_idtypeuser = typeuser.idtypeuser WHERE username = '$username' AND password = '$password'");
        if($query->num_rows() > 0){
            return $query->result_array();
        }else{
            return false;
        }
    }

}

Answer 1

Modifies the model :

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class User_model extends CI_Model {

    public $variable;

    public function __construct(){
        parent::__construct();

    }

    public function login($username,$password){
        $query = "SELECT iduser,name,last_name,username,password,typeuser_idtypeuser from user INNER JOIN typeuser ON user.typeuser_idtypeuser = typeuser.idtypeuser WHERE username = ? AND password = ? LIMIT 1";
        $query = $this->db->query($query,array($username,$password));
        if($query->num_rows() != 0){
            return $query->result_array();
        }else{
            return false;
        }
    }

}

In your Controller verifies the variable $array before the echo:

public function getAccess(){
        $username = $this->input->post('username');
        $password = $this->input->post('password');
        if($array = $this->User_model->login($username,$password)) {
        echo json_encode($array);
        } else { echo 'NO DATA!'; }
    }