How To Display The Data Extracted From Xml To Be Displayed In Yii Cgridview

Archives Bug Discussions
1

I’m trying to extract a data from XML and display it in Yii Cgridview. Below is the XML




    <tolist></tolist><cclist><cc><contactpersonname>niraj</contactpersonname><name>niraj</name><email>stgh@gmail.com</email><number>+91.3212365212</number><prefix>Ms.</prefix><contactpersonprefix>Ms.</contactpersonprefix></cc><cc>

Here I want to show only contactpersonname and email.

I tried the following




    array(

                    'name' => 'Address', 

                    'value'=>function($data)

    			{

                        //print_r($data->Address);

                        $xml_response = new SimpleXMLElement($data->Address);

                        $email=$xml_response->email;

                        print_r($email);

    			},

                    ),

&#036;data-&gt;Address contains the above XML

But, this is not working. How to do it.

2

[font=“Source Sans Pro, Helvetica, Arial, sans-serif”][size=“3”][color="#262626"]Try to use below method :)[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]

[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]Returns a SimpleXMLElement object that can be iterated over to loop through the attributes on the tag.[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]

[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]Use attributes to display when it meets certain condition defined attribute / value in xml tags.[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]Consider the following example:[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"]color="#262626"[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]<?xml version="1.0" encoding="UTF-8"?>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]<list>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] <item type="Language">[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] <name>PHP</name>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] <link>www.php.net</link>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] </item>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] <item type="Database">[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] <name>Java</name>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] <link>www.oracle.com/br/technologies/java/‎</link>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] </item>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]</list>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]

[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]Checks if the attribute value equals "Language", if equal prints everything that is related to "Language".[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]<?php[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]$xml = simplexml_load_file("file.xml");[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]foreach($xml->children() as $child) {[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] $role = $child->attributes();[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] foreach($child as $key => $value) {[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] if($role == "Language")[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] echo("[".$key ."] ".$value . "<br />");[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"] }[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]}[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]?>[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]output:[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"]saída:[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"][name] PHP[/color][/size][/font]

[font="Source Sans Pro, Helvetica, Arial, sans-serif"][size="3"][color="#262626"][link] www.php.net[/color][/size][/font]