$googlebase= $dom->appendChild($dom->createElement('channel')); $ctitle = $googlebase->appendChild($dom->createElement('title')); $ctitle->appendChild($dom->createTextNode("Put Your Store Name Here")); $cdesc = $googlebase->appendChild($dom->createElement('description')); $cdesc->appendChild($dom->createTextNode("Put a Description in Here")); $clink = $googlebase->appendChild($dom->createElement('link')); $clink->appendChild($dom->createTextNode("Your Web Address Here")); $ccopy = $googlebase->appendChild($dom->createElement('copyright')); $ccopy->appendChild($dom->createTextNode("2010 Your Company Name Here")); while ($row = mysql_fetch_array ($results)){ if ($row[filename] != NULL) { $image = 'http://www.yoursite.com/images/T/'.$row[filename]; //add element to $item = $googlebase->appendChild($dom->createElement('item')); //add element to $title = $item->appendChild($dom->createElement('title')); //add text node element to $title->appendChild($dom->createTextNode($row[product])); $link = $item->appendChild($dom->createElement('link')); $link->appendChild($dom->createTextNode("http://www.yoursite.com/product.php?productid=".$row[productid])); $description = $item->appendChild($dom->createElement('description')); $clean = preg_replace("/^[^a-z0-9]?(.*?)[^a-z0-9]?$/i", "$1", $row[descr]); $imgdesc = "
".$clean; $description->appendChild($dom->createTextNode($imgdesc." £".$row[price])); $id = $item->appendChild($dom->createElement('guid')); $id->appendChild($dom->createTextNode("http://www.yoursite.com/product.php?productid=".$row[productid])); // $price = $item->appendChild($dom->createElement('price')); // $price->appendChild($dom->createTextNode($row[price])); $brand = $item->appendChild($dom->createElement('category')); $brand->appendChild($dom->createTextNode($row[manufacturer])); $adddate = $item->appendChild($dom->createElement('pubDate')); $adddate->appendChild($dom->createTextNode(date('r',$row[add_date]))); //echo $image."
"; $enclosure = $item->appendChild($dom->createElement('enclosure')); //var_dump($enclosure); $enclosure->setAttribute('url', $image); $enclosure->setAttribute('length', $row[image_size]); $enclosure->setAttribute('type', $row[image_type]); } } $dom->formatOutput = true; $dom->substituteEntities =true; $xml=$dom->saveXml($googlebase); //$xml = utf8_encode($dom->saveXml()); $ourFileName = "feed.xml"; $ourFileHandle = fopen($ourFileName, 'w') or die("can't open file"); fwrite($ourFileHandle, ""); //fwrite($ourFileHandle, "xmlns:c='http://base.google.com/cns/1.0'"); fwrite($ourFileHandle, $xml); fwrite($ourFileHandle, ""); fclose($ourFileHandle); //echo"

"; //echo $xml; echo "Feed Created"; //var_dump($dom); mysql_close; ?>