PHP Array Unique Sort Regular not working as expected

Question

I'm using print_r(array_unique($array, SORT_REGULAR)); on the array below but it does not work.

I'm trying to filter out the redundant data.

Notice that [Order] and its key value pairs are all the same. But [Transaction] and its key value pairs are unique.

I need to get the [Order] element data and combine it with the 3 different [Transaction] elements.

My array

Array
(
    [0] => Array
        (
            [Order] => Array
                (
                    [PO] => TR11214
                    [OrderID] => 242856952012
                )

            [Transaction] => Array
                (
                    [TransPO] => TR11211
                    [TransactionPrice] => 91.17
                )

        )

    [1] => Array
        (
            [Order] => Array
                (
                    [PO] => TR11214
                    [OrderID] => 242856952012
                )

            [Transaction] => Array
                (
                    [TransPO] => TR11212
                    [TransactionPrice] => 180.41
                )

        )

    [2] => Array
        (
            [Order] => Array
                (
                    [PO] => TR11214
                    [OrderID] => 242856952012
                )

            [Transaction] => Array
                (
                    [TransPO] => TR11213
                    [TransactionPrice] => 209.99
                )

        )

)

The final array I need will look something like this.

Array
(
    [Order] => Array
        (
            [PO] => TR11214
            [OrderID] => 242856952012
        )

    [Transaction] => Array
        (
            [0] => Array
                (
                    [TransPO] => TR11211
                    [TransactionPrice] => 91.17
                )

            [1] => Array
                (
                    [TransPO] => TR11212
                    [TransactionPrice] => 180.41
                )

            [2] => Array
                (
                    [TransPO] => TR11213
                    [TransactionPrice] => 209.99
                )

        )

)

I can flatten the original array and then use array_unique, but wanted to see if there is a better way to accomplish what I need.

my code:

$myarray = array(
    0 => array(
    "Order" => array("PO" => "TR11214", "OrderID" => 242856952012),
    "Transaction" => array("TransPO" => "TR11211", "TransactionPrice" => 91.17)
    ),
    1 => array(
    "Order" => array("PO" => "TR11214", "OrderID" => 242856952012),
    "Transaction" => array("TransPO" => "TR11212", "TransactionPrice" => 180.41)
    ),
    2 => array(
    "Order" => array("PO" => "TR11214", "OrderID" => 242856952012),
    "Transaction" => array("TransPO" => "TR11213", "TransactionPrice" => 209.99)
    )
);


print_r(array_unique($myarray, SORT_REGULAR));

you can use a foreach and transfer the contents to another container. use the necessary keys accordingly — Kevin
– Kevin, Commented Jan 23, 2019 at 1:37
@Nick I'll set an if statement. the Order element will always have the same data in this if statement case. — Mike
– Mike, Commented Jan 23, 2019 at 1:55
But in that case why do you need array_unique? Or is that for the if condition? — Nick
– Nick, Commented Jan 23, 2019 at 2:03
@Nick the if statement would come before this scenario above. Meaning, the input array with multiple Order elements that are all the same, only happen in rare instances and my code would only execute to manipulate the array when these rare instances present themselves. I just need to get the array the way I need it in this rare case. — Mike
– Mike, Commented Jan 23, 2019 at 2:11

Nick · Accepted Answer · 2019-01-23 03:05:22Z

1

If you want to determine how many unique values of the Order element there are in your array, you need to apply array_unique only to the Order elements, which you can do using array_column:

$unique_orders = count(array_unique(array_column($myarray, 'Order'), SORT_REGULAR));

You can process your array using a list of keys which have non-unique values to generate an array, while other keys will have just a single value:

$non_unique_keys = ['Transaction'];
$output = array();
foreach (array_keys($myarray[0]) as $key) {
    if (in_array($key, $non_unique_keys)) {
        $output[$key] = array_column($myarray, $key);
    }
    else {
        $output[$key] = $myarray[0][$key];
    }
}
print_r($output);

Example Output:

Array ( 
    [Order] => Array (
        [PO] => TR11214
        [OrderID] => 242856952012
    ) 
    [Sales Tax] => Array (
        [PO] => TR11214
        [SalesTaxAmount] => 0 
    )
    [Transaction] => Array (
        [0] => Array (
            [TransPO] => TR11211
            [TransactionPrice] => 91.17
        )
        [1] => Array (
            [TransPO] => TR11212
            [TransactionPrice] => 180.41
        )
        [2] => Array (
            [TransPO] => TR11213
            [TransactionPrice] => 209.99
        )
    )
)

Demo on 3v4l.org

edited Jan 23, 2019 at 3:05

answered Jan 23, 2019 at 2:11

Nick

147k23 gold badges67 silver badges106 bronze badges

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

6 Comments

Mike Over a year ago

Nick, what if another element is added to the input array? For example, another element after the Order element named Salestax like this, [SalesTax] => Array ( [PO] => TR11214 [SalesTaxAmount] => 0.00). I have to manually enter the name of the element in your piece of code? I'm trying to make everything dynamic.

Nick Over a year ago

If it's a single unique element like Order you could add 'SalesTax' => $myarray[0]['SalesTax'] to the output array. Or if there are multiple values then 'SalesTax' => array_column($myarray, 'SalesTax')

Mike Over a year ago

Salestax will be just like the Order element. It will be redundant data. There are other elements in the array besides Order, Salestax and Transaction. But all the elements data are redundant except for Transaction which is unique in each array.

Mike Over a year ago

very awesome. I had tried to do what you did with the foreach before you updated the answer, but could not quite get it. Your answer is spot on. This should work for other elements in the array that are like Transaction right? Just add the element key to the non_unique_keys array? for example, there is an element named Payment and sometimes there are more than 1 payment per Order. In that case, I will need this code to do the same as what its doing for the Transaction element.

Nick Over a year ago

@Mike yes - for that case you would add 'Payment' to the $non_unique_keys array. Note though that if you can get duplicated values in one of those columns (e.g. a case where there were a multiple payments but a different number of payments than transactions) you would need to use array_unique on the column. See my updated demo - that shows a case with 2 payments and 3 transactions so a duplicated payment.

|

thefuzzy0ne · Accepted Answer · 2019-01-23 01:39:52Z

1

array_unique() is intended for single dimensional arrays. If you want to use it on a multi-dimentional array, you should consider using usort() instead. Then you'll need to iterate through the array in reverse manually, searching for duplicates and removing them.

answered Jan 23, 2019 at 1:39

thefuzzy0ne

4813 silver badges10 bronze badges

Collectives™ on Stack Overflow

PHP Array Unique Sort Regular not working as expected

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related