Read XML from MySQL Database into PHP

Question

I have the following XML structure stored in my database:

This is basically a range of options. I'd like to filter through these results and get the value in the end and start and then display the value for that row.

The output would be something like the following:

1st - 900 2nd - 650 3rd - 450 4th - 330 5th - 230 6th - 175 7th - 120 8th - 95 9th - 80 10th - 70 11th to 15th - 50 16th to 20th - 35 21th to 25th - 25

I tried to read the XML file with the following code:

$payout_xml = $event_details[0]['PAYOUT_DETAILS'];
$xml = new SimpleXMLElement($payout_xml);
echo "The Simple Element is: ".print_r($xml);
echo 'single value: 
';
echo $xml->Payouts->Range->end; // get single value
echo "end of data";

When I print_r the $payout_xml I get the following results:

SimpleXMLElement Object
(
[Range] => Array
    (
        [0] => 900
        [1] => 650
        [2] => 450
        [3] => 330
        [4] => 230
        [5] => 175
        [6] => 120
        [7] => 95
        [8] => 80
        [9] => 70
        [10] => 50
        [11] => 35
        [12] => 25
        [13] => 18
        [14] => 15
        [15] => 14
        [16] => 13
        [17] => 12
        [18] => 11
        [19] => 10
        [20] => 9
        [21] => 8
        [22] => 7
        [23] => 6
        [24] => 5
        [25] => 4
        [26] => 3
        [27] => 2
        [28] => 1
        [29] => 1
        [30] => 1
    )

)
The Simple Element is: 1

I'm not accessing the data though. How can I do this?

chris85 · Accepted Answer

end is an attribute, not an element. Try something like:

echo $sxml->Range . '|' . $sxml->Range['end'] . '|' . $sxml->Range['start'];

which will give the output as

900|1|1

Functional example

$xml = '

900
650     
450     
330     
230     
175     
120     
95     
80     
70     
50     
35     
25     
18     
15     
14     
13     
12     
11     
10     
9     
8     
7     
6   
5   
4   
3   
2   
1   
1   
1   
';
$sxml = new SimpleXMLElement($xml);
echo $sxml->Range . '|' . $sxml->Range['end'] . '|' . $sxml->Range['start']; // get single value

Demo: https://eval.in/583665

or if you want to iterate through all records, https://eval.in/583666.

foreach($sxml->Range as $range){
     echo $range . '|' . $range['end'] . '|' . $range['start'] . "
";
}

Read XML from MySQL Database into PHP

Answers (1)

Related Questions