Undefined variable: total_user in codeigniter

Question

I tried to count the amount of data in the manajemen_user table using num_row() in codeigniter.

here my table(manajemen_user):

id|nama|username|email|password|jabatan
1|Admin|admin|[email protected]|123|Administrator

here my controller :

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Statistik extends CI_Controller
{
    public function index()
    {
        //load model
        $this->load->model('statistik_model');
        $data = array();
        $data['jumlah_user'] = $this->statistik_model->total_rows();

        //load view
        $this->load->view('backend/index',$data);
    }
}

here my model

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

class Statistik_model extends CI_Model
{
    function total_rows() {
        $query = $this->db->get('manajemen_user');
        return $query->num_rows();
  }
}

and here my view :

<div class="col-lg-3 col-xs-6">
          <?php foreach ($jumlah_user as $total_user):?>
          <!-- small box -->
          <div class="small-box bg-yellow">
            <div class="inner">
              <h3><?php echo $total_user ?></h3>

              <p>Jumlah User</p>
            </div>
            <div class="icon">
              <i class="ion ion-person-add"></i>
            </div>
            <a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
          <?php endforeach; ?>
        </div>

but i have an error like this in my view.

Message: Undefined variable: jumlah_user

Message: Invalid argument supplied for foreach()

I do not know where the mistake is. sorry i am new in codeigniter. can anyone help me? Thank you.

Are you sure you have some records in manajemen_user table? I think you must check that $jumlah_user is_array and then use it in foreach. — ramin ashrafimanesh
– ramin ashrafimanesh, Commented Oct 12, 2019 at 7:58

Mukesh Yadav · Accepted Answer · 2019-10-12 08:00:29Z

0

Controller

function index() {
    //load model
    $this -> load -> model('statistik_model');
    $data = array();
    $data['jumlah_user'] = $this -> statistik_model -> total_rows();

    //load view
    $this -> load -> view('backend/index', $data);
}

MOdel

class Statistik_model extends CI_Model
{
    function total_rows() {
        $this-> db -> select("count(id) as total_count")->get('manajemen_user')->row()->total_count;
  }
}

View

<div class="col-lg-3 col-xs-6">

          <!-- small box -->
          <div class="small-box bg-yellow">
            <div class="inner">
              <h3><?php echo $jumlah_user ?></h3>

              <p>Jumlah User</p>
            </div>
            <div class="icon">
              <i class="ion ion-person-add"></i>
            </div>
            <a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>

        </div>

answered Oct 12, 2019 at 8:00

Mukesh Yadav

1016 bronze badges

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

1 Comment

Mukesh Yadav Over a year ago

You are making a mistake in $jumlah_user variable , As $jumlah_user have number value not the array of results.

Buddhimal Gunasekara · Accepted Answer · 2019-10-12 18:22:24Z

0

No need to use foreach. Just use

echo $jumlah_user

In Codeigniter, if you passing a database result set that has more than one record, then you need to use foreach to fetch data as row-wise.

foreach(return_data->result() as $result){
  echo $result->column_name;
}

If there are only one record, you can access it as follows.

echo $return_data->row()->column_name

If you return a single value from your controller to your view, you can directly access it by variable name.

edited Oct 12, 2019 at 18:22

answered Oct 12, 2019 at 18:13

Buddhimal Gunasekara

761 silver badge6 bronze badges

Collectives™ on Stack Overflow

Undefined variable: total_user in codeigniter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related