damarez
%Europe/Berlin %443 %2008, 11:38
Ik heb een php class die voor mij de data uit een tabel parsed naar xml
<?php
/*
class om de navigatie voor de website op te zetten
*/
class navigatie
{
public function navigatie()
{
/*
hier word alles aangemaakt
*/
header("Content-type: text/xml");
include ("inc_connect.php");
$this->create();
}
protected function create()
{
/*
output als xml
*/
$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<Site>\n";
$query="SELECT * FROM navigatie ORDER BY item_id ASC";
$result = mysql_query($query) or die("FOUT : " . mysql_error());
while (list( $item_id,$omschrijving,$media,$datum) = mysql_fetch_row($result))
{
$xml_output .= "\t<Navigatie_item>\n";
$xml_output .= "\t\t<naam><![CDATA[" . $omschrijving. "]]></naam>\n";
$xml_output .= "\t\t<link><![CDATA[" ."index.php"."?rubriek=subnav&start=true&item_id=$item_id"."]]></link>\n";
$xml_output .= "\t</Navigatie_item>\n";
}
$xml_output .= "</Site>";
echo $xml_output;
}
}
$n=new navigatie();
?>
/**
* @author damarez
*/
import org.asapframework.events.EventDelegate;
class nl.flymedia.asl.ui.Navigation extends MovieClip
{
private var xmlData:XML;
private var xmlNode:XMLNode;
private var naam:Array;
private var link:Array;
private var total:Number;
private var menu_btn:MovieClip;
private var label_txt:TextField;
private var menuArr:Array;
public function Navigation (timeline:MovieClip)
{
System.security.allowDomain ("www.thevalleyestate.com/");
xmlNode = this.xmlData.firstChild;
xmlData = new XML ();
loadData ("http://www.thevalleyestate.com/thevalley/nl/base_xml.php",timeline);
menuArr = new Array ();
trace (xmlData);
}
private function loadData (url:String, timeline:MovieClip)
{
xmlData.ignoreWhite = true;
xmlData.onLoad = EventDelegate.create (this, loadXML, timeline);
xmlData.load (url);
}
private function loadXML (timeline:MovieClip):Void
{
naam = [];
link = [];
total = xmlNode.childNodes.length;
for (var i:Number = 0; i < total; i++)
{
naam[i] = xmlNode.childNodes[i].childNodes[0].firstChild.nodeValue;
link[i] = xmlNode.childNodes[i].childNodes[1].firstChild.nodeValue;
}
getItems (timeline);
}
private function getItems (timeline:MovieClip):Void
{
for (var i:Number = 0; i < total; i++)
{
trace (i);
menuArr.push (menu_btn);
menu_btn.x += menu_btn.width * i;
menu_btn.y = Math.round ((menu_btn.height / 2));
menu_btn.onRelease = EventDelegate.create (timeline, changeOldContent, menu_btn, i);
startup ();
}
}
private function enableButtons ():Void
{
for (var i:Number = 0; i < menuArr.length; i++)
{
menuArr[i].enabled = true;
trace (menuArr[i]);
menuArr[i].onEnterFrame = EventDelegate.create (this, playBack, menuArr[i]);
}
}
private function playBack (but:MovieClip):Void
{
if (but._currentframe == 1)
{
delete but.onEnterFrame;
}
else
{
but.prevFrame ();
}
}
private function playForward (but:MovieClip):Void
{
if (but._currentframe == but._totalframes)
{
delete but.onEnterFrame;
}
else
{
but.nextFrame ();
}
}
private function startup ()
{
enableButtons ();
menuArr[0].enabled = false;
var lastFrame:Number = menuArr[0]._totalframes;
var total = menuArr.length;
menuArr[0].onEnterFrame = EventDelegate.create (this, playForward, menuArr[0]);
}
private function changeOldContent (menu_btn:MovieClip, i:Number, container:MovieClip):Void
{
enableButtons ();
menu_btn.enabled = false;
var lastFrame:Number = menu_btn._totalframes;
menu_btn.onEnterFrame = EventDelegate.create (this, playForward, menu_btn);
getURL (link[i], "_blank");
}
}
<?php
/*
class om de navigatie voor de website op te zetten
*/
class navigatie
{
public function navigatie()
{
/*
hier word alles aangemaakt
*/
header("Content-type: text/xml");
include ("inc_connect.php");
$this->create();
}
protected function create()
{
/*
output als xml
*/
$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<Site>\n";
$query="SELECT * FROM navigatie ORDER BY item_id ASC";
$result = mysql_query($query) or die("FOUT : " . mysql_error());
while (list( $item_id,$omschrijving,$media,$datum) = mysql_fetch_row($result))
{
$xml_output .= "\t<Navigatie_item>\n";
$xml_output .= "\t\t<naam><![CDATA[" . $omschrijving. "]]></naam>\n";
$xml_output .= "\t\t<link><![CDATA[" ."index.php"."?rubriek=subnav&start=true&item_id=$item_id"."]]></link>\n";
$xml_output .= "\t</Navigatie_item>\n";
}
$xml_output .= "</Site>";
echo $xml_output;
}
}
$n=new navigatie();
?>
/**
* @author damarez
*/
import org.asapframework.events.EventDelegate;
class nl.flymedia.asl.ui.Navigation extends MovieClip
{
private var xmlData:XML;
private var xmlNode:XMLNode;
private var naam:Array;
private var link:Array;
private var total:Number;
private var menu_btn:MovieClip;
private var label_txt:TextField;
private var menuArr:Array;
public function Navigation (timeline:MovieClip)
{
System.security.allowDomain ("www.thevalleyestate.com/");
xmlNode = this.xmlData.firstChild;
xmlData = new XML ();
loadData ("http://www.thevalleyestate.com/thevalley/nl/base_xml.php",timeline);
menuArr = new Array ();
trace (xmlData);
}
private function loadData (url:String, timeline:MovieClip)
{
xmlData.ignoreWhite = true;
xmlData.onLoad = EventDelegate.create (this, loadXML, timeline);
xmlData.load (url);
}
private function loadXML (timeline:MovieClip):Void
{
naam = [];
link = [];
total = xmlNode.childNodes.length;
for (var i:Number = 0; i < total; i++)
{
naam[i] = xmlNode.childNodes[i].childNodes[0].firstChild.nodeValue;
link[i] = xmlNode.childNodes[i].childNodes[1].firstChild.nodeValue;
}
getItems (timeline);
}
private function getItems (timeline:MovieClip):Void
{
for (var i:Number = 0; i < total; i++)
{
trace (i);
menuArr.push (menu_btn);
menu_btn.x += menu_btn.width * i;
menu_btn.y = Math.round ((menu_btn.height / 2));
menu_btn.onRelease = EventDelegate.create (timeline, changeOldContent, menu_btn, i);
startup ();
}
}
private function enableButtons ():Void
{
for (var i:Number = 0; i < menuArr.length; i++)
{
menuArr[i].enabled = true;
trace (menuArr[i]);
menuArr[i].onEnterFrame = EventDelegate.create (this, playBack, menuArr[i]);
}
}
private function playBack (but:MovieClip):Void
{
if (but._currentframe == 1)
{
delete but.onEnterFrame;
}
else
{
but.prevFrame ();
}
}
private function playForward (but:MovieClip):Void
{
if (but._currentframe == but._totalframes)
{
delete but.onEnterFrame;
}
else
{
but.nextFrame ();
}
}
private function startup ()
{
enableButtons ();
menuArr[0].enabled = false;
var lastFrame:Number = menuArr[0]._totalframes;
var total = menuArr.length;
menuArr[0].onEnterFrame = EventDelegate.create (this, playForward, menuArr[0]);
}
private function changeOldContent (menu_btn:MovieClip, i:Number, container:MovieClip):Void
{
enableButtons ();
menu_btn.enabled = false;
var lastFrame:Number = menu_btn._totalframes;
menu_btn.onEnterFrame = EventDelegate.create (this, playForward, menu_btn);
getURL (link[i], "_blank");
}
}