Results apge using a pipe seperated text file?

[Anon]

I need to create a page that will show the content of a pipe seperated data file. How do I go about doing this? I currently have this...:

<?php

$londonStationFile = "../activeData/".$londonStation.".txt";
$fileName = fopen($londonStationFile, "r");

while ($line = fgets($fileName,40000)) {
$data[] = explode("|",$line);
}
fclose ($fileName);

?>

But now how do I go about showing the results?

Thanks in advance...

[Anon]

Personaly I like using file() which gets the entire contents of the file into an array, one item per line. I find it much easier to use, provided the files arn't too large or memory usage isn't too big a concern.

As for showing the data it's just a simple matter of echoing it to the client, now if you want stuff like special formating then you'd have to add a few extra echo's containing the formating code but thats simple enough once you understand the basics.

<?php
$londonStationFile = "../activeData/".$londonStation.".txt";
$fileName = fopen($londonStationFile, "r");

$rows = file($fileName);

echo '<table>';
for($i=0;$i<count($data);$i++)
{
echo '<tr>

$columns = explode("|",$data[$i]);
for($h=0;$h<count($columns;$h++)
{
echo '<td>'.$columns[$h].'</td>';
}

echo '</tr>';
}
echo '</table>';
?>

I'm acutaly in the process of working on a script for a client of mine to dynamicly create tables and input the data from a pipe separated text file using MySQL so you caught me at the right time with this question.

[Anon]

I think I must have missed something as I have put your code in 'as is' and the result is an error on line 25:

echo '<td>'.$columns[$h].'</td>';

I have noticed that one line was not finished so have changed it from echo '<tr> to echo '<tr>';

Now the error is on line 23:

for($h=0;$h<count($columns;$h++)

Any ideas...?

<?php
$londonStationFile = "../activeData/".$londonStation.".txt";
$fileName = fopen($londonStationFile, "r");

$rows = file($fileName);

echo '<table>';
for($i=0;$i<count($data);$i++)
{
echo '<tr>

$columns = explode("|",$data[$i]);
for($h=0;$h<count($columns;$h++)
{
echo '<td>'.$columns[$h].'</td>';
}

echo '</tr>';
}
echo '</table>';
?>

[Anon]

Yeh, I just made too many typo's, thats what I get for typing the code directly into this bow without checking it. Had a few non-existant variables in there that I left in by acccedent, it should work now.

<?php
$londonStationFile = "../activeData/".$londonStation.".txt";
$fileName = fopen($londonStationFile, "r");

$rows = file($fileName);

echo '<table>';
for($i=0;$i<count($rows);$i++)
{
echo '<tr>';

$columns = explode("|",$rows[$i]);
for($h=0;$h<count($columns);$h++)
{
echo '<td>'.$columns[$h].'</td>';
}

echo '</tr>';
}
echo '</table>';
?>

Don't take code samples word for word from here, they are only ment for examples not for production and are prone to typo's like this. Hey, we're only human 🙂