read and put xml elements in a list

Question

<Data>
    <List>
    <ID>1</ID>
    <Name>Peter</Name>
    <Contact>Mobile</Contact>
    <Address>US</Address>
    </List>
    .
    .
    .
</Data>

I have a huge xml in this format; I want to read the xml and put the xml elements into a list.

How can we read and put elements in a list? here is the code which i tried for reading,but how to put that in a collection.please guide

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>


<body>
<?php
$file = "note2.xml";
$map_array = array(
    "BOLD"     => "B",
    "EMPHASIS" => "I",
    "LITERAL"  => "TT"
);

function startElement($parser, $name, $attrs) 
{
    global $map_array;
    if (isset($map_array[$name])) {
        echo "<$map_array[$name]>";
        if (strpos((string) $movies->movie->title ,"PHP")!==false) {
    print 'My favorite movie.';
}
else{
    print 'new one';
    }
        echo "<br />";
    }
}

function endElement($parser, $name) 
{
    global $map_array;
    if (isset($map_array[$name])) {
        echo "</$map_array[$name]>";
                echo "<br />";
    }
}

function characterData($parser, $data) 
{
    echo $data;
}

$xml_parser = xml_parser_create();
// use case-folding so we are sure to find the tag in $map_array
xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, true);
xml_set_element_handler($xml_parser, "startElement", "endElement");
xml_set_character_data_handler($xml_parser, "characterData");
if (!($fp = fopen($file, "r"))) {
    die("could not open XML input");
}

while ($data = fread($fp, 4096)) {
    if (!xml_parse($xml_parser, $data, feof($fp))) {
        die(sprintf("XML error: %s at line %d",
                    xml_error_string(xml_get_error_code($xml_parser)),
                    xml_get_current_line_number($xml_parser)));
    }
}
xml_parser_free($xml_parser);
?>
</body>
</html>

http://www.mkyong.com/java/how-to-read-xml-file-in-java-dom-parser/ — Marco Acierno, Apr 04 '14 at 16:39
still easy: http://www.php.net/manual/it/book.xml.php or http://www.php.net/manual/en/book.simplexml.php Anyway remove Java tag. — Marco Acierno, Apr 04 '14 at 16:41
IMHO, your post doesn't haven't anything to do with Java. So I edited it to remove the Java part. — Bhesh Gurung, Apr 04 '14 at 16:46
i tried to read the xml,but i m not able to put it in a collection like array or arraylist.please help.i m editing my post by adding the code. — user3488008, Apr 04 '14 at 17:45
take a look at this: http://stackoverflow.com/questions/1835177/how-to-use-xmlreader-in-php/1835324#1835324 — michi, Apr 05 '14 at 16:44

score 0 · Answer 1 · answered Apr 04 '14 at 21:57

0

Make it a simplexml object:

$xml = simplexml_load_string($x); // assuming XML in $x

Then access it like:

echo $xml->List[1]->Name;

Loop:

foreach ($xml->List as $list)
    echo $list->Name;

see it working: https://eval.in/132123

Read the SimpleXml Manual on PHP.net

answered Apr 04 '14 at 21:57

michi

6,565
4
33
56

Thanks sir.If we are having a huge xml haaving some 10 lakh rows,then what is the method to read it in PHP – user3488008 Apr 05 '14 at 05:40
@user3488008 I don't understand 10 lakh rows. Have you tried Simplexml? Results? – michi Apr 05 '14 at 10:32
Try XMLReader. And lakh = 1000? – michi Apr 05 '14 at 10:38
lakh means 100000 records – user3488008 Apr 05 '14 at 10:44

read and put xml elements in a list

1 Answers1