[YQL] Parse Pixnet

Chunghe 推薦的 xpath toturial

http://www.zvon.org/xxl/XPathTutorial/Output/example1.html

 

http://www.slideshare.net/cheilmann/open-hack-london-introduction-to-yql?type=presentation
 select * from flickr.photos.info where photo_id in (select id from flickr.photos.search where woe_id in (select woeid from geo.places where text = ‘london,uk’) and license=4)
 http://github.com/spullara/yql-tables/tree/master 這個好阿

@article
select * from html where url=”http://sunnyc.pixnet.net/blog/post/23548737”
and xpath=’//div[@class="article-content"]/*’

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20html%20where%20url%3D%22http%3A%2F%2Fsunnyc.pixnet.net%2Fblog%2Fpost%2F23548737%22%0Aand%20xpath%3D’%2F%2Fdiv%5B%40class%3D%22article-content%22%5D%2F*’&format=xml

@article list
select * from html where url=”http://sunnyc.pixnet.net/blog/listall/1”
and xpath=’//div[@class="main-list"]/table/tr/*’

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20html%20where%20url%3D%22http%3A%2F%2Fsunnyc.pixnet.net%2Fblog%2Flistall%2F1%22%0Aand%20xpath%3D’%2F%2Fdiv%5B%40class%3D%22main-list%22%5D%2Ftable%2Ftr%2F*’%20&format=xml

@murmur
select * from html where url=”http://sunnyc.pixnet.net/blog/murmur”
and xpath=’//div[@id="murmur-list"]/table/tr’

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20html%20where%20url%3D%22http%3A%2F%2Fsunnyc.pixnet.net%2Fblog%2Fmurmur%22%0Aand%20xpath%3D’%2F%2Fdiv%5B%40id%3D%22murmur-list%22%5D%2Ftable%2Ftr’%20&format=xml

Random Posts

Tags: , , , ,

This entry was posted on 星期三, 五月 20th, 2009 at 4:15 下午 and is filed under 科技の卷. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply