Search an Array and print out matches

norfy

I have read the contents of a csv file into an Array using fgetcsv()

I now want to use this Array as a database and search through it for records that match my criteria and display them.

Example: the Array contains houses for sale and I want to display all records where the price field of that array is greater than x and less than y and the area field = z

Does this make sense ?

If I was using MySQL I would have no problems because I would just query the fields in the table. But I have to use this csv file that contains the data.

Any ideas

barand

Use [man]array_filter[/man]

$houses = array (
	0 => array (
			'property' => '1 Letsby Avenue',
			'price' => 240000,
			'area' => 'A'
			),
	1 => array (
			'property' => '12 Acacia Avenue',
			'price' => 140000,
			'area' => 'A'
			),
	2 => array (
			'property' => '5 Every Street',
			'price' => 55000,
			'area' => 'B'
			),
	3 => array (
			'property' => '99 Mornington Crescent',
			'price' => 355000,
			'area' => 'B'
			),
	4 => array (
			'property' => '10 Downing Street',
			'price' => 2395000,
			'area' => 'C'
			)
	);

function houseFilter($item) {
	global $lo, $hi, $areacode;

return $item['price'] >= $lo && $item['price'] <= $hi && $item['area']==$areacode;

}

//set criteria
$lo = 100000;
$hi = 300000;
$areacode = 'A';

$selection = array_filter($houses, 'houseFilter');

echo "<pre>";
print_r ($selection);
echo "</pre>";

hth

kevinsequeira

u might want to look at in_array() also

http://ca.php.net/manual/en/function.in-array.php

reg
kevin