<?
include("config.php");
$i_input = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
$i_input .= "<root>\n";
for($i=0; $i < 5; $i++) {
$j=0;
if($i == 0) { $where_i = "g_best = 'y' order by no desc limit 0,4"; }
if($i == 1) { $where_i = "g_new = 'y' order by no desc limit 4, 4"; }
if($i == 2) { $where_i = "g_hot = 'y' order by no desc limit 8, 4"; }
if($i == 3) { $where_i = "g_best = 'y' order by no desc limit 12, 4"; }
if($i == 4) { $where_i = "g_new = 'y' order by no desc limit 16, 4"; }
$i_input .= "<rows category=\"$i\">\n";
$query="select * from goods where $where_i ";
$result=mysql_query($query);
while ($row= mysql_fetch_array($result)) {
$min_price_tmp=split("[|]",$row[goods_price]);
$min_price = split("[-]",$min_price_tmp[0]);
$mini_price = str_replace(",", "", $min_price[1]);
$mini_mileage = number_format($mini_price - ($mini_price*(0.1)));
$mini_member = number_format($mini_price - ($mini_price*(0.05)));
$goods_name =
$goods_name = iconv("euckr","utf-8",$row[goods_name]);
$zoom_link = "javascript:MM_openBrWindow('/zoomImg.php?imgfile_name=prog/goods/imgs/$row[goods_imgs]', 'bigPhoto$row[no]', 'width=200, height=200, resizeable=yes');";
$i_input .= "<row>\n";
$i_input .= "<order>$j</order>\n";
$i_input .= "<imgSrc><![CDATA[http://ifull.co.kr/prog/goods/imgs/".$row[goods_imgs]."]]></imgSrc>\n";
$i_input .= "<itemTitle><![CDATA[".$goods_name."]]></itemTitle>\n";
$i_input .= "<isSpecial>1</isSpecial>\n";
$i_input .= "<zoomSrc><![CDATA[".$zoom_link."]]></zoomSrc>\n";
$i_input .= "<price>".$min_price[1]."</price>\n";
$i_input .= "<price4Member>".$mini_member."</price4Member>\n";
$i_input .= "<saveAmount>".$mini_mileage."</saveAmount>\n";
$i_input .= "<link><![CDATA[/prog/shopping/goods_detail.php?goods_code=".$row[goods_code]."&sub_folder_code=".$sub_folder_code."&root_folder_code=shop&mode=$mode&keyword=$keyword&cpage=mainBest5&head_tf=$head_tf#".$row[goods_code]."]]></link>\n";
$i_input .= "</row>\n";
$j++;
}
$j =0;
$i_input .= "</rows>\n";
}
$i_input .= "</root>\n";
$fp = fopen("bestofbest.xml","w"); // 바로 생성처리 하기
fputs($fp, $i_input);
fclose($fp);
?>
생성된 처리결과 입니다.
그냥 코딩으로 전부 제작했습니다;;
좀더 열심히 하겠습니다.