Help with .txt file PHP page

Siggles

Hi,

I'm new to PHP although I am learning fast. I would appreciate some help. Im doing a job for someone who owns an Estate Agents and they have a website. Each day a .txt file with all the property details gets uploaded to their server to make their internal system work. They want to use this file alongside their website too so visitors can view property details on the website taken from this updated .txt file.

This is an example of the text file.

"BranchID","PropertyID","PropertyName","Street","DisplayStreet","Postcode","PricePrefix","Price","Bedrooms","Receptions","","","","","","","","","TYPE","FURNISHED","CHILDREN","SMOKING","PETS","GARDEN","DSS","PARKING","",
"cFacility1","cFacility2","cFacility3","cFacility4","cFacility5","cFacility6","cFacility7","cFacility8","cFacility9","Tenure","ShortDescription","MainDescription","AvailabilityCode","AvailDate"
"PORT","ZL16J002","2 Jetty Court","Jetty Court","Y","E14 2SW","","200","0","0","0","0","0","0","0","0","0","0","N/a","N/a","N/a","N/a","N/a","N/a","N/a","N/a","N/a","","","","LETONLY","11/09/2002"

IS there a way I get this info onto my web page? I have looked at the fopen function but that is as far as I get. Can anbody help or suggest somewhere where I can getr more details of this. Im willing to read up etc but Im running out of time.

Thanks

Richard

sarahk

have you looked at the explode function which will take each line and create an array?

Siggles

I tried this but get a page which continuously puts Array on the screen.

<?php
$filename = "/??????/xfile.txt";
$fp = fopen ("$filename", "r") or die("Couldn't open $filename");
while (! feof($fp)){
$pieces = explode(",", $fp);
print "$pieces<br>";
}
?>

Any further pointers as to where I'm going wrong?

Thanks

Aeiri

Replace:

print "$pieces<br>";

with:

for($i=0;$i<=count($pieces);$i++) echo($pieces[$i]."<br />");

edwardsbc

I always use the file function to load the rows of the text database into an array. Then I can process it with array functions as well (still using explode to get the data elements out).

Siggles

At the moment I'm trying a different route. The php beloews prints the first word in each line of the .txt file onto the screen. Anyway I can just print one line. DO I use an associative array?

<?php

$lines = file('xfile.txt');

foreach ($lines as $line) {

    list($branchid, $color, $animal) = explode('","', $line);

    echo "$branchid"; // prints name
    echo " ";
}