สอบถามการเขียน Rss Feed ดึงข้อมูลมาจาก DB แบบ Write ทีละหลายๆไฟล์ตามเงื่อนไข

<?
include("connect.php");

$sql = " SELECT a.news_id as aid, b.date as bdate, a.org  , a.act , a.title , a.per , a.loc, b.url , b.news_name, a.date as adate, b.type_id from news_su  a, news_web b where a.news_id=b.news_id ";

$charset = "SET NAMES 'utf8'";
mysql_query($charset);
$query = mysql_db_query($dbName,$sql);

$data = '<?xml version="1.0" encoding="UTF-8"?>'."\n";
$data .= '<rss version="2.0">'."\n";
$data .= '<channel>'."\n";
$data .= '<title>News Extraction</title>'."\n";
$data .= '<description>News Interesting</description>'."\n";
$data .= '<link>http://su.ac.th</link>'."\n";
//$data .= '<pubDate>'.date("D, d M Y ").'</pubDate>'."\n";

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

$data .= '<item>'."\n";
$data .= '<title>'.$result[news_name].'</title>'."\n";
$data .= '<link>'.$result[url].'</link>'."\n";

$data .= '<pubDate>'.$result[bdate].'</pubDate>'."\n"; //เวลา 

$data .= '<description>'.$result[type_id].''.$result[org].''.$result[act].''.$result[title].'
'.$result[per].''.$result[loc].''.$result[loc].''.$result[adate].'</description>'."\n"; 
$data .= '</item>'."\n";
}
$data .= '</channel>'."\n";
$data .= '</rss>'."\n";
if($result[type_id] == "1")
{
	$f = fopen( 'rss_1.xml' , 'w' ); //ส่วนของการสร้างไฟล์ XML
	fputs( $f , $data );
	fclose( $f );
}
	else
{
	$f = fopen( 'rss_2.xml' , "w"); //ส่วนของการสร้างไฟล์ X
	fputs( $f , $data );
	fclose( $f );
}


?>

<?php
include("connect.php");

//set encoding
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");

$sql = " SELECT a.news_id as aid, b.date as bdate, a.org  , a.act , a.title , a.per , a.loc, b.url , b.news_name, a.date as adate, b.type_id from news_su  a, news_web b where a.news_id=b.news_id ";
mysql_select_db($dbName);
$query = mysql_query($sql);

$head = <<<XML
<?xml version="1.0" encoding="UTF-8"?>
	<rss version="2.0">
		<channel>
			<title>News Extraction</title>
			<description>News Interesting</description>
			<link>http://su.ac.th</link>
XML;

$type = array();

while($result = mysql_fetch_array($query)) {
	if(!array_key_exists($result['type_id'])) 
		$type[$result['type_id']] = '';
	$type[$result['type_id']] .= sprintf('
			<item>
				<title>%s</title>
				<link>%s</link>
				<pubDate>%s</pubDate>
				<description>%s %s %s %s
				%s %s %s %s</description>
			</item>',
			$result['news_name'],
			$result['url'],
			$result['bdate'],//เวลา 
			$result['type_id'],
			$result['org'],
			$result['act'],
			$result['title'],
			$result['per'],
			$result['loc'],
			$result['loc'],
			$result['adate']
			);
}
$foot = <<<XML
		</channel>
	</rss>
XML;

foreach($type AS $key => $data){
	$f = fopen('rss_'.$key.'.xml', 'w');
	fputs($f, $head.$data.$foot);
	fclose( $f );
}
?>