can't pass data to view

Question

I'm learning codeigniter framework. I've managed to make login page work, now I'm trying to pass data from controller to my view. I'm getting errors I have looked and looked here and did as suggested still getting the errors/

Model

class Dashboard_Model extends CI_Model{ function __construct(){ parent::__construct(); } public function getTasks(){ $this->db->Select("COUNT(taskID) as totaltasks"); $this->db->from('tasks'); $query = $this->db->get(); return $query->result(); } }

Controller

class Dashboard extends CI_Controller { function __construct(){ parent::__construct(); $this->load->model('admin/dashboard_model'); } public function index(){ if(!$this->session->logged_in){ redirect('user_login'); }else{ $data['title'] = $this->session->fullname. " | Dashboard"; $this->load->view('admin/common/header',$data); $data['total'] = $this->dashboard_model->getTasks(); $this->load->view('admin/dashboard',$data); $this->load->view('admin/common/footer'); } } }

View

 <h2 class="text-white"><span data-plugin="counterup"><?php echo $total?></span> <small><i class="mdi mdi-arrow-up text-success"></i></small></h2>

Error :

Severity: Notice

Message: Array to string conversion

Filename: admin/dashboard.php

Line Number: 40

What I am doing wrong?

$this->dashboard_model->getTasks(); retunrs array not string — Jagjeet Singh
– Jagjeet Singh, Commented Nov 21, 2018 at 12:04
$this->dashboard_model->getTasks() return the list of tasks. You need to do a count($this->dashboard_model->getTasks()) or i guess there is a count method on tasks collection. — Thomas Lefetz
– Thomas Lefetz, Commented Nov 21, 2018 at 12:05
@JagjeetSingh when I echo $total['totaltasks'] I get undefined index totaltasks but when I var_dump($total)` I get array(1) { [0]=> object(stdClass)#22 (1) { ["totaltasks"]=> string(1) "4" } } — user1
– user1, Commented Nov 21, 2018 at 12:07
@ThomasLefetz getTasks() return the number of tasks as a number — user1
– user1, Commented Nov 21, 2018 at 12:08

suresh bambhaniya · Accepted Answer · 2018-11-21 12:10:51Z

result() This method returns the query result as an array of objects, or an empty array on failure update getTasks like below

public function getTasks(){ $this->db->Select("COUNT(taskID) as totaltasks"); $this->db->from('tasks'); $query = $this->db->get(); return $query->result()[0]->totaltasks; }

Mithu CN · Accepted Answer · 2018-11-21 12:25:16Z

You can use row() to get single row instead of result() when you already know that you will get one row as a result

 public function getTasks(){ $this->db->Select("COUNT(taskID) as totaltasks"); $this->db->from('tasks'); $query = $this->db->get(); return $query->row()->totaltasks; }

Collectives™ on Stack Overflow

can't pass data to view

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related