XML 好用的查詢工具

1
2
3
4

# 安裝
sudo apt install libxml2-utils
# 使用 xpath
xmllint --xpath "//*[local-name()='product_version']/*[local-name()='name']/text()" file.xml

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

xmllint --shell xxxx.xml << EOF
'//xxx'
EOF



xmllint --shell xxxx.xml <<<'xpath //xxx'


for f in `find . -type f  -name '*.xml'`
do
xmllint --shell $f <<<'xpath //oooo/' 
done


for f in `find . -type f  -name '*.xml'`
do
echo $f
xmllint --shell $f <<<'xpath //oooo[.!="aa" and .!="bbb" and .!="ccc"]/text()'
done

for f in *.xml
do
echo $f
done

for f in `find . -type f  -name '*.xml'`
do
echo $f
xmllint --shell $f <<<'xpath //xxx[.="123456"]/text()'
done

1
2
3
4

# 安裝
sudo apt install libxml-xpath-perl
# xpath
xpath -e '//book/name/text()'  sample.xml

1
2
3

# 安裝
sudo apt install xml2
cat sample.xml |xml2

1

DataReference[text()=//ShowArtist[@SequenceNumber="1"]/ArtistDataReference]

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

<?php
$xpath = new \DOMXpath($this->xml); // 這邊 xml 是放 DOMDocument
$query="xxxx/oooo[1]/vvvvv/ddd"; // relative ??
// 目前看到官網也有類似相關範例
// 我的認知 Xpath 前面都要有 // or /
// 這邊應該都是從 root 開始


$node = $xpath->query($query)->item(0);
$node = !empty($node) ? trim($node->nodeValue) : '' ;

foreach ($dates as $key => $a_node) {
    foreach ($a_node->childNodes as $value) {
        if ($value->nodeName == 'xxxx') {

...