problems getting data from array

Question

PHP From the xml file below I have to pickup 2 purchase prices including 2 quantities and put them into a table. The xml you see below. I can not get the needed vars out of the array.

<?xml version="1.0" encoding="UTF-8"?><products>
<Product>
    <ParentName>22.01.14.10</ParentName>
    <Name>3040-100</Name>
    <Prices>
      <Price min-qty="1" currency="EUR">6,3200</Price>
      <Price min-qty="12" currency="EUR">5,3200</Price>
      <Price min-qty="24" currency="EUR">4,7200</Price>
   </Prices>
</Product>
<Product>
   <ParentName>22.01.10</ParentName>
   <Name>PDS1C</Name>
   <Prices>
      <Price min-qty="1" currency="EUR">1,9565</Price>
      <Price min-qty="10" currency="EUR">1,6828</Price>
      <Price min-qty="20" currency="EUR">1,4828</Price>
   </Prices>
</Product>
<Product>
   <ParentName>22.01.14</ParentName>
   <Name>P1017</Name>
   <Prices>
      <Price min-qty="1" currency="EUR">4,9337</Price>
      <Price min-qty="20" currency="EUR">3,9699</Price>
  </Prices>
</Product>
</products>

With this I fill the prices array:

foreach($product->{'Prices'}->children() as $key => $price)
{
$prices[ "" . $price->attributes()->{'min-qty'}] = mysql_real_escape_string(str_replace(',','.',"" . $price[0]));
}
ksort($prices); // sort array

Here the results:

Array
(
[1] => 6.3200
[12] => 5.3200
[24] => 4.7200
)
Array
(
[1] => 1.9565
[10] => 1.6828
[20] => 1.4828
)
Array
(
[1] => 4.9337
[20] => 3.9699
)

Now I have to fill the vars to put the vars into the table:

$qfirst = ''; // should be 1
$pfirst = ''; // should be 6.3200
$qsec = ''; // should be 12
$psec = ''; // should be 5.3200

What I try I do not get the data into the 4 vars.

$product->{'Prices'}->children() - wait, that syntax is valid? — slugonamission
– slugonamission, Commented Feb 12, 2013 at 13:16
@MathieuImbert - fair enough, I'd just never seen that syntax before and it's very weird. — slugonamission
– slugonamission, Commented Feb 12, 2013 at 13:26

Baba · Accepted Answer · 2013-02-12 14:51:36Z

2

Change

$prices[ "" . $price->attributes()->{'min-qty'}] = mysql_real_escape_string(str_replace(',','.',"" . $price[0]));

To

$prices[] = array($price->attributes()->{'min-qty'},mysql_real_escape_string(str_replace(',', '.', "" . $price[0])));

Then

foreach(array_map(null,array("first","sec","third"),$prices) as $blend)
{
    ${"q". $blend[0]} = $blend[1][0];
    ${"p". $blend[0]} = $blend[1][1];
}

var_dump($qfirst,$pfirst,$qsec,$psec) ; // it would create this variables

OR

reset($prices);
foreach(array("first","sec","third") as $blend)
{
    ${"q". $blend} = key($prices);
    ${"p". $blend} = current($prices);
    next($prices);
}
var_dump($qfirst,$pfirst,$qsec,$psec) ;

edited Feb 12, 2013 at 14:51

answered Feb 12, 2013 at 13:32

Baba

95.3k29 gold badges172 silver badges222 bronze badges

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

7 Comments

webnoob Over a year ago

Love this! Dynamic vars in PHP make it really flexible although a pain to debug :)

user1575807 Over a year ago

Baba; 100% score! Thanks. Finally a solution.

webnoob Over a year ago

@user1575807 - Give him a +1 whilst your at it ;) It's a nice solution.

Baba Over a year ago

@webnoob you can warp it in a class making it easy to debug and access

webnoob Over a year ago

@Baba - I agree but from a beginners point of view where they would be looking for $myVar = "someVal" then it's something very different :)

|

dreamweiver · Accepted Answer · 2013-02-12 13:25:10Z

0

you can use

for printing all the keys values. => print_r(array_keys($array));

for printing values => print_r(array_values($array));

answered Feb 12, 2013 at 13:25

dreamweiver

5,9922 gold badges27 silver badges39 bronze badges

Comments

Fabian Schmengler · Accepted Answer · 2013-02-12 13:35:09Z

0

This simulates the first two rounds of a foreach loop and gives the desired result:

reset($prices);
$qfirst = key($prices);
$pfirst = current($prices);

next($prices);
$qsec = key($prices);
$psec = current($prices);

answered Feb 12, 2013 at 13:35

Fabian Schmengler

24.6k9 gold badges82 silver badges114 bronze badges

Collectives™ on Stack Overflow

problems getting data from array

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related