Results page 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

I will assume that you have one record per line with fields separated by a "|"

If you want to display the data in an html table you could do

<?php

$londonStationFile = "../activeData/".$londonStation.".txt";
//Put contents an an array
$file = file($londonStationFile);

print'<table>';
while (list($key,$val) = each ($file)) {
$data = explode("|", $val);
print '<tr>';
for ($i=0;$i<count($data);$i++) {
printf('<td>%s</td>', $data[$i]);
}

print '</tr>';
}
print '</table>';

Anon

Thanks Louie that works brilliantly...

Cheers!

Anon

Is there any way to get more control over the formatting as I will need to hide some of the fields and one is a url which will need formatting with the apprpriate HTML in order to work...?

Anon

Is there any way to get more control over the formatting as I will need to hide some of the fields and one is a url which will need formatting with the apprpriate HTML in order to work...?

Anon

Tony I will assume that you know the format of the text file that is to say that you know what fields lie with in which pipes.
so $data[0] is the first element and $data[1] is the second and so on....
Just take the for loop out and manually create each ceel with the data you want to show like so:

<?php

$londonStationFile = "../activeData/".$londonStation.".txt";
//Put contents an an array
$file = file($londonStationFile);

print'<table>';
while (list($key,$val) = each ($file)) {
$data = explode("|", $val);
print '<tr>';
printf('<td>%s</td>', $data[0]);
printf('<td>%s</td>', $data[1]);
printf('<td><a href="%s">%s</a></td>', $data[3], $data[3]);

print '</tr>';
}
print '</table>';

Anon

Louie - that is absolutely beautiful...!

Cheers.