check whether key-value present in any object in array (array of object)

Question

I have array of object as

$a = [{"id":"20","invoice_id":"123"},{"id":"21","invoice_id":"123"},{"id":"22","invoice_id":"125"},{"id":"23","invoice_id":"125"},{"id":"24","invoice_id":"123"}];

here i want to create new array of abject in which duplicate object will not be there (invoice_id) as new array will be having first object of same invoice_id. i was doing like this.

foreach ($a as $key => $value) {
        if(isset($new)) {
            foreach ($new as $k => $val) {
                if($val->id != $value->id) {
                    $new[] = $value;
                }
            }
        }else{
            $new[] = $value;
        }
    }

my new array will be like

$new = [{"id":"20","invoice_id":"123"},{"id":"22","invoice_id":"125"}]

but it is not giving desired output . What should be done ?

What is $new?

Nawin
– Nawin

2017-06-22 11:41:12 +00:00
Commented Jun 22, 2017 at 11:41 — Nawin
– Nawin, Commented Jun 22, 2017 at 11:41
$new will be that new array

Vishal B
– Vishal B

2017-06-22 11:44:08 +00:00
Commented Jun 22, 2017 at 11:44 — Vishal B
– Vishal B, Commented Jun 22, 2017 at 11:44

Kyslik · Accepted Answer · 2017-06-22 12:24:49Z

3

Since you tagged this as Laravel question use collections.

Less code (one line!) and performance hit is non-existent.

$a = json_decode('[{"id":"20","invoice_id":"123"},{"id":"21","invoice_id":"123"},{"id":"22","invoice_id":"125"},{"id":"23","invoice_id":"125"},{"id":"24","invoice_id":"123"}]');

$result = collect($a)->groupBy('invoice_id');

After OP edited question:

$result = collect($a)->unique('invoice_id')->values()->toArray();

results in:

=> [
     {#826
       +"id": "20",
       +"invoice_id": "123",
     },
     {#824
       +"id": "22",
       +"invoice_id": "125",
     },
   ]

or using ->toJson() instead of ->toArray()

"[{"id":"20","invoice_id":"123"},{"id":"22","invoice_id":"125"}]"

edited Jun 22, 2017 at 12:24

answered Jun 22, 2017 at 11:49

Kyslik

8,4355 gold badges58 silver badges90 bronze badges

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

6 Comments

Kyslik Over a year ago

I do not understand your comment.

Kyslik Over a year ago

After your edit: use ->unique('invoice_id') instead of groupBy, and you can convert it to array via ->toArray()

Vishal B Over a year ago

well, my data has changed now but it is showing only one row..which is first one from $a.

Kyslik Over a year ago

@VishalBorade You need to describe exactly what you want, you provided me $a variable and output $new variable and they match with what I've given you.

Vishal B Over a year ago

your answer in perfect as per my question. Thanks but still it is not working for me.. something is wrong.

|

manian · Accepted Answer · 2017-06-22 12:25:40Z

1

Please try the below code with simple logic,

$temp = $new = array();
$b = json_decode($a, true);
foreach ($b as $key => $val) {
  if(!in_array($val['invoice_id'], $temp)) {
    $temp[$val['id']] = $val['invoice_id'];
    $new[] = array('id' => $val['id'], 'invoice_id' => $val['invoice_id']);
  }
}

print_r($new);

I am just creating a temp array to store only the unique invoice_id to compare in a loop.

It gives the below result,

Array
(
  [0] => Array
    (
        [id] => 20
        [invoice_id] => 123
    )

  [1] => Array
    (
        [id] => 22
        [invoice_id] => 125
    )

)

edited Jun 22, 2017 at 12:25

answered Jun 22, 2017 at 11:52

manian

1,4482 gold badges18 silver badges34 bronze badges

Comments

meda · Accepted Answer · 2017-06-22 11:44:14Z

0

$result = [];
foreach ($a as $data) {
    $result[$data->id] = $data;
}

var_dump(array_values($results));

answered Jun 22, 2017 at 11:44

meda

45.5k14 gold badges96 silver badges123 bronze badges

1 Comment

Vishal B Over a year ago

it is taking last ocuurence of row or object

Hariharan · Accepted Answer · 2017-06-22 11:55:25Z

0

Try this

$a = json_decode($a); 

$invoiceid = [];
$unique = [];
foreach ($a as $key => $value) { 
    if(!in_array($value->invoice_id,$invoiceid)) {
        $invoiceid[] = $value->invoice_id;
        $unique[] = $value;
    }

}
    echo $a = json_encode($unique);

answered Jun 22, 2017 at 11:55

Hariharan

1,2042 gold badges13 silver badges18 bronze badges

Collectives™ on Stack Overflow

check whether key-value present in any object in array (array of object)

4 Answers 4

6 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related