XQuery FLWOR + HTML
XML Example Document
We will continue to use this "books.xml" document in the examples below (the same file as in the previous section).
。
Present the results in an HTML list
See the following XQuery FLWOR expression:
for $x in doc("books.xml")/bookstore/book/title
order by $x
return $x
order by $x
return $x
The above expression selects all title elements under the book elements under the bookstore element, and returns the title elements in alphabetical order.
Now, we want to use an HTML list to list all the book titles in our bookstore. We add <ul> and <li> tags to the FLWOR expression:
<ul>
{
for $x in doc("books.xml")/bookstore/book/title
order by $x
return <li>{$x}</li>
}
</ul>
{
for $x in doc("books.xml")/bookstore/book/title
order by $x
return <li>{$x}</li>
}
</ul>
The output of the above code is:
<ul>
Everyday Italian
Harry Potter
Learning XML
XQuery Kick Start
</ul>
</ul>
Now we want to remove the title elements and display only the data inside the title elements.
<ul>
{
for $x in doc("books.xml")/bookstore/book/title
order by $x
return <li>{data($x)}</li>
}
</ul>
{
for $x in doc("books.xml")/bookstore/book/title
order by $x
return <li>{data($x)}</li>
}
</ul>
The result will be an HTML list:
<ul>
<li>Everyday Italian</li>
<li>Harry Potter</li>
<li>Learning XML</li>
<li>XQuery Kick Start</li>
</ul>
<li>Everyday Italian</li>
<li>Harry Potter</li>
<li>Learning XML</li>
<li>XQuery Kick Start</li>
</ul>