reading 2 text files into an array

[rowantrimmer]

I have 2 |! delimted text files that I need to read into an array so that I can then ouptut the array.

the ^ denotes end of line

The first text fille would contain the following 3 fields
property_ref | price | location ^
an example of this would be...

abc123|£234,567|London ^

the 2nd text file would contain just 2 fields
property_ref | internal_pic ^
an example of this would be...

abc123|image1.jpg^

with the second file it could have the same property ref output more than once with image2 etc

So in text file 1 we would only ever get 1 line for the property but in file 2 we could have x number of the same property.

I need to write a script to do this.

Any ideas ???

[LordShryku]

Sure...use [man]file[/man], [man]explode[/man], and [man]in_array[/man].
File to get the contents. Explode to split on your delimter. Use those two to make a nice, clean array of the first file. The use them to open up the second file, and use in_array for checking the value.

[rowantrimmer]

I am really new to php and I have attached the code for reading in text file 1 that works well. Could you take a look and see how I would do what you mentioned to get text file 2 incorporated as well.

<?php

include("vars.php");

$fp=fopen($textfile1,'r');
$FileContents=fread($fp, filesize ($textfile1));
fclose($fp);

$fp=fopen($xml_output_dir.$xml_output1,'w');
fclose($fp);

$FileData= explode("^", $FileContents);

$output.= "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
$output.= "<properties>\n";

for($i=0;$i<count($FileData);$i++)
{

$Data = explode("¦", $FileData[$i]);

for($c=0;$c<10;$c++)

{$Result[$c]=trim($Data[$c]); }

$c=0;

$image=$Result[3];

$conv_image=eregi_replace(",", " " , $image);

$len=strpos($conv_image," ");

					$Result[3]=substr($conv_image,0,$len);

$output.= " <property>\n";
$output.= " <property_ref>{$Result[0]}</property_ref>\n";
$output.= " <location>{$Result[1]}</location>\n";
$output.= " <price>{$Result[2]}</price>\n";
$output.= " <main_image>{$Result[3]}</main_image>\n";
$output.= " <bullet1>{$Result[4]}</bullet1>\n";
$output.= " <bullet2>{$Result[5]}</bullet2>\n";
$output.= " <bullet3>{$Result[6]}</bullet3>\n";
$output.= " <bullet4>{$Result[7]}</bullet4>\n";
$output.= " <bullet5>{$Result[8]}</bullet5>\n";
$output.= " <bullet6>{$Result[9]}</bullet6>\n";
$output.= " <bullet7>{$Result[10]}</bullet7>\n";
$output.= " <bullet8>{$Result[11]}</bullet8>\n";
$output.= " </property>\n";
}
$output.= "</properties>\n";
$fp=fopen($xml_output_dir.$xml_output1,'w');
fwrite($fp,$output);
fclose($fp);
?>

[LordShryku]

Well, that code has a lot of excess. Here's what I would do:
First, get rid of the ^'s. Un-needed. In a file, the end of line is known by a b newline, and using file, it will split it up accordingly.

$results = array();
$file    = file("file1");
foreach($file as $f) {
   $data = explode("|",$f);
   $results[$data[0]] = array("price" => $data[1], "location" => $data[2]);
}
/* At this point, you have an array with entries that look like this:
 * Array=>
 *     [abc123] => Array
 *         (
 *             [price] => £234,567
 *             [location] => London
 *         )
 * )
 *
 *  Now on to file 2. Not going to use in_array, just add it
 */

$file = file("file2");
foreach($file as $f) {
   $data = explode("|",$f);
   $results[$data[0]]['image'][] = $data[1];
}

/* End result looking like this:
 * Array=>
 *     [abc123] => Array
 *         (
 *             [price] => £234,567
 *             [location] => London
 *             [image] => Array
 *                (
 *                    [0] => image1.jpg
 *                )
 *         )
 * )
 *
 *  Now on to file 2. Not going to use in_array, just add it
 */

[rowantrimmer]

Pasted below is the code as I have it now.

How can I view the contents of the array ?

<?php

$results = array();
$file = file("file1.txt");
foreach($file as $f) {
$data = explode("|",$f);
$results[$data[0]] = array("price" => $data[1], "location" => $data[2]);
}

$file = file("file2.txt");
foreach($file as $f) {
$data = explode("|",$f);
$results[$data[0]]['image'][] = $data[1];
}

?>

[LordShryku]

just a simple view, do a print_r($results);
If you need to format it someway, loop through, accessing it by elements.

[rowantrimmer]

I really don't understand the code.

How can I display all of the cells for a row by row so that I can see what has been added into the array ?

When I do the print_r($results); command I am getting bits like Array >=.

Many thanks

[LordShryku]

Here's a pretty basic way to loop through and print out a table

<?php
foreach($results as $key => $value) {
?>
<table border="1"
  <tr>
    <th>Property</th>
    <th>Location</th>
    <th>Price</th>
    <th colspan="<?php echo count($value['image']); ?>">Image(s)</th>
  </tr>
  <tr>
    <td><?php echo $key; ?></td>
    <td><?php echo $value['location']; ?></td>
    <td><?php echo $value['price']; ?>
<?php
   foreach($value['image'] as $i) {
?>
    <td><?php echo $i; ?></td>
<?php
   }
?>
  </tr>
</table>
<?php
}
?>

[rowantrimmer]

I actualy need the output to be writen away into an xml file ? Could you point me in the right directionn for that along with the inital code for reading in and merging together the 2 text files ?

Many thanks in advance.

Rowan