Php从数据库里读出数据，并生成xml文件

 

<?php
/*php 生成xml文件*/

//数据库连接

$conn = mysql_connect('localhost','root','adminadmin');
mysql_select_db('bjgmzj');
mysql_query('set names "gb2312"');

//创建文件夹目录

$dir = dirname(__FILE__);
$dir = $dir.'\\'.date('Y-m-d');
if(!file_exists($dir))
{
 mkdir($dir,0777);
}

//查询前10条
//$data = array();

$filename='article.xml';
$sql = "select * from king__article order by kid desc limit 10 ";
$query = mysql_query($sql);

$line = array();

while($row= mysql_fetch_array($query))
{

$line[]=$row;

}

$xml ='';
$xml="<?xml version='1.0' encoding='utf-8'?>\n";
$xml.="<books>\n";
foreach($line as $k=>$v)
{   echo '<pre>';
 print_r($line);

 echo '------';
 echo $v;
$xml.='<ktitle>'.$line[$k]['ktitle']."</ktitle>\n";
$xml.='<kpath>'.$line[$k]['kpath']."</kpath>\n";

}
$xml.="</books>\n";

file_put_contents($dir.'\\'.$filename,$xml);

 

 
 //$xml.=$aa;

//print_r($xml);

 

echo '生成成功';

 

?>