Removing New line character in Fields PHP

Posted by Aruna on Stack Overflow See other posts from Stack Overflow or by Aruna
Published on 2010-03-16T04:41:54Z Indexed on 2010/03/16 5:06 UTC
Read the original article Hit count: 447

Filed under:
|

Hi,

i am trying to upload an excel file and to store its contents in the Mysql database.

i am having a problem in saving the contents.. like

My csv file is in the form of

"1","aruna","IEEE paper" "2","nisha","JOurnal magazine"

actually i am having 2 records and i am using the code

<?php
  $string = file_get_contents( $_FILES["file"]["tmp_name"] );
  //echo $string;

foreach ( explode( "\n", $string ) as $userString )

    {
                 echo $userString;

            }

?> since in the Csv record there is a new line inserted in between IEEE and paper it is dispaying me as 3 records..

How to remove this new line code wise and to modify the code so that only the new line between the records 1 and 2 is considered... Pls help me....

© Stack Overflow or respective owner

Related posts about php5

Related posts about cakephp