[Resolved] convert a text file into a php html table

[byroncoolie]

Hello,

I have a query which I'm sure arises a fair bit.
I have a simple system that uploads and displays a text file via a PHP page. This is a menu page that has a) the item and b) the price.

The text file is comma delimited like so:
poached baby octopus, 16
blue eye tuna, 18
etc etc...

I wish to display this info in a two column table.
I have this:
<?
$datafile = fopen("data/home.txt","r");
$data = fread($datafile, 1000000);
list($item, $price) = explode(",",$data);
echo "<table width=640><tr>";
$menu = "<td width=600>".$item."</td><td width=40>$".$price."</td>";
//wherever line returns are change these for row ends/beginnings
$menu = str_replace(chr(10),"</td></tr><tr><td>",$menu);
echo $menu;
echo "</tr></table>";
?>

(where 'data/home.txt' is the text file source)
but it only displays one row of the data.

Can anyone help?
I'm not sure how to set up the loop structure so as to run through the whole lot of info (which could be 30 items long).

Byron

[remnant]

Replace:

$datafile = fopen("data/home.txt","r"); 
$data = fread($datafile, 1000000); 
list($item, $price) = explode(",",$data); 

with:

$datafile = "data/home.txt";
$data = file($datafile);
foreach ($data as $line) {
    $list = explode(",", $line);

// rest of code in this loop...
}

Using the file function puts the contents into an array rather than a string which is what fread does. Having it in the array makes it a little easier to parse IMO.

HTH

[byroncoolie]

Thankyou Remnant,

I appear to be getting this error when I run the page:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/httpd/vhosts/domain.com/httpdocs/delimit.php on line 2

It doesn't like this line "$data=file($datafile);
" for some reason.

Byron

[remnant]

Based on the error, it sounds like it's a problem with the first line:

$datafile = "data/home.txt";

Try moving the text file to same directory as delimit.php and change $datafile to "home.txt" just to see if it works.

I'm not really sure what could be wrong with that path though...

[byroncoolie]

Hi Remnant.

Thanks for your advice.
I tried moving the .txt file to the same directory which may have fixed the problem (but stumbled onto a new one).

Anyway, whilst fumbling around I worked this out.

This works nicely!

<?php
$lines = file('data/home.txt'); //here's the filename
?>
<table width=640>
<?php
foreach ($lines as $line) {
list($a,$b) = explode(',', $line);
print "<tr>
<td width=600>$a</td>
<td width=40>$b</td>
</tr>";
}
?>
</table>

Result =
<table>
<tr>
<td>poached baby octopus</td>
<td> 16</td>
</tr><tr>
<td>blue eye tuna</td>
<td> 18</td>
</tr><tr>
<td>grilled mussels</td>
<td> 20</td>
</tr></table>

Perfect!

regards,
Byron

:o 😃