Archive for the ‘xml’ tag
Working with the QXL.no api to show the latest bid on an auction
My sexy colleagues in NRK Mp3 are selling themselves on the auctionsite qxl.no for a good cause (Blå Kors), and I wanted to cook up a fast way to display the latest bid on the NRK Mp3 website.
Here is the result so far:
[kml_flashembed movie="http://pappmaskin.no/opensource/qxl/qxl.swf?AuctionNr=549364732" width="236" height="50" allowfullscreen="true" allowscriptaccess="always" /]
Not very fancy to say the least! But it does what it needs to: Fetch the latest bid on a particular auction.
Because I have to display it on bort nrk.no/mp3 and nrkp3.no (an externally hosted site), I decided to go for Flash, and using the new and lovely XML functionality of AS3.
It is in use on http://nrkp3.no/programledere-til-salgs/ and the frontpage of http://nrk.no/mp3 until the 19th of october at least.
Todo:
Make the code more reusable, everything is basically hardcoded.
Update: The php is now dynamic, send AuctionNr as a parameter to retrieve the auction you want like this: http://pappmaskin.no/opensource/qxl/qxlproxy.php?AuctionNr=549364732 . Next: Send in AuctionNr using the embed code.
Downloads:
QXL.zip.
The zip contains:
- qxl.fla (as3, made with flash cs3, very easy to understand what to change).
- qxlproxy.php (used to get around crossdomain-issues in flash)
Old QXL webservice documentation:
http://hjelp.qxl.no/avansert:xml_api
QXL Old api:
http://www.qxl.no/accdb/viewItemXML.asp?IDI=549689208
QXL New api, received by mail after contacting QXL:
http://www.qxl.no/accdb/viewitemxml.asp?AuctionNr=549689208&Catg=11395&ListingType=0&ListingSort=1&LanguageNr=0&PageNum=1
Resources:
Good as3 xml tutorial on Gotoandlearn.com
More about this years charity event
http://nrk.no/tvaksjonen/
Creating a youtube service using gdata and xslt with php
Let’s start with a little demonstration. The section below is made by calling the php-script http://pappmaskin.no/opensource/youtube/youtube.php?s=super&max=9 within an iframe:
Why iframe?
Just to make it easier to reuse and embed Youtube videos on different sites, and because it makes it easier to try out new ideas without adding messy bits to a larger project. Sort of like rapid prototyping/proof of concept before “committing” to a feature and spending alot of time integrating something you might end up throwing out.
This solution currently consists of these files:
youtube.php, takes s=whateveryouwanttofind and max=number of videos to return as GET parameters
youtube5.xsl, does all the transformation of the xml from youtube into lovely xhtml.
youtube.js, javascript file that handles clicking on the thumbnails to load a new video, using innerHtml
youtube.css, minimalist styling to keep things pretty.
swfobject.js, for embedding flash
The xslt:
<?xml version=”1.0″ encoding=”UTF-8″?> <xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform” xmlns:fn=”http://www.w3.org/2005/xpath-functions” xmlns:gd=”http://schemas.google.com/g/2005″ xmlns:media=”http://search.yahoo.com/mrss/” xmlns:n1=”http://www.w3.org/2005/Atom” xmlns:openSearch=”http://a9.com/-/spec/opensearchrss/1.0/” xmlns:xdt=”http://www.w3.org/2005/xpath-datatypes” xmlns:xs=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:yt=”http://gdata.youtube.com/schemas/2007″ xmlns:altova=”http://www.altova.com”> <xsl:output method=”html” encoding=”ISO-8859-1″ doctype-public=”-//W3C//DTD XHTML 1.0 Transitional//EN” doctype-system=”http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”/> <xsl:param name=”SV_OutputFormat” select=”‘HTML’”/> <xsl:variable name=”XML” select=”/”/> <xsl:template match=”/”> <html> <head> <title>Pappmaskin.no – Youtube playlist</title> <link rel=”stylesheet” href=”youtube.css” media=”screen” /> <script type=”text/javascript” src=”youtube.js”></script> <script type=”text/javascript” src=”swfobject.js”></script> </head> <body> <div id=”youtube”> <h1>YouTube Playlist</h1> <xsl:for-each select=”$XML”> <xsl:for-each select=”n1:feed”> <xsl:if test=”n1:entry[1]“> <div class=”youtubevideo”><div id=”cur_video”> <xsl:for-each select=”n1:entry[1]/media:group/media:content”> <xsl:if test=”@type = ‘application/x-shockwave-flash’”> <embed> <xsl:attribute name=”src”> <xsl:value-of select=”@url”/> </xsl:attribute> <xsl:attribute name=”width”>480</xsl:attribute> <xsl:attribute name=”height”>385</xsl:attribute> <xsl:attribute name=”quality”>high</xsl:attribute> <xsl:attribute name=”bgcolor”>#000</xsl:attribute> <xsl:attribute name=”id”>cur_video_swf</xsl:attribute> <xsl:attribute name=”name”>cur_video_swf</xsl:attribute> </embed> </xsl:if> </xsl:for-each> </div> <!– ends cur_video –> <div id=”cur_video_title”> <xsl:value-of select=”n1:entry[1]/n1:title”/> </div> </div> <!– ends youtubevideo –> </xsl:if> <div class=”youtubethumbs”> <xsl:for-each select=”n1:entry”> <xsl:if test=”position() > 1″> <xsl:for-each select=”media:group”> <div class=”youtubethumb”> <xsl:for-each select=”media:content”> <xsl:if test=”@type = ‘application/x-shockwave-flash’”> <a> <xsl:attribute name=”href”>#</xsl:attribute> <xsl:attribute name=”onmousedown”>PlayVideo(‘<xsl:value-of select=”@url”/>’,'http://img.youtube.com/vi/h8oBykb_Pqs/2.jpg’, ‘Youtube’, true);</xsl:attribute> <xsl:attribute name=”onclick”>return false;</xsl:attribute> <xsl:for-each select=”../media:thumbnail[1]“> <xsl:element name=”img”> <xsl:attribute name=”src”><xsl:value-of select=”@url”/></xsl:attribute><xsl:attribute name=”lowsrc”>lowsrc.gif</xsl:attribute><xsl:attribute name=”width”>100</xsl:attribute><xsl:attribute name=”height”>60</xsl:attribute> </xsl:element> </xsl:for-each> <xsl:value-of select=”../media:title”/> </a> </xsl:if> </xsl:for-each> </div> <!– ends avslutter class youtubethumb –> </xsl:for-each> </xsl:if> <!– end if on position > 0 –> </xsl:for-each> </div><!– ends class youtubethumbnails –> </xsl:for-each> </xsl:for-each> <div class=”youtubefooter” style=”clear: both; color: #999999; font-size: 0.8em;”>Disclaimer: These videos are retrieved from Youtube through a simple search. Even though the search is done with a filter to remove “inappropriate material”, it may still contain videos deemed offensive by some. Videos may or may not be in violation of international copyright law.</div> </div> <!– avslutter id youtube –> </body> </html> </xsl:template> </xsl:stylesheet>
The PHP
<?php
$searchterm = $_GET["s"];
$maxresults = $_GET["max"];
/* load the xml file and stylesheet as domdocuments */
$xsl = new DomDocument();
$xsl->load(“youtube5.xsl”);
$inputdom = new DomDocument();
//Example http://gdata.youtube.com/feeds/videos?format=1&vq=Ratchet+Clank:+Tools+of+Destruction&max-results=2
$inputdom->load(“http://gdata.youtube.com/feeds/videos?format=5&vq=” . $searchterm . “&max-results=” . $maxresults);
//$inputdom->load(“youtube.xml”);
//if you want to test with a local file
/* create the processor and import the stylesheet */
$proc = new XsltProcessor();
$xsl = $proc->importStylesheet($xsl);
//$proc->setParameter(null, “titles”, “Titles”);
//not in use, but needed if you want to pass variables into the xslt from php
/* transform and output the xml document */
$newdom = $proc->transformToDoc($inputdom);
print $newdom->saveXML();
exit;
?>
Grafiskformgivning.no
Customer: Oh! Ohren Grafisk Formgivning
Delivered: Advice and production of a flashbased minisite. Webdev, Flash (AS2), design and development of an XML-driven gallery, contact form with PHP backend.
Designs delivered by customer as PSD.
Release: March 2007
Ohren Grafisk design - Frontpage
Ohren Grafisk design - Portfolio - List of clients
Ohren Grafisk design - Example portfolio page
Flash-based xml-driven slide show. Reads images, titles and description from the server, making it fairly easy to update.
Oh! OHREN Grafisk formgivning - Contact
Flash frontend and PHP-backend.
Podcastplayer in flash! Php script to convert RSS to XSPF
photo credit: …Tim
Create your own free flash based podcast / mp3 player
I like the flashbased XSPF mp3 player. I had planned to rewrite the actionscript so that it could read rss with enclosures instead, but I liked the possibility to have unique pictures on each track, and I wanted to check out the XSPF format.
So I wrote a PHP script that uses DOMXML and xpath to convert an existing rss to xspf, it even have a search function of sorts.
I’m going to use it on a project I’m working on after a little more tweaking but I wanted to share it with other people who has a podcast and want a quick open source way to present their podcasts on their website.
photo credit: Chregu
<?php
$path = “http://podkast.nrk.no/program/radioresepsjonen.rss”;
$showfile = file_get_contents($path);
if(!$doc = domxml_open_mem($showfile)) {
echo “Error while parsing the document…”;
exit;
}
$xpath = xpath_new_context($doc);
$root = $doc->document_element();
//debugging
//echo domxml_version();
//var_dump(xpath_eval_expression($xpath, ‘/rss/channel/item’)); //http://no.php.net/manual/sv/function.xpath-eval-expression.php
//debugging – memory dump
//echo $doc->dump_mem( true, ‘UTF-8′ ) ; //http://no.php.net/manual/sv/function.domdocument-dump-mem.php
//print ” Path: <a href=\”$path\”>$path</a><br>\n”;
//print ” Showfile: <a href=\”$showfile\”>$showfile</a><br>\n”;
//print ” domDoc: <a href=\”$domDoc\”>$domDoc</a><br>\n”;
//print ” root: <a href=\”$root\”>$root</a><br>\n”;
// playlist plus search function
$playlist = $xpath->xpath_eval(“/rss/channel/item[contains(translate(title,'abcdefghijklmnopqrstuvwxyzæøåö', 'ABCDEFGHIJKLMNOPQRSTUVWXYZÆØÅÖ'), '".strtoupper($_REQUEST["search"]).”‘)]”);
//debug
//print “playlist found: “.count($playlist->nodeset).”\n”;
print “<?xml version=\”1.0\” encoding=\”UTF-8\” ?>\n”;
print “<playlist version=\”0\” xmlns=\”http://xspf.org/ns/0/\”>\n”;
print ” <title>Put clever title here, or get it from the rss</title>\n”;
print ” <annotation>Description of some sort</annotation>\n”;
print ” <creator>Who made this</creator>\n”;
print ” <info>http://link to more info</info>\n”;
print ” <location>http://yourdomain.com/doesnreallymatter/rss2xspf.php</location>\n”;
print ” <license></license>\n”;
print “<trackList>\n”;
foreach ($playlist->nodeset as $tracklist) {
$description = “”;
$title = “”;
$enclosureurl = “”;
//$enclosureurl = $tracklist->get_attribute(“length”);
//$spor = $tracklist->get_attribute(“spor”);
//$sangid = “$arkivnr-$spor”;
foreach ($tracklist->child_nodes() as $child) {
if ($child->node_name() == “title”) $title = $child->get_content();
if ($child->node_name() == “description”) $description = $child->get_content();
if ($child->node_name() == “enclosure”) $enclosureurl = $child->get_attribute(“url”);
}
print “<track>\n”;
print ” <location>$enclosureurl</location>\n”;
print ” <image>hassan/bilder/else150.jpg</image>\n”;
print ” <annotation>$title</annotation>\n”;
print ” <info></info>\n”;
print ” <info_text>$description</info_text>\n”;
print ” </track>\n”;
}
print “</trackList>\n”;
print “</playlist>\n”;
?>
Copypaste the above code into a new file and save it as rss2xspf.php and upload it to your server to test if you have domxml support. (If you don’t it will say something like Call to undefined function: domxml_open_mem. In that case, tough luck, find a new host.)
Download the exellent XSPF flash based mp3 player here: XSPF Web Music Player (Flash) – Plays MP3 on your website
Read more about XSPF over at http://www.xspf.org/
And please drop a comment if you use it and like or have problems.
You can also send me an email at morten.skogly _at_ gmail dot com.
There’s a lot of room for improvement, like using the rss image in place of a staticly defined image, or inserting a random image, or doing som web2.0 stuff like snarfing the images from amazon or whatever, please let me know if you make something superclever with it :)
Idea for your site: You can use del.icio.us to make your own mp3 podcast, visit bands you like bookmark the mp3s you like with del.icio.us, go there to get the rss, and your set to go, you have the same music on your site as on your ipod :) (You might have to use feedburner.com as a gobetween to create the enclosures and make it itunes-compatible.)
Updated: 06.04.2008: Unless you really really digg the XSPF player linked up above, I suggest you use the superb Jeroen Media Player instead. It is open source and supports both XSPF and RSS directly. It takes up more space, but it has video support and a very cool javascript api.
