PHP, XML og CSS/XSL

Kode 

<?php
	// Fiktiv sql
	$query = mysql_query('SELECT * FROM postz');
	
	// SimpleXMLElement er guf: http://dk.php.net/manual/da/ref.simplexml.php
	$xml = new SimpleXMLElement('<guestbook></guestbook>');
	$posts = $xml->addChild('posts');
	
	while($row == mysql_fetch_assoc($query)) {
		$post = $posts->addChild('post');
		$post->addChild('name',$row['name']);
		$post->addChild('comment',$row['comment']);
	}

	// Headers til browseren
	header('Pragma: public');
	header('Expires: 0');
	header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
	header('Cache-Control: private',false);
	header('Content-Type: application/force-download');	
	header('Content-Disposition: attachment; filename="guestbox.xml";');

	// Indhold til filen
	print $xml->asXML();

	// Dø script!
	die();
?>

Kode 

<?
	$sql = "SELECT * FROM tagwall WHERE Id='". $_GET['userid'] ."' ORDER BY Dato DESC";
	$result =  mysql_query($sql, $conn) or die (mysql_error());

	// SimpleXMLElement er guf: [p"]http://dk.php.net/manual/da/ref.simplexml.php[/url]

	$xml = new SimpleXMLElement('<guestbook></guestbook>');
	$posts = $xml->addChild('posts');
	
	while($newArray = mysql_fetch_array($result)) {
		$post = $posts->addChild('post');
		$post->addChild('id',$newArray['Id']);
		$post->addChild('nr',$newArray['Nr']);
		$post->addChild('fra_id',$newArray['Fra']);
		$post->addChild('fra_nick',$newArray['Fra_nick']);
		$post->addChild('dato',$newArray['Dato']);
		$post->addChild('text',$newArray['Text']);
	}

	// Headers til browseren
	header('Pragma: public');
	header('Expires: 0');
	header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
	header('Cache-Control: private',false);
	header('Content-Type: application/force-download');	
	header('Content-Disposition: attachment; filename="guestbook.xml";');

	// Indhold til filen
	print $xml->asXML();

	// Dø script!
	die();
?>

Kode 

<?
	$sql = "SELECT * FROM tagwall WHERE Id='". $_GET['userid'] ."' ORDER BY Dato DESC";
	$result =  mysql_query($sql, $conn) or die (mysql_error());

	// SimpleXMLElement er guf: [p"]http://dk.php.net/manual/da/ref.simplexml.php[/url]

	$xml = new SimpleXMLElement('<guestbook></guestbook>');
	$posts = $xml->addChild('posts');
	
	while($newArray == mysql_fetch_assoc($result)) {
		$post = $posts->addChild('post');
		$post->addChild('id',$newArray['Id']);
		$post->addChild('nr',$newArray['Nr']);
		$post->addChild('fra_id',$newArray['Fra']);
		$post->addChild('fra_nick',$newArray['Fra_nick']);
		$post->addChild('dato',$newArray['Dato']);
		$post->addChild('text',$newArray['Text']);
	}

	// Headers til browseren
	header('Pragma: public');
	header('Expires: 0');
	header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
	header('Cache-Control: private',false);
	header('Content-Type: application/force-download');	
	header('Content-Disposition: attachment; filename="guestbook.xml";');

	// Indhold til filen
	print $xml->asXML();

	// Dø script!
	die();
?>