PHP's simplest example tutorial for generating XML documents

<?php

MySQL tutorial _connect (' localhost ', ' root ', ' 1****** ') or Die (' database server no exists! ');
mysql_select_db (' wk ') or Die (' Database error! ');
mysql_query ("SET NAMES ' GBK '");//set document CharSet encode

function Createxml () {
$tag = 0;
$head = ' <?xml version= ' 1.0 ' encoding= ' gb2312 '?> <channel> ';
$sql = "SELECT * from Wk_works ORDER by id DESC";

$res =mysql_query ($sql) or Die (Mysql_error ());
while ($rs =mysql_fetch_array ($res)) {
if ($tag ==0) {
$STP = "<item class=" ". $rs [' W_type ']." "uid=". $rs [' m_id ']. "" Name= ". $this->get_name ($rs [' m_id '])." "Portrait = "". $rs [' W_head ']. "" Blogname = "". $rs [' Blogname ']. "" Url= "user.php?id=". $rs [' m_id ']. "poll =". $rs [' W_support ']. "" ></item> ";
}else{

$STP. = "<item class=" ". $rs [' W_type ']." "uid=". $rs [' m_id ']. "Name=". $this->get_name ($rs [' m_id ']). "" Portrait= "". $rs [' W_head ']. "" Blogname = "". $rs [' Blogname ']. "" Url= "user.php?id=". $rs [' m_id ']. "poll =". $rs [' W_ Support ']. "></item>";
}

$tag + +;
}
$foot = ' </channel> ';
$cont =fopen ("Xml/111cn.net.xml", ' W ');
Fwrite ($cont, $head. $stp. $foot);
Fclose ($cont);
}

function Get_name ($id) {
$sqle = "Select Id,m_uid from Wk_member where id= ' $id '";
$relt = mysql_query ($sqle);
$reus = Mysql_fetch_array ($relt);
return $reus [' M_uid '];
}
?>

Original reprint of this site annotated: www.111cn.net