<?php
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 ='<?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'];
}
?>
本站原创转载注明: www.111cn.net