Fatal error: Call to undefined method CI

Hi guys, I'm having this problem when trying to generate an excel file with the data that is displayed on the screen. Clicking will show this error.

Fatal error: Call to undefined method CI_DB_mysql_utility::csv_from_array() in C:\wamp64\www\application\controllers\fluxo_caixa.php on line 259

help? 

Have you loaded the database libary in the controller. Or even autoload it in the config file?

On the package it said needs Windows 7 or better. So I installed Linux.

Hi guys, I'm having this problem when trying to generate an excel file with the data that is displayed on the screen. Clicking will show this error.

Fatal error: Call to undefined method CI_DB_mysql_utility::csv_from_array() in C:\wamp64\www\application\controllers\fluxo_caixa.php on line 259

help? 

csv_from_array() has never existed in CodeIgniter. I don't know where you got that from.

Have you loaded the database libary in the controller. Or even autoload it in the config file?

He did, plus the extras (otherwise the error wouldn't mention CI_DB_mysql_utility)

This application is from a friend of mine, I am giving a support for it. So it is not possible to do the procedure using csv from array? What would be the right way to do the procedure? When clicking you should download the excel file with the data that was displayed on the previous screen.

Hi guys, I'm having this problem when trying to generate an excel file with the data that is displayed on the screen. Clicking will show this error.

Fatal error: Call to undefined method CI_DB_mysql_utility::csv_from_array() in C:\wamp64\www\application\controllers\fluxo_caixa.php on line 259

help? 

Try this 

Code:

$query_str="whatever your sql query maybe";
$query=$this->db->query($query_str);
$result_array = $query->result_array();
$fp = fopen('file.csv', 'w');

foreach ($result_array as $rs) {
   fputcsv($fp, $rs);
}

fclose($fp);

The snippet will get your result array and write to csv file.  Just make sure you set correct permission on 'file.csv'.  Also on query_str
if you need to pass on param within the sql statement then you need to use $this->db->escape($param), e.t.c

You can use active record method as per doc it will auto escape the param for you , how you want to write it is up to you

Regards

Maybe you intended to use the function csv_from_result().

You could combine this with the file helper to write the file.