Detect the change of line in a TXT file

[lordecax]

Hello everybody!

My problem start whit a xls file that i'm have to read and send the values to a mysql DB, well i'm convert the xls file to a csv file and i'm build some code to select the data and display it befor send it to the DB, my problem is the end of the line...

That becouse each converted "cell" is separeted whit ":" but when change the line no : is given or other charater, so i'm don't know how to detect the end of the line... 🙁

the code I'm using is this one:

<?php
$fo=fopen("teste.csv",r) or die ("deu erro!");
//$cont=1;
while (!feof($fo))
{
	$letra=fgetc($fo);
	//$cont ++;
	//$letra[$cont]=fgetc($fo);
	if ($letra=="\n")
	{
	echo "mudou de linha";
	}
	if ($letra<>":")
	{
		echo "<p>".$letra."</p>";
		$palavra .=$letra;
	}
	else
	{
		echo "</br><p>esta é a palavra ".$palavra."</p></br>";
		//$cont=1;
		$palavra="";
	}
}
fclose($fo);
?>

Well thanks everyone and i'm accept code changes!

see you

[tsinka]

Hi,

what about using the php file() function on that csv file ?

file reads the file and fetches the contents into an array representing the lines.

You can then walk through the array and do whatever you like.
If the file is rather big then you might run in troubles if you've got not very much memory in your server.

In this case I'd suggest not to use fgetc but e.g. fgets.

http://www.php.net/manual/en/function.fgets.php