PHP: checking array to see if values match, display those values

Question

I am generating an array from a while loop, and I would like to eventually use this array to display data.

while($row = $database->fetch(PDO::FETCH_ASSOC)
{

     $value_1 = $row['value_1'];
     $value_2 = $row['value_2'];

     $data[] = array("value_1"=>$value_1,"value_2"=>$value_2);

}

so the $data[] would display using print_r I get something like this:

Array
(
    [0] => Array
        (
            [value_1] => Hello World
            [value_2] => venus
        )

    [1] => Array
        (
            [value_1] => Hello World
            [value_2] => pluto
        )

    [2] => Array
        (
            [value_1] => Hello Moon
            [value_2] => Halloween
        )

)

My question is, how would I do a foreach loop or display such a way where if I wanted to get all data, but consolidate the same values?

Ex:

Hello World to venus pluto
Hello Moon to Halloween

I know those sentences doesn't make sense, but as you can see Hello World would be consolidated and I would need to add an " to" in between value_1 and value_2

Hope my question is understandable.

Thanks!

Justin John · Accepted Answer · 2012-11-01 07:02:17Z

2

Try something like this. (Not Tested)

$match = array();
foreach($data as $d) {
    if (isset($match[$d['value_1']])) {
        $match[$d['value_1']] = $match[$d['value_1']].' '.$d['value_2'] ;
    } else {
        $match[$d['value_1']] = $d['value_1']. ' to '. $d['value_2'];
    }
}

print_r($match);

answered Nov 1, 2012 at 7:02

Justin John

9,74814 gold badges73 silver badges131 bronze badges

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

Comments

Kalpesh Patel · Accepted Answer · 2012-11-01 07:19:39Z

0

I think for this first you need to create new array as follows:

$new_array = array();
//consider your original array is $data
foreach($data as $row){
    if (array_key_exists($row['value_1'], $new_array)) {
       $new_array[$row['value_1']] = $new_array[$row['value_1']]. " ". 
                                     $row['value_2'];
    }
    else {
        $new_array[$row['value_1']] = $row['value_2'];
    }
}

Then display it by iterating:

foreach($new_array as $key => $value){
   echo $key ."to". $value;
}

answered Nov 1, 2012 at 7:19

Kalpesh Patel

2,8202 gold badges28 silver badges54 bronze badges

Comments

Mihai Matei · Accepted Answer · 2012-11-01 07:04:31Z

-1

foreach($data as $d) {

    echo $d['value_1'], ' to ', $d['value_2']; // this is if you want to echo the content

    // this code is to insert 'to' in the middle of value_1 and value_2
    $value_2 = $d['value_2'];

    unset($d['value_2']);

    array_push($d, "to", $value_2);

    unset($value_2);

}

Also you don't need to assign the $row value to another value:

$value_1 = $row['value_1']; // remove this
$value_2 = $row['value_2']; // remove this

$data[] = array("value_1" => $row['value_1'], "value_2" => $row['value_2']);

edited Nov 1, 2012 at 7:04

answered Nov 1, 2012 at 6:54

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

3 Comments

Mihai Matei Over a year ago

I think this is what I understand from you question.. before gaving me -1 you should give me more information

Luke Pittman Over a year ago

Its not my question and you clearly didn't read the entire post.

hellomello Over a year ago

I don't get it? I'm trying to consolidate data?

Collectives™ on Stack Overflow

PHP: checking array to see if values match, display those values

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related