Message: Undefined property: CI_DB_mysqli_result::$level

Question

I have a difficulty on my program. The error say :

A PHP Error was encountered

Severity: Notice

Message: Undefined property: CI_DB_mysqli_result::$level

Filename: controllers/Auth.php

Line Number: 30

Backtrace:

File: C:\xampp\htdocs\PKLTelkom\Telkom2\application\controllers\Auth.php Line: 30 Function: _error_handler

File: C:\xampp\htdocs\PKLTelkom\Telkom2\index.php Line: 315 Function: require_once

Here's my controller named "Auth" :

<?php
/**
* 
*/
class Auth extends CI_Controller
{

    function __construct()
    {
        parent::__construct();
        $this->load->model('m_login');

    }

    public function index()
    {
        $this->load->view("login");
    }

    public function AksiLogin()
    {
        $username = $this->input->post('username');
        $password = $this->input->post('password');
        $passwordx = md5($password);
        $login = $this->m_login->data_login($username, $passwordx);
        $tes = count($login);
        if ($tes > 0) {
            //ambil detail data
            $row = $this->m_login->data_login($username, $passwordx);
            $level = $row->level;
            //daftarkan session
            $data_session = array('level' => $level);
            $this->session->set_userdata($data_session);
            //direct page
            if ($level == 'superadmin') {
                redirect('superadmin');
            }
            else if ($level == 'admin') {
                redirect('admin');
            }

        }
        else {
            $this->index();
        }
    }

    public function logout()
    {
        $this->session->unset_userdata("login");
        $this->session->unset_userdata("username");
        redirect ('index.php/auth');
    }
    }
?>

Here's my models named "M_Login" :

<?php
class M_login extends CI_Model
{

function data_login($username, $password)
{
 $this->db->where('username', $username);
 $this->db->where('password', $password);
 return $this->db->get('akun');
}
}
?>

Line 30 $level = $row->level;. You're not returning level in your query. — ourmandave
– ourmandave, Commented Dec 8, 2017 at 12:53

Hasta Dhana · Accepted Answer · 2017-12-08 13:28:14Z

1

Looks like your return $this->db->get('akun'); on "M_login" model doesn't return object with the name level.

Try changing this line on "M_Login" model :

<?php
class M_login extends CI_Model
{

function data_login($username, $password)
{
$this->db->where('username', $username);
$this->db->where('password', $password);
return $this->db->get('akun')->row(); // change this line
}
}
?>

edited Dec 8, 2017 at 13:28

answered Dec 8, 2017 at 13:15

Hasta Dhana

4,7047 gold badges21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Message: Undefined property: CI_DB_mysqli_result::$level

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related