PHP Multidimensional Array - Get value of element in last index?

Question

Not sure if I've worded that correctly however, the below could illustrate what I'm trying to achieve better..

I have a multidimensional array where I would like to capture a specific element from the last index within an array foreach

Array:

As you can see in brackets (last returned), I need the value within a specified element from the last returned in foreach "Something1.*) - Specifically, This field holds Date YYYY-MM-DD and would like to store into $ to reuse elsewhere.

Hopefully that makes sense, look forward to some help!

Is the depth of the targeted elements always the same? or might you have deeper keys like: Something.1.2.1.1.1? Have you tried to write any code for this yourself? This would help give volunteers more context. Is this coming from a parsed XML document? There may be a better/earlier way to handle this task. — mickmackusa
– mickmackusa ♦, Commented Nov 16, 2021 at 0:16
Please always present your input data as var_export() not print_r() so that volunteers can instantly use it. It is impossible to have duplicate keys in a given level of an array. DataID occurs over and over within subarrays. — mickmackusa
– mickmackusa ♦, Commented Nov 16, 2021 at 1:28
Hi Mick - thanks for replying! No deeper keys however 0,1,2,3 (results of data) may be longer in some cases and its crucial I can capture the “Date” in the last index within Something1.1,1.2,1.3 etc into a variable so it can be used in other areas of the code. I’ve tried however I cannot target the last index within a foreach loop - any ideas? — user15123815
– user15123815, Commented Nov 16, 2021 at 1:47
Please edit your code to provide a valid input data as var_export() output AND show use the EXACT desired output that you desire from that input. Make sure that your input is sufficiently expressive of the variability of your project data. — mickmackusa
– mickmackusa ♦, Commented Nov 16, 2021 at 1:49
The structure you show is impossible - you have multiple keys with the same name; please read up on how and why to create a minimal reproducible example. Also, the presence of "@attributes" makes me suspect you've converted a SimpleXML object to an array; that's generally a bad idea, as SimpleXML has facilities for doing things more easily than with plain arrays; see the examples in the manual. — IMSoP
– IMSoP, Commented Dec 4, 2021 at 21:21

FdS · Accepted Answer · 2021-11-16 22:47:44Z

0

You can do something like this. First accessing until the desired level, then pick the last array of each, check if it is an array and then print the value "Date".

Assuming that the multi-array in the example is stored in a variable named $array:

foreach($array["something"]["Something1"] as $value) {
    foreach($value as $value1){
        if(is_array(end($value1))) {
            echo(end($value1)["Date"]);
        }
    }
}

In case your multi-array deviates from the example you have indicated maybe you should add some extra validation.

Edited to show an example saving the values into a variable instead of printing them.

// First declare an array to store all values
$var = array();

// Then extract all values and save them into $var
foreach($array["something"]["Something1"] as $value) {
    foreach($value as $value1){
        if(is_array(end($value1))) {
            array_push($var, end($value1)["Date"]); // Add the value at the end of the $var array
        }
    }
}

// Finally you have all values stored into the $var array

// If you know the number of values, you can access them one by one
$var[num]; // Where 'num' is the position of the value stored into the array (0,1,2...)

// Or you can loop it

foreach ($var as $date) {
    // do whatever with each $date value
}

edited Nov 16, 2021 at 22:47

answered Nov 16, 2021 at 0:24

FdS

901 silver badge6 bronze badges

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

3 Comments

user15123815 Over a year ago

I would like to store the solution into a variable so it can be used in other areas of the code, what would be the solution for this instead if printing it?

FdS Over a year ago

@AG9 You are getting a String, the problem is that you are getting more than one value because your multiarray has different "Date" values, so then you'll need to store it into an array. First declare the array outside the foreach: $var = array(); Then instead of printing save the value into the array: array_push($var, end($value1)["Date"]); Finally you'll be able to access each value manually: $var[num] where num is the position of the value into the array or you'll be able to loop it. I'll update the answer.

user15123815 Over a year ago

Do you think you can help with this also? stackoverflow.com/questions/69992013/…

Ali Ragab · Accepted Answer · 2021-11-16 03:26:37Z

If you want to get the latest element from each element inside "Something1.*". You can try something like this:

$array = [
    'Something' => [
        'Something1' => [
            [
                "@attributes" => array(
                    'DataID_1' => "Data",
                    "DataID_2" => "Data",
                    "DataID_3" => "Data",
                ),
                "Something1.1" => array(
                    "Something1.1.1" => array(
                        array(
                            "DataID_1" => "data",
                            "Date" => "YYYY-MM-DD",
                            "DataID_2" => "data",
                            "DataID_3" => "data",
                        ),
                        array(
                            "DataID_1" => "data",
                            "Date" => "YYYY-MM-DD",
                            "DataID_2" => "data",
                            "DataID_3" => "data",
                        ),
                        array(
                            "DataID_1" => "data",
                            "Date" => "YYYY-MM-DD last",
                            "DataID_2" => "data",
                            "DataID_3" => "data",
                        ),
                    ),
                ),
                "Something1.2" => array(
                    "Something1.2.1" => array(
                        array(
                            "DataID_1" => "data",
                            "Date" => "YYYY-MM-DD",
                            "DataID_2" => "data",
                            "DataID_3" => "data",
                        ),
                        array(
                            "DataID_1" => "data",
                            "Date" => "YYYY-MM-DD",
                            "DataID_2" => "data",
                            "DataID_3" => "data",
                        ),
                        array(
                            "DataID_1" => "data",
                            "Date" => "YYYY-MM-DD last",
                            "DataID_2" => "data",
                            "DataID_3" => "data",
                        ),
                    ),
                ),
            ],
        ],
    ],
];

$dates = [];
$something1 = $array['Something']['Something1'];

foreach ($something1 as $something_1) {                 // loop through 'Something1'
    foreach ($something_1 as $key => $something_1_1) {  // loop through each element of 'Something1'.
        if (str_starts_with($key, 'Something1.')) {     // if key starts with 'Something1.' PHP >= 8.0
            foreach ($something_1_1 as $key => $something_1_1_1) {
                $last_element = end($something_1_1_1);  // get last element of array
                $dates[] = $last_element['Date'];       // OUTPUT: YYYY-MM-DD last
            }
        }
    }
}

var_dump($dates); // This array will contain your dates.

// You can also use the following code to loop through dates:
foreach ($dates as $date) {
    echo $date; // OUTPUT: YYYY-MM-DD last
}

//OR access the dates in the following way:
$first_date = $dates[0];                    // get first date. and so on..
$last_date = $dates[count($dates) - 1];     // get last date.

Please note these functions:
str_starts_with() is availabel since PHP8.0.
end() Set the internal pointer of an array to its last element.

I would like to store the solution into a variable so it can be used in other areas of the code, what would be the solution for this instead if printing it?
Check the updated answer. I think it should fulfill your needs.

Collectives™ on Stack Overflow

PHP Multidimensional Array - Get value of element in last index?

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related