如何在codeigniter中向csv添加静态值


How to add static value to csv in codeigniter

我正在尝试将静态值添加到codeigniter中的csv中,我正在从数据库中获取查询,但我需要在csv中添加一个静态值,可以添加吗?

$searchtimesheet = $this->db->query('SELECT  ohrm_project.name AS ohrm_projectname, TIME_FORMAT(SEC_TO_TIME(ohrm_timesheet_item.duration),"%Hh %im") as duration  ,ohrm_timesheet_item.date AS date,concat(hs_hr_employee.emp_firstname," ",hs_hr_employee.emp_middle_name," ", hs_hr_employee.emp_lastname) as employeename FROM ohrm_project,ohrm_timesheet_item,hs_hr_employee WHERE  ohrm_timesheet_item.employee_id=hs_hr_employee.employee_id AND ohrm_timesheet_item.project_id=ohrm_project.project_id AND ohrm_project.project_id='.$projectid.' AND ohrm_timesheet_item.date BETWEEN '.$todate1.' AND '.$fromdate1.'');
        $this->load->dbutil();
$this->load->helper('download');
$this->load->helper('file');
$delimiter = ",";
$newline = "'r'n";
$filename = 'projectimesheet.csv';
if($searchtimesheet->num_rows() >0)
{
$totalduration1=$totalduration;  //i want to append this static value to $this->dbutil->csv_from_result
    echo $data = $this->dbutil->csv_from_result($searchtimesheet,$delimiter, $newline);
    exit;
    force_download($filename, $data);
}

您可以将$totalduration变量值附加到结果中,如下所示:

echo $this->dbutil->csv_from_result($searchtimesheet, $delimiter, $newline) . $totalduration;

注意:$totalduration变量应该包含与结果中相同的CSV数据字符串,以获得有效的CSV。