Looping through array based on POST variables - PHP

Question

I've currently got a page that receives form data, I have two pieces of post information -

$country_name = $_POST[“country_name”];
$price_point = $_POST[“price_point”];

I have a spreadsheet currently that has this information in columns

I need to be able to run a function that uses the post variables and finds the corresponding value from the array.

I haven't created an array yet, as I don't know the best way to format this array. This is where I'm struggling..

Example output would be;

Post value for country is US. The price point is 2. The value would be 1.5.

Major love for anyone that can help me out with the below!

Thanks

Read up on PHPexcel to read and write to excel sheets. Else you will need to use a database like mysql (and phpmyadmin as gui for mysql) and query it which is the best way to go. With phpexcel you can import an spreadsheet into an array or object, make modifications with php and export it back. — Nitin
– Nitin, Commented Apr 10, 2017 at 15:15
You will need to use the indexes of the array for the fastest search $arr = array('US'=>[...], 'UK'=>[...]); or dynamically rearrange the array based on search parameters — Nitin
– Nitin, Commented Apr 10, 2017 at 15:26

Camille · Accepted Answer · 2017-04-10 15:27:13Z

1

I would create an array like that

$dataPoints = array(
    array(
        'point' => 1,
        'price' => 1.5,
        'country' => 'UK'
    ),
    array(
        'point' => 1,
        'price' => 1.3,
        'country' => 'US'
    ),
    array(
        'point' => 1,
        'price' => .8,
        'country' => 'SWEDEN'
    ),
    ...
)

And a function like

function getPrice($pricePoint, $country) {
    // Search in array for good price
    foreach ($dataPoints as $dataPoint) {
        if ($dataPoint['point'] == $pricePoint && $dataPoint['country'] == $country) {
            return $dataPoint['price'];
        }
    }
    return null;
}

And call it with your post parameters for print

$pp = filter_input(INPUT_POST, 'price_point');
$country = filter_input(INPUT_POST, 'country_name');
$price = getPrice($pp,$country);

echo 'Country is ', $country, '. The price point is ', $pp, '. The price is ', $price;

edited Apr 10, 2017 at 15:27

answered Apr 10, 2017 at 15:15

Camille

2,5611 gold badge19 silver badges38 bronze badges

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

2 Comments

DIM3NSION Over a year ago

Camille, this looks like the solution I'm after, how would I search the array based on those points though after I've passed them to getPrice?

Camille Over a year ago

I add body of search function getPrice

herriekrekel · Accepted Answer · 2017-04-10 15:36:49Z

0

alternatively i would just put the values in a multidimensional array like my example below

once this spreadsheet get's a lot bigger i would advice to generate the array from values out of a database.

<?php
    $country_name = 'UK';
    $price_point = 4;

    $arr = array(
        'UK' => array(
            1 => 1.5,
            2 => 1.6,
            3 => 1.9,
            4 => 12
        ),
        'US' => array(
            1 => 1.3,
            2 => 1.5,
            3 => 1.6,
            4 => 1.7
        ),
        'SWEDEN' => array(
            1 => 0.8,
            2 => 0.7,
            3 => 0.5,
            4 => 0.3
        )
    );

    $value = $arr[$country_name][$price_point];
    echo $value;
    // echoes 12
?>

edited Apr 10, 2017 at 15:36

answered Apr 10, 2017 at 15:25

herriekrekel

5716 silver badges16 bronze badges

1 Comment

Shogunivar Over a year ago

This doesn't exactly answer the question. As stated in the question "I need to be able to run a function that uses the post variables" You should edit the answer to include such function

Collectives™ on Stack Overflow

Looping through array based on POST variables - PHP

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related