I’m getting this error while running the program
An uncaught Exception was encountered
Type: TypeError
Message: Cannot access offset of type string on string
Filename: C:xampphtdocseditapplicationviewsfmh_index.php
Line Number: 201
This is where the error line
foreach (['data'] as $value) {
$columnFab[] = array('label'=>$value['Year'], 'y'=>$value['Fabrikasi']);
$columnInst[] = array('label'=>$value['Year'], 'y'=>$value['Instalasi']);
$columnMain[] = array('label'=>$value['Year'], 'y'=>$value['Maintenance']);
$columnPro[] = array('label'=>$value['Year'], 'y'=>$value['Project']);
}
and this is where ‘data’ came from:
public function getValuecategoriesChart($yearstart,$yearend){
$query = "select Year
, sum(case when JobCategories = 'FABRIKASI' then Amount else 0 end) as Fabrikasi
, sum(case when JobCategories = 'MAINTENANCE' then Amount else 0 end) as Maintenance
, sum(case when JobCategories = 'INSTALASI' then Amount else 0 end) as Instalasi
, sum(case when JobCategories = 'PROJECT' then Amount else 0 end) as Project
from tb_fmh_sales
where year >= {$yearstart} and year <= {$yearend}
group by Year
Order by Year";
// Die($query);
$data = $this->db->query($query);
$output=array(
'data' => $data,
);
return $output;
}