Creating an Excel download |
In my app I have a function to create an excel download from the database. I do this using a controller, a helper and a model
Here is my controller, Excel.php PHP Code: public function export_to_excel() Here is my helper, excel_helper.php PHP Code: function create_excel_export() Here is my model, Users_model.php PHP Code: public function find_users(){ While running this does cause an excel file to be downloaded as expected - the browser console report an error - 'Failed to load resource: Frame load interrupted' I have modified my controller by adding this but it makes no difference Code: header("Pragma: public"); Has anyone ever seen anything like this? I am using Safari on Mac OSX
Try setting this and see if it works.
Code: header("Content-Length: 177998"); // you might want to set this What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
Tried this and no joy unfortunately. It appears to be a Safari issue as it works on other browsers.
This issue is widely reported on Google but no one has a solution for it. :-(
i'm really new to how this all works. I can read PHP to just a basic level but I heard using codeigniter will help me develop my apps faster, using your code I edited it to the fields in my database. I am lost on how to get the code to execute?
regular PHP you can create a button and link it to the PHP file, I tried that on CI using <button type="button" class="btn btn-success" onclick="<?php echo base_url()?>controller/excel">Export</button> but the button doesn't do anything. Please Help
The html onclick is for executing a javascript function.
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
Instead of the onclick event use a anchor <a> tag or CI anchor url_helper and set the ref to your controller and method.
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
If you are just trying to create a spreadsheet download, consider PHP's built in functions:
http://php.net/manual/en/function.fputcsv.php Code: <?php I make quite a few CSV files using code similar to this. |
Welcome Guest, Not a member yet? Register Sign In |