Print single entry match from array with php csv

Question

I have the following code which I am trying to compare a title in a csv file & pull back the appropriate price (in the csv) depending on the title:

<a class="Title" href="<?php echo $item->link;?>">
   <?php echo $item->title;?> <!--country title-->
</a>
<?php
       $pricelist = array();
       if (($handle = fopen("townprices.csv", "r")) !== FALSE)
       {
          while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
          {
             $pricelist[] = $data;
          }
          fclose($handle);
       }
       echo '<pre>'; print_r($pricelist); echo '</pre>';
?>

CSV contents:

Spain, 250
France, 350
Germany, 150

(town/title, price)

This bring back the following array from my csv:

Array
(
    [0] => Array
        (
            [0] => Spain
            [1] =>  250
        )
    [1] => Array
        (
            [0] => France
            [1] =>  350
        )
    [2] => Array
        (
            [0] => Germany
            [1] =>  150
        )
)

What I now need to do is just echo the right price, rather than

echo '<pre>'; print_r($pricelist); echo '</pre>';

So I need to create an if statement, something like:

if $item->title = Spain, print 250

But I am stuck on how to do this. Any help would be appreciated. Thanks

foreach ($pricelist as $value) { ... }?

J0HN
– J0HN

2012-01-20 10:03:41 +00:00
Commented Jan 20, 2012 at 10:03 — J0HN
– J0HN, Commented Jan 20, 2012 at 10:03

Pierre de LESPINAY · Accepted Answer · 2012-01-20 10:40:06Z

2

I think you should index your CSV.

Let me give you an example.

$pricelist = array();
if (($handle = fopen("townprices.csv", "r")) !== FALSE) {
  while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $pricelist[$data[0]] = $data[1];
  }
  fclose($handle);
}

So

echo $pricelist['Spain']; // Would give 250

edited Jan 20, 2012 at 10:40

answered Jan 20, 2012 at 10:20

Pierre de LESPINAY

46.5k62 gold badges222 silver badges318 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user991830 Over a year ago

an example would be great... I'm stuck on passing this array as a variable into my view... so if title = Spain - echo 250

user991830 Over a year ago

brillaint... so can I do this to match the country in the csv <?php echo $pricelist['$item->title']; ?>

Pierre de LESPINAY Over a year ago

Yes without the quotes around $item->title like <?php echo $pricelist[$item->title] ?>. Not tested but should work

Leonard · Accepted Answer · 2012-01-20 10:23:10Z

1

To list all prices, just do this:

foreach ($pricelist as $line) {
    echo $line[0].": &euro; ".$line[1]."<br />";
}

To find the price for a certain country, do this:

foreach ($pricelist as $line) {
    if($line[0] == "Spain") echo $line[1];
}

This will get slow on large source files though.

answered Jan 20, 2012 at 10:23

Leonard

4501 gold badge7 silver badges20 bronze badges

Collectives™ on Stack Overflow

Print single entry match from array with php csv

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related