<?php /* * @author Andr� Louren�o Pedroso * @email alp.pedroso@gmail.com * */ // Include para conec��o com bd - Encontra-se no phpbrasil.com // funcoes: abreBd() // fechaBd() include "con_bd.inc"; $data = date("d/m/Y"); abreBD(); $sql = "SELECT * FROM artigos"; $query = mysql_query($sql); // print o cabe�alho do xml header("Content-type: application/xml"); // cabe�alho do RSS echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>"; ?> <rss version="2.0"> <channel> <title>Titulo site - Not�cias</title> <link>Link do site</link> <description>Breve descri��o sobre o conteudo do site</description> <language>pt-br</language> <copyright>Site - Todos os direitos reservados.</copyright> <lastBuildDate><?=$data;?></lastBuildDate> <ttl>20</ttl> <?php while($result = mysql_fetch_array($query)) { ?> <item> <title><?=$result[titulo];?></title> <autor><?=$result[autor];?></autor> <description><?=$result[texto];?></description> <datePosted><?=date("d-m-Y",strtotime($result[data]));?></datePosted> </item> <?php } fechaBD(); ?> </channel> </rss>