How to export the data from php to CSV

[maheswaran]

Hi,

i have no problem in export the data from php to csv. But i have struggled to put the <br> in of csv coloumn. Here the details

PostId    PostTitle   Reply                  Ip
 
1         test        reply 1               127.0.0.1
                      reply 2
                      reply 3
 
 
2         test2       response 1            127.0.0.1
                      response 2 
 

In the above example i have export the all the data's into csv. But in "Reply" column i can not give the <br> between the reply/response. How i can separate each reply's?

[code green]

Use strip_tags()

[Markus]

As far as I know, that isn't how CSV works. You have a row with columns and each field (column) or that row can have one entry, not multiple entries as you appear to desire; you'll have to make a new entry for each reply.

[maheswaran]

strip_tags is not working for me. Here the my code

 
while ($rowr = mysql_fetch_row($values)) {
 
  for ($j=0;$j<$i;$j++) {
    $csv_output .= "\"".$rowr[$j]."\","; //Here i have generate PostId,PostTitle
 
  }
        //echo $rowr[0]."<bR>";
        $sql1='SELECT response 
        FROM  ost_ticket,ost_ticket_response
        WHERE ost_ticket.ticketID ="'.$rowr[0].'" AND ost_ticket.ticket_id=ost_ticket_response.ticket_id';
 
        $values1=mysql_query($sql1);
 
 
        while (list($response) = mysql_fetch_row($values1)) {
            //$response=strip_tags($response,"<div>");
             $csv_output1 .= "\"".$response."\"";    / Here i have created multiple response for a single post for a single column Reply- Reply should place next line or break in the same reply column                 
        }
 
 
 
 
    $csv_output .= "\"".$rowr3[$j]."\",";
 
     $csv_output .= "\n";
 
  }