Parse CDATA with simplexml php

Question

I have xml file like

<offer>
   <WEB>.........</WEB>
   <URL>...............</URL>
   <![CDATA[
       <TITLE>some ......</TITLE>
   ]]>
   <SOLD_AMOUNT>0</SOLD_AMOUNT>
   <IMAGE>.....l_offer_438.jpg</IMAGE>
   <CITY>town.....</CITY>
   <DISCOUNT>50</DISCOUNT>
   <ORIGINAL_PRICE>1405</ORIGINAL_PRICE>
   <FINAL_PRICE>702</FINAL_PRICE>
   <DEAL_END>1323122399</DEAL_END>
</offer>

how can i parse CDATA section

$sxe = simplexml_load_file($xml,null,LIBXML_NOCDATA);
print_r($sxe);

this way it does not working

SimpleXMLElement Object
(
    [offer] => Array
        (
            [0] => SimpleXMLElement Object
                (
                    [WEB] => ghfghfgh
                    [URL] => fghfgh
                    [SOLD_AMOUNT] => 0
                    [IMAGE] => fghfghfgh
                    [CITY] => dfgdfgdfg
                    [DISCOUNT] => 50
                    [ORIGINAL_PRICE] => 1405
                    [FINAL_PRICE] => 702
                    [DEAL_END] => 1323122399
                    [TITLE] => SimpleXMLElement Object
                        (
                        )

                )

            [1] => SimpleXMLElement Object
                (
                    [WEB] => dfgdgdfgdfg
                    [URL] => fghfghfg
                    [SOLD_AMOUNT] => 0
                    [IMAGE] => dfgdfg_offer_433.jpg
                    [CITY] => dfgdfgdg
                    [DISCOUNT] => 31
                    [ORIGINAL_PRICE] => 259
                    [FINAL_PRICE] => 179
                    [DEAL_END] => 1323122399
                    [TITLE] => SimpleXMLElement Object
                        (
                        )

                )

How exactly does it not work? Can you show the result of the `print_r` call? — Pekka, Dec 05 '11 at 08:34
possible duplicate of [Accessing tags inside CDATA in xml using php](http://stackoverflow.com/questions/7065740/accessing-tags-inside-cdata-in-xml-using-php) — Gordon, Dec 05 '11 at 08:40
SimpleXMLElement Object ( [offer] => Array ( [0] => SimpleXMLElement Object ( [WEB] => sdfsdfs [URL] => dsfsdfsf.html [SOLD_AMOUNT] => 0 [IMAGE] => l_offer_438.jpg [CITY] => town [DISCOUNT] => 50 [ORIGINAL_PRICE] => 1405 [FINAL_PRICE] => 702 [DEAL_END] => 1323122399 [TITLE] => SimpleXMLElement Object ( ) ) — enclaved, Dec 05 '11 at 08:48
Please refer http://stackoverflow.com/questions/6674322/how-to-get-values-inside-cdatavalues-using-php-dom — ShivarajRH, Jul 16 '13 at 13:25

score 0 · Answer 1 · answered Dec 05 '11 at 09:05

0

Try this:

$sxe = simplexml_load_file($xml,null);
print_r($sxe);

answered Dec 05 '11 at 09:05

frietkot

891
12
28

and what's that supposed to do? More words please. – Gordon Dec 05 '11 at 09:09
then insert the strings in mysql table – enclaved Dec 05 '11 at 09:18
This may help: http://stackoverflow.com/questions/2970602/php-how-to-handle-cdata-with-simplexmlelement – shasi kanth Dec 21 '12 at 11:35

Parse CDATA with simplexml php

1 Answers1