Formatting Data

emcb_php

Hi,

I have got a file that looks like this:

And i want to get this into a table like this...

<table>
<tr>
<td>posts/1.html</td>
<td>Post 1</td>
<td>Elfyn</td>
<td>No Replies</td>
</tr>
<tr>
<td>posts/2.html</td>
<td>Post 2</td>
<td>Elfyn</td>
<td>No Replies</td>
</tr>
<tr>
<td>posts/3.html</td>
<td>Post 3</td>
<td>Elfyn</td>
<td>No Replies</td>
</tr>
</table>

Anyone know how?

Cheers,

Elfyn

Anon

I think I now how

read in the file a line at a time into a string variable

split that that string on the |

use the elements, in the array produced by the split, to slot into your html generation

emcb_php

Hi,

I dont know much php, do you know this in code?

Cheers,

Elfyn

amcgrath

El, try something like this, I haven't tested it or anything, so there might be some minor glictches but all in all, it should work.

$data = file("data_file.txt");

while(list(,$da) = @each($data)) {
$line_array = explode("|",$da);
echo "<tr>";
while(list(,$la) = = @each($line_array)) {
echo "<td>$la</td>";
}
echo "</tr>";
}

amcgrath

And, if it works and you use it, see if you can explain what's going on (considering your post to james, giving you a fish is one thing, teaching you to fish is quite another)...

Anon

I don't have alot of time but I'll try to give you some pointers

first of all look at php.net for more info on how to use these functions

use fopen to connect to your text file
ie

$f = fopen(yourfilename, "r");

put your general table html into a string

ie
$htmlout = "<table>"

then start a while loop

while (!feof($f)){

in this loop use

$buffer = fgets($f, 128);

to read in the first line

then split $buffer into an array

$buffsplit = split("|", $buffer);

ok so $buffsplit contains your data

ie
$buffsplit[0] = "posts/.html"
$buffsplit[1] = "Post "

now do a string to add this to your $htmlout string from before

ie
$htmlout .="<tr><td>".$buffsplit[0]."</td>td>".$buffsplit[1]."</td><td>".$buffsplit[2]."</td><td>".$buffsplit[3]."</td></tr>";

this should all be on one line of code

end your while loop here
}

echo your $htmlout string to show your results

phew!!

hoepfully this will work