How to export csv file in codeigniter

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

public function export_csv() {
    $this->load->dbutil();
    $this->load->helper('file');

    $query = $this->db->query("SELECT * FROM your_table");
    $delimiter = ",";
    $newline = "
";

    $data = $this->dbutil->csv_from_result($query, $delimiter, $newline);

    // Set the file name
    $file_name = 'export.csv';

    write_file($file_name, $data);

    // Download file
    $this->load->helper('download');
    force_download($file_name, NULL);
}

1

$route['export-csv'] = 'YourController/export_csv';

1

<a href="<?php echo base_url('export-csv'); ?>">Export CSV</a>