Welcome Guest, Not a member yet? Register   Sign In
Export database data into different columns of a csv file
#1

[eluser]ethereal1m[/eluser]
Dear all,
I want to export data from database into a csv file using the following code:
Code:
function export()
  {
  
  $this->load->dbutil();
  $this->db->order_by('id','asc');
  $query = $this->db->get('some_table');
  $enclosure = '';
  $delimiter = ",";
  $newline = "\r\n";
  $data = $this->dbutil->csv_from_result($query,$delimiter,$newline,$enclosure);
  
   if ( ! write_file('my_directory\data.csv', $data))
   {
    echo 'Unable to write the file';
   }
   else
   {
    echo 'File written!';
   }
  }
Basically it uses csv_from_result to create the layout and later it is written to a file using write_file. I delimit each column with comma (,) and each row with carriage return. However when I open the file from Excel, each column is separated by comma and placed into one cell of Excel instead of different cells. Like this:

How can I make so that they are in different cells? What should I used for the arguments?

regards,
ethereal1m


Messages In This Thread
Export database data into different columns of a csv file - by El Forum - 04-09-2012, 08:27 PM



Theme © iAndrew 2016 - Forum software by © MyBB