'0' order by a.`ca_id`"; $result = sql_query($sql); $xml = new SimpleXMLElement(""); $xml->addAttribute("xmlns:xmlns:g", "http://base.google.com/ns/1.0"); $xml->addAttribute("version", "2.0"); $channel = $xml->addChild("channel"); $title = $channel->addChild("title", "쇼핑몰피드"); $link = $channel->addChild("link", G5_URL); $description = $channel->addChild("description", ""); for ($i = 0; $row = sql_fetch_array($result); $i++) { $it_id = $row['it_id']; $it_title = $row['it_name']; $it_link = shop_item_url($row['it_id']); $it_basic = strip_tags($row['it_basic']); $it_image = ""; for($j = 1; $j <= 10; $j++) { $img = $row['it_img'.$j]; if(empty($img)) continue; $it_image = G5_DATA_URL."/item/".$img; break; } $stock = "in_stock"; if($row['it_stock_qty'] <= 0) { $stock = "out_of_stock"; } else { if($row['in_stock'] <= 0) $stock = "out_of_stock"; } $item = $channel->addChild("item"); // 필수 입력 항목 $item->addChild("g:g:id", $it_id); $item->addChild("title", $it_title); $item->addChild("description", $it_basic); $item->addChild("link", $it_link); $item->addChild("g:g:image_link", $it_image); $item->addChild("g:g:availability", $stock); if($row['it_cust_price'] != null && $row['it_cust_price'] > 0) { $item->addChild("g:g:price", sprintf('%.2fKRW', $row['it_cust_price'])); $item->addChild("g:g:sale_price", sprintf('%.2fKRW', $row['it_price'])); } else { $item->addChild("g:g:price", sprintf('%.2fKRW', $row['it_price'])); } // 선택적 입력 항목 $item->addChild("g:g:condition", "new"); $cate_array = array($row['ca_id'], $row['ca_id2'], $row['ca_id3']); $adult = "no"; foreach($cate_array as $key => $var) { if(empty($var)) continue; if(in_array(1, $category_adult_array[$var])) { $adult = "yes"; } } $item->addChild("g:g:adult", $adult); } header('Content-type: text/xml'); echo $xml->asXML(); ?>