ให้ xml เรียกใช้ Database เนื่องจากโปรแกรมตัวหนึ่งเรียกใช้ User และ Pass จากไฟล์ XML

<Root>
	<User>
		<Username>test6</Username>
		<Password>b51e8dbebd4ba8a8f342190a4b9f08d7</Password>
	</User>
</Root>

<?
function writeXML($xml)
{
	$fp = fopen('user.xml', 'w+');
	fwrite($fp,$xml);
	fclose($fp);
}

function Connect()
{
	global $conn;
	$hostname = "localhost";  
	$username = "root";  
	$password = "1234"; 
	$dbname = "test"; 
		
	$conn = mysql_connect( $hostname, $username, $password ); 

	if ( ! $conn )   die ( "ไม่สามารถติดต่อกับ MySQL ได้" ); 
	mysql_select_db ( $dbname, $conn )or die ( "ไม่สามารถเลือกฐานข้อมูลได้" ); 
	$charset = "SET NAMES 'tis620'";
	mysql_query($charset);
}

Connect();
$xml = new DOMDocument('1.0','UTF-8');
$root_node = $xml->createElement( "Root" );

$result = mysql_query("SELECT * FROM user");
while($data = mysql_fetch_row($result))
{
	$user_node = $xml->createElement( "User" );
	$username_node = $xml->createElement("Username",$data[0]);
	$password_node = $xml->createElement("Password",$data[1]);

	$user_node->appendChild($username_node);
	$user_node->appendChild($password_node);

	$root_node->appendChild($user_node);
}
$xml->appendChild( $root_node);
$text = $xml->saveXML();

writeXML($text);

header( "content-type: application/xml; charset=utf-8" );
echo $text;
?>

<?
function writeXML($xml)
{
	$fp = fopen('user.xml', 'w+');
	fwrite($fp,$xml);
	fclose($fp);
}

function Connect()
{
	global $conn;
	$hostname = "localhost";  
	$username = "root";  
	$password = "1234"; 
	$dbname = "work"; 
		
	$conn = mysql_connect( $hostname, $username, $password ); 

	if ( ! $conn )   die ( "ไม่สามารถติดต่อกับ MySQL ได้" ); 
	mysql_select_db ( $dbname, $conn )or die ( "ไม่สามารถเลือกฐานข้อมูลได้" ); 
	$charset = "SET NAMES 'tis620'";
	mysql_query($charset);
}

Connect();
$xml = new DOMDocument('1.0','UTF-8');
$root_node = $xml->createElement( "Users" );

$result = mysql_query("SELECT * FROM user");
while($data = mysql_fetch_row($result))
{
	$user_node = $xml->createElement( "User",$data[0]);//<User>test85</User>

	$opt1_node = $xml->createElement("Option",$data[1]); //<Option>b51e8dbebd4ba8a8f342190a4b9f08d7</Option>
	$att_name1 = $xml->createAttribute("Name");  //<Option Name="Pass">...</Option>
	$txt_pass = $xml->createTextNode("Pass"); 
	$att_name1->appendChild($txt_pass);
	$opt1_node->appendChild($att_name1);

	$opt2_node = $xml->createElement("Option",$data[2]); //<Option>member</Option>
	$att_name2 = $xml->createAttribute("Name"); //<Option Name="Group">...</Option>
	$txt_group = $xml->createTextNode("Group"); 
	$att_name2->appendChild($txt_group);
	$opt2_node->appendChild($att_name2);
	
	$root_node->appendChild($user_node);
	$root_node->appendChild($opt1_node);
	$root_node->appendChild($opt2_node);
}
$xml->appendChild( $root_node);
$text = $xml->saveXML();

writeXML($text);

header( "content-type: application/xml; charset=utf-8" );
echo $text;
?>