Array Help

[fotofx]

Help, this makes no sense or I have been looking at it too long.

I have an Array called $myarray that has an Array within it called DETAIL ($myarray['DETAIL']

Please look at this code and the output below, when I print_r the values are there and correct but when I echo they are not?????

CODE

$line_item = $myarray['DETAIL'];
print_r($line_item);

$Ln_Discount = 0;
// This creates each line
foreach ($line_item as $value) {

$LineItemAmount = $value["LineItemAmount"];
$Description = $value['Description'];
$ProductCode = $value['ProductCode'];
$UnitPriceAmount = $value['UnitPriceAmount'];
$Quantity = $value['Quantity'];

echo $Quantity . ' ' . $ProductCode . ' ' . $UnitPriceAmount . ' ' . $Description . ' ' . $LineItemAmount;
}

RESULT

Array
(
    [ProductCode] => 4XXXXX
    [LineItemNumber] => 20
    [AllowanceAmount] => Array
        (
        )

[AllowancePercent] => Array
    (
    )

[Description] => ITEM DESCRIPTION
[LineItemAmount] => 00000000200.00
[Quantity] => 0000001.0000
[UnitPriceAmount] => 0000200.000000
[UnitOfMeasure] => EA
[PriceUnitOfMeasure] => Array
    (
    )

[SKUNumber] => Array
    (
    )

[UPCNumber] => Array
    (
    )

[ExternalCategory] => 4M
)
4 4 4 4 42 2 2 2 2

[laserlight]

I did a quick test using this script:

<?php

$myarray = [
    'DETAIL' => [
        [
            'ProductCode' => '4XXXXX',
            'LineItemNumber' => 20,
            'AllowanceAmount' => [],
            'AllowancePercent' => [],
            'Description' => 'ITEM DESCRIPTION',
            'LineItemAmount' => '00000000200.00',
            'Quantity' => '0000001.0000',
            'UnitPriceAmount' => '0000200.000000',
            'UnitOfMeasure' => 'EA',
            'PriceUnitOfMeasure' => [],
            'SKUNumber' => [],
            'UPCNumber' => [],
            'ExternalCategory' => '4M'
        ]
    ]
];

$line_item = $myarray['DETAIL'];
print_r($line_item);

$Ln_Discount = 0;
// This creates each line
foreach ($line_item as $value) {

$LineItemAmount = $value["LineItemAmount"];
$Description = $value['Description'];
$ProductCode = $value['ProductCode'];
$UnitPriceAmount = $value['UnitPriceAmount'];
$Quantity = $value['Quantity'];

echo $Quantity . ' ' . $ProductCode . ' ' . $UnitPriceAmount . ' ' . $Description . ' ' . $LineItemAmount;
}

My output:

Array
(
    [0] => Array
        (
            [ProductCode] => 4XXXXX
            [LineItemNumber] => 20
            [AllowanceAmount] => Array
                (
                )

        [AllowancePercent] => Array
            (
            )

        [Description] => ITEM DESCRIPTION
        [LineItemAmount] => 00000000200.00
        [Quantity] => 0000001.0000
        [UnitPriceAmount] => 0000200.000000
        [UnitOfMeasure] => EA
        [PriceUnitOfMeasure] => Array
            (
            )

        [SKUNumber] => Array
            (
            )

        [UPCNumber] => Array
            (
            )

        [ExternalCategory] => 4M
    )

)
0000001.0000 4XXXXX 0000200.000000 ITEM DESCRIPTION 00000000200.00

So I am afraid that I am unable to replicate your bug, so perhaps the problem lies elsewhere.

[NogDog]

It might be worth doing a var_export() instead of print_r() just to see if each element is of the type you think it is. (Maybe they're not simple types but objects that get output via a __toString() method?)

[fotofx]

Changing the print_r to var_export produced this result

array (
  'ProductCode' => '4XXXXX',
  'LineItemNumber' => '20',
  'AllowanceAmount' => 
  array (
  ),
  'AllowancePercent' => 
  array (
  ),
  'Description' => 'ITEM DESCRIPTION',
  'LineItemAmount' => '00000000200.00',
  'Quantity' => '0000001.0000',
  'UnitPriceAmount' => '0000200.000000',
  'UnitOfMeasure' => 'EA',
  'PriceUnitOfMeasure' => 
  array (
  ),
  'SKUNumber' => 
  array (
  ),
  'UPCNumber' => 
  array (
  ),
  'ExternalCategory' => '4M',
)4 4 4 4 42 2 2 2 2

[fotofx]

I may have found the problem but I am not sure, if it is the problem I will need a bit of help fixing it..

So the Array is made up from an XML that usually has multiple items of a ticket.

So there would be $myarray['DETAIL'][0], $myarray['DETAIL'][1], $myarray['DETAIL'][2], etc..

That is why I am doing a foreach on the Array. In this case there is only one item and the Array is $myarray['DETAIL'] with out a sub array.

So I guess I need to figure out if that is the case and treat the single item ones different. How would I determine if it is $myarray['DETAIL'] or $myarray['DETAIL'][0], etc?????

Thanks

[NogDog]

Looks like they're all strings, so shoots that theory down. :bemused:

[NogDog]

fotofx;11054077 wrote:

I may have found the problem but I am not sure, if it is the problem I will need a bit of help fixing it..

So the Array is made up from an XML that usually has multiple items of a ticket.

So there would be $myarray['DETAIL'][0], $myarray['DETAIL'][1], $myarray['DETAIL'][2], etc..

That is why I am doing a foreach on the Array. In this case there is only one item and the Array is $myarray['DETAIL'] with out a sub array.

So I guess I need to figure out if that is the case and treat the single item ones different. How would I determine if it is $myarray['DETAIL'] or $myarray['DETAIL'][0], etc?????

Thanks

I believe you're right. I was looking at the code and laserlight's "assumption" that there the DETAIL portion of the array was an array of arrays, since if it was not, then your array indexes would be screwed up.

So either check to see if it is_array() and do your foreach() loop or not, or I think there may be a flag somewhere to tell the xml parser to always treat it as an array? (Vague memory in the back of my mind that I did that once somewhere. 😉 )

[fotofx]

But the problem is that it is an array either way. Just not an array within an array.. Holy crap I am confusing myself.

The XML would either have <DETAIL>fields in here</DETAIL> or <DETAIL>fields in here</DETAIL><DETAIL>fields in here</DETAIL><DETAIL>fields in here</DETAIL>

If that makes any sense at all.

[Derokorian]

So what I would suggest is doing something like this:

$details = $result_of_xml_parsing;

if (isset($details['ProductCode'])) {
    $details = array($details);
}

foreach ($details as $detail) { /// etc...

[NogDog]

Yeah, I knew what I was thinking, but didn't say it well. 🙂 Derokorian's suggestion looks pretty clean. Alternatively, you could invert it by seeing if $details[0] isset(), and if not, then force it to be an array of arrays (well, an array of an array 😉 ). That might be slightly more self-documenting, but either way, it's a good place for a comment to remind yourself or whoever else has to maintain it months (or years) from now why you did it.

if(!isset($details[0])) {
    $details = array($details);
}