Export Mysql Data to CSV File in Codeigniter

Controllers :

public function exportCSV(){
     
        $myData = $this->Home_model->getexportCSV();

        // file name
        $filename = 'User_Data'.date('Ymd').'.csv';
        header("Content-Description: File Transfer");
        header("Content-Disposition: attachment; filename=$filename");
        header("Content-Type: application/csv; ");

        // file creation
        $file = fopen('php://output', 'w');

        $header = array("Mobile","Name");
        fputcsv($file, $header);

        foreach ($myData as $line){
            fputcsv($file,array($line->mobile,$line->name));
        }

        fclose($file);
        exit;
    }




Model :


public function getexportCSV(){
$sql=$this->db->query(" SELECT * FROM  `user`   ");
return $sql->result();

}