สอบถามแนวทางการเขียน RSS Feed แบ่งตามหมวดแบบนี้ครับ

		if($type2 == "feed_th"){
		$savexml_th = $savepath."/"."xml_feed".$varCat2.".xml";
		$realfile = "xml_feed".$varCat2.".xml";  /// เอาตัวแปร VarCat2 ซึ่งก็คือไอดี หมวดหมู่มาต่อท้าย
		
		$objFopen = fopen($savexml_th, 'w');
		fwrite($objFopen, $xml);
		fclose($objFopen);
		}

function feedXML() {
	
	    $type2 = JRequest::getVar('type');
		//$title = JRequest::getVar('title');
		$varCat2 = JRequest::getInt('id_xml_feed');
		$limit2 = JRequest::getInt('limit2');
		$orderby2 = JRequest::getInt('orderby');
		$byfield2 = JRequest::getInt('byfield');
		
		//echo $varCat2;
		//echo "<br>";
		//echo $type2;
		//exit;
	   
	    $field = "id,title,title_en,introtext,introtext_en,created";
		
		if($byfield == 0):
			$by = "id";
		elseif($byfield == 1):
			$by = "created";
		endif;
		
		if($ordeyby == 0):
			$order = "DESC";
		else:
			$order = "ASC";
		endif;
		
		$orderbys = "ORDER BY ".$by.' '.$order."";
		
		$db = JFactory::getDbo();
		$sql = "SELECT ".$field." FROM #__k2_items WHERE catid = ".$varCat2." ".$orderbys." LIMIT 	".$limit2." ";
		$db->setQuery($sql);
		//$rs = $db->loadAssocList();
		$rs2 = $db->loadObjectList();
		
		//print_r($rs2);
	    //exit;
	
	    $xml = '<?xml version="1.0" encoding="UTF-8"?>'."\n";
		$xml.= '<rss version="2.0">'."\n";
		$xml.= '<channel>'."\n";
		
		foreach($rs2 as $items):
		

		if($type2 == "feed_th"):
		
		$introtext = strip_tags($items->introtext);
		$pathimg = $Domain."media/k2/items/cache/".md5("Image".$items->id)."_S.jpg";
		$pathurl = $Domain."index.php?option=com_km&view=km&layout=detail&k2id={$items->id}";

		$xml.= '<item>'."\n"; 
		$xml.= '<title>'.$items->title .'</title>'."\n";
		$xml.= '<description><![CDATA[<p>'.mb_substr($introtext,0,500,'UTF-8').'</p>]]></description>'."\n";
		$xml.= '<link><![CDATA['.$pathurl.']]></link>'."\n";
		$xml.= '<pubDate>'.date("D, d M Y H:i:s O").'</pubDate>'."\n";
		$xml.= '</item>'."\n"; 
		
		endif;
		
		endforeach;
		
		$xml.= '</channel>'."\n";
		$xml.= '</rss>'."\n";
		
		//echo $xml;
		//exit;
		
		$savepath = JPATH_ROOT.DS.'media'.DS.'k2'.DS.'xml_feed';//Save Folder
		
		if($type2 == "feed_th"){
		$savexml_th = $savepath."/"."xml_feed".$varCat2.".xml";
		$realfile = "xml_feed".$varCat2.".xml";
		
		$objFopen2 = fopen($savexml_th, 'w');
		fwrite($objFopen2, $xml);
		fclose($objFopen2);
		}
		
		$link = "linktest";
		
		if($varCat2 != 0):
		
		$db3 = JFactory::getDbo();
		$sql3 = "INSERT INTO #__feed_rss ( `id_cat`, `file_feed`,`link` ) VALUES ( '$varCat2', '$realfile', '$link')";
		$db3->setQuery($sql3);
	    $db3->query();
		
		//print_r ($db3);
		//exit;
		
		
		endif;

	}
	
	
	}

////คือคำสั่ง replace นี่จะต้องดักก่อนเข้า insert ไหมครับ เช่นสมมุติครับ หรือต้อง IF หรือ select รอบแรกก่อน จะ insert ครับ

$db3 = JFactory::getDbo();
		$sql3 = "INSERT INTO #__feed_rss ( `id_cat`, `file_feed`,`link` ) VALUES ( '$varCat2', '$realfile', '$link')";
		$db3->setQuery($sql3);
	    $db3->query();

		if($varCat2 == $varCat2){
		
		$sql3 = " REPLACE INTO #__feed_rss ( `id_cat``, `file_feed`, `link` ) VALUES( '$varCat2', '$realfile', '$link' )";
		$db3->setQuery($sql3);
		//$rs = $db->loadAssocList();
		$rs3 = $db3->loadObjectList();
		
		} else {
		
		$sql3 = "INSERT INTO #__feed_rss ( `id_cat`, `file_feed`,`link` ) VALUES ( '$varCat2', '$realfile', '$link')";
		$db3->setQuery($sql3);

$search_str = "select id from #__feed_rss where id_cat='$varCat2' and file_feed='$realfile' ";
$db->setQuery($search_str);
$search_result = $db->loadObjectList();
$field_id = $search_row = $search_result[0] ? ' id = ' .  $search_row->id . ', ' : '';

$sql3 = " REPLACE INTO #__feed_rss set $field_id id_cat='$varCat2', file_feed='$realfile', link='$link' ";

function downloadXML(){
	
		$db = JFactory::getDbo();
	
		$id = JRequest::getInt('id');
		$sql = "SELECT id,file_name FROM #__attach_xml WHERE id = ".$id."";
		$db->setQuery($sql);
		$rs = $db->loadAssocList();
		
		foreach ($rs as $row); 

		$file = JPATH_ROOT . DS . 'media' . DS . 'k2' . DS .'xml_rss' .DS.$row['file_name'];

		if (file_exists($file)) {
			header('Content-Description: File Transfer');
			header('Content-Type: application/octet-stream');
			header('Content-Disposition: attachment; filename='.basename($file));

			readfile($file);
			exit;
		}
	}

$realname = $_FILES['attachment_file']['name'][0];
						//$filename2 = $_FILES['attachment_file']['tmp_name'][0];
						//echo $filename2;
						//exit;
						if (($_FILES['attachment_file']['type'][0] == "text/plain")) {
						
						$filetmp_name = $_FILES['attachment_file']['tmp_name'][0];
						$fname = iconv("TIS-620","UTF-8",$filetmp_name);
						$data = fread($fh = fopen($fname, "r"),3000);
						
						$fline = fgetcsv($fh, "4096" );
						fclose($fh); }

$realname = $_FILES['attachment_file']['name'][0];
						//$filename2 = $_FILES['attachment_file']['tmp_name'][0];
						//echo $filename2;
						//exit;
						if (($_FILES['attachment_file']['type'][0] == "text/plain")) {
						
						$filetmp_name = $_FILES['attachment_file']['tmp_name'][0];
						$fname = iconv ( 'tis620', 'utf8/IGNORE', $filetmp_name);// ลองเปลี่ยนตามพี่ว่าครับ มันไม่บันทึกลงเบสอ่ะครับ
						$data = fread($fh = fopen($fname, "r"),3000);
						
						$fline = fgetcsv($fh, "4096" );
						fclose($fh); }

$txt = '   abcd efgh  ijklmno       zzzz';
$rs = preg_replace ('/\s+/', ' ', $txt);
echo $rs;

$realname = $_FILES['attachment_file']['name'][0];
						//$filename2 = $_FILES['attachment_file']['tmp_name'][0];
						//echo $filename2;
						//exit;
						if (($_FILES['attachment_file']['type'][0] == "text/plain")) {
						
						$filetmp_name = $_FILES['attachment_file']['tmp_name'][0];
						$filetmp_name2 = preg_replace ('/\s+/', ' ', $filetmp_name);
						$fname = iconv("TIS-620","UTF-8",$filetmp_name2);
						//$fname = iconv("TIS-620","UTF-8/IGNORE", $filetmp_name);
						$data = fread($fh = fopen($fname, "r"),3000);						
						$fline = fgetcsv($fh, "4096" );
						fclose($fh); }