这款教程是非常简单的,我们来看这款生成xml文档实例,就是把数据库的内容读出来,然后再用fopen生成一个.xml文档的文件就OK了。
<script>ec(2);</script>
mysql教程_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 =' ';
$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 = "- get_name($rs['m_id'])."" portrait="".$rs['w_head']."" blogname = "".$rs['blogname']."" url="user.php?id=".$rs['m_id']."" poll = "".$rs['w_support']."" >
";
}else{
$stp.= "- get_name($rs['m_id'])."" portrait="".$rs['w_head']."" blogname = "".$rs['blogname']."" url="user.php?id=".$rs['m_id']."" poll = "".$rs['w_support']."" >
";
}
$tag++;
}
$foot ='';
$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'];
}
?>
本站原创转载注明: www.111cn.net