csv data feed

hmptech

I am complete novice and know little if anything about PHP but I've been told it should be able to do the following.

I have a csv file (info.csv) with header row which contains the below information;

ID,Price
M1,220
P34,125
T24,234
R12,523

The above is an example, there are around 100 IDs which are static, every now and then the price changes for which a new csv is produced.

What I want to do is query the csv file (info.csv) and print/display/echo the price of a specific ID.

For example the query is, if ID = T24 then the output shown would be the price from that row in this case 234.

Can this be done with a very simple small piece of code. I have researched fgetcsv and explode but I am somewhat lost at the moment.

Any help would be appreciated.

bradgrafelman

[man]fgetcsv/man should be the main part of the puzzle. Use it to loop through the rows and check if the 'ID' column matches the value you're looking for and, if so, output/return the price column and [man]break[/man] the loop to stop.

If you still can't figure it out, show us what code you came up with and we'll go from there.

hmptech

Thanks for your reply.

Well I have sort of managed it with some basic code where I manually select which cell to print from the column.

$file = fopen('info.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE)
{

list($id[], $price[]) = $line;
}

echo $price[4]. "<BR>";

fclose($file);

To show the price I want I change the number in $price[] to the relevant one in the csv file, for example $price[4] displays 523 which is the price for ID R12 which is correct. The ID$ isn't used in the example. However it doesn't have any fail safes as the info in the csv must stay in the same location.

What I want to do with the next stage is to add an "if" or "foreach" loop so that each ID is assigned the relevant price value, then all I need to do is echo the relevant ID and the price is shown.
{
if ($id == "DS") echo $price;
else print " ";
}

Of course the above doesn't work and I've had a try but haven't been able to figure it out yet. Any suggestions would be appreciated.