Publicado em 11 de dez.

[Resolvido] Erro ao gerar Feed

Bom dia,

Estou com um grande problema, estou utilizando um código em PHP que encontrei na internet(Eu acho que foi aqui no fórum) para gerar o feed no meu site, porem o sistema gera o feed mais não aceita algumas tags.

Código para gerar o feed

<?php

header("Content-type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>";

// Set RSS version.

echo "
<rss version=\"2.0\"> ";

// Start the XML.

echo "<channel>
<title>Apostilas na Web</title>
<link>[http://www.apostilasnaweb.com/";](http://www.apostilasnaweb.com/)

// Create a connection to your database.

$host = '*******';
$user = '********';
$password = '********';
$msg[0] = "Conexão com o banco de dados falhos. Tente novamente!";
$msg[1] = "Não foi possivel selecionando o banco de dados. Tente novamente!";
$conexao = mysql_connect("$host", "$user", "$password") or die($msg[0]);
mysql_select_db("*****", $conexao) or die($msg[1]);
// Query database and select the last 10 entries (change number 10 to desired number of items in rss).
$data = mysql_query("SELECT id, dmname, dmdescription, DATE_FORMAT(dmdate_published, '%d/%m/%Y - %H:%i') as dmdate_published FROM jos_docman WHERE published=1 ORDER BY id DESC LIMIT 30");

while($row = mysql_fetch_array($data)) {

echo "
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,".$row[id]."](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,)
<title>".$row[dmname]."</title>
<description>".$row[dmdate_published]."</description>
</item>";
}
echo "
</channel>
</rss>";
?>
 O sistema não aceita a tag **<date> </date>** entre outras, só aceita as que estão no próprio código !

 Olha que engraçado, para eu colocar a data, tive que usar a tag **<description> </description>** .

 

 Alguem sabe o que está acontecendo ?

Discussão (5)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

~TiuTalk~· 12 de dez.

Amigo, o sistema não aceita a tag <date> por que ela não existe :D

Veja por exemplo o feed aqui do Jornal do Brasil:

http://jbonline.terra.com.br/extra/rsstrjb.xml

Repare que esse é o formato do <item>:

**<item>**

**<title>**Entidades criticam decisão do júri de João Roberto **</title>**

**<link>**[http://www.jb.com.br/extra/2008/12/11/e111211644.html](http://www.jb.com.br/extra/2008/12/11/e111211644.html)**</link>**

**<description>**Felipe Sáles, Jornal do Brasil RIO - As declarações do governador Sérgio Cabral, do secretário de Segurança Pública, José Mariano Beltrame, e do próprio policial militar William de Paula – réu confesso do crime – não foram suficientes para co...**</description>**

**<pubDate>**Thu, 11 Dec 2008 01:01:00 GMT**</pubDate>**

**<lastBuildDate>**Thu, 11 Dec 2008 01:01:00 GMT**</lastBuildDate>**

**</item>**

O <pubDate> é a data de publicação, e o <latdBuildDate> é a data da ultima modificação do item.

Veja aqui uma lista de todos os elementos de um Feed RSS.

Espero ter ajudado :)

Apostilas na Web· 12 de dez.

~TiuTalk~

Valeu pela explicação cara, eu que estava viajando então !

Abraços

Apostilas na Web· 14 de dez.

~TiuTalk~

Cara, eu estou utilizando agora uma tag correta, porem mesmo assim o não consigo visualizar a data da publicação !

Veja o Feed: http://www.apostilasnaweb.com/feed.php

Código do Feed:

<?xml version="1.0" encoding="ISO-8859-1"?>
<rss version="2.0"> <channel>
<title>Apostilas na Web</title>
<link>[http://www.apostilasnaweb.com/](http://www.apostilasnaweb.com/)
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,300](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,300)
<title>Instalação do Ubuntu 8.04</title> <pubDate>30/11/2008 - 05:43</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,299](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,299)

<title>Apostila Ubunto 8.04</title> <pubDate>29/11/2008 - 10:39</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,298](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,298)
<title>Fundamentos de Rede </title> <pubDate>26/11/2008 - 05:22</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,297](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,297)
<title>Entendendo o Javascript</title> <pubDate>13/11/2008 - 08:40</pubDate>

</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,296](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,296)
<title>Conhecendo o Ajax</title> <pubDate>13/11/2008 - 08:40</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,295](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,295)
<title>Ajax e Dwr</title> <pubDate>13/11/2008 - 08:39</pubDate>
</item>

<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,294](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,294)
<title>Web 2.0 + Ajax</title> <pubDate>13/11/2008 - 08:38</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,293](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,293)
<title>Guia de referência</title> <pubDate>13/11/2008 - 08:37</pubDate>
</item>
<item>

<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,292](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,292)
<title>Introdução ao Javascript</title> <pubDate>13/11/2008 - 08:37</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,291](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,291)
<title>Dominando o Javascript</title> <pubDate>13/11/2008 - 08:36</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,290](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,290)

<title>Desmistificando o Ajax</title> <pubDate>13/11/2008 - 08:35</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,289](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,289)
<title>Aprenda Java Script</title> <pubDate>13/11/2008 - 08:35</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,288](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,288)
<title>Papel Timbrado</title> <pubDate>13/11/2008 - 08:06</pubDate>

</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,287](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,287)
<title>Maquiagem digital</title> <pubDate>13/11/2008 - 08:05</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,286](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,286)
<title>Criando um olho</title> <pubDate>13/11/2008 - 08:05</pubDate>
</item>

<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,285](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,285)
<title>Criando Arvores</title> <pubDate>13/11/2008 - 08:04</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,284](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,284)
<title>Como criar um olho realista</title> <pubDate>13/11/2008 - 08:03</pubDate>
</item>
<item>

<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,283](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,283)
<title>Manutenção de Impressoras</title> <pubDate>30/10/2008 - 08:48</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,282](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,282)
<title>Apostila Flash CS3</title> <pubDate>30/10/2008 - 08:44</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,281](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,281)

<title>Apostila completa - Nod32</title> <pubDate>30/10/2008 - 08:35</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,280](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,280)
<title>Curso de Java Modulo III</title> <pubDate>30/10/2008 - 08:29</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,279](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,279)
<title>Curso de Java Modulo II</title> <pubDate>30/10/2008 - 08:28</pubDate>

</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,278](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,278)
<title>Curso de Java Modulo I </title> <pubDate>30/10/2008 - 08:27</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,277](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,277)
<title>Instalando Qmail + vpopmail + mysql + QmailAdmin + QmailScanner</title> <pubDate>27/10/2008 - 23:14</pubDate>
</item>

<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,276](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,276)
<title>Configurando um Squid</title> <pubDate>27/10/2008 - 23:01</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,275](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,275)
<title>Construindo Roteadores com Linux</title> <pubDate>27/10/2008 - 22:51</pubDate>
</item>
<item>

<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,274](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,274)
<title>Voip</title> <pubDate>27/10/2008 - 22:01</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,273](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,273)
<title>IPV6</title> <pubDate>27/10/2008 - 21:57</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,272](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,272)

<title>Manutenção em placa mãe</title> <pubDate>27/10/2008 - 21:46</pubDate>
</item>
<item>
<link>[http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,271](http://www.apostilasnaweb.com/component/option,com_docman/task,doc_details/gid,271)
<title>Arquitetura para redes Wireless</title> <pubDate>20/10/2008 - 07:53</pubDate>
</item>
</channel>
</rss>

~TiuTalk~· 14 de dez.

Não tenho certeza se é isso, mas vale a pena tentar:

Coloque as tags em cada linha, não duas na mesma linha como você fez em:

<rss version="2.0"> <channel>

e aqui:

<title>Construindo Roteadores com Linux</title> <pubDate>27/10/2008 - 22:51</pubDate>

---

Usei um validador no seu RSS e descobri as seguints falhas:

O elemento **<channel>** tem que te ter a tag **<description>**, assim:

 

<channel>
<title>Apostilas na Web</title>
<link>[http://www.apostilasnaweb.com/](http://www.apostilasnaweb.com/)
<description>DESCRIÇÃO DO SEU SITE</description>

(...) Lista de <item>s (...)

</channel>

Depois, o formato de data que você usando: 27/10/2008 - 22:51, tá errado, teria que ser assim, por exemplo:

Wed, 02 Oct 2002 08:00:00 EST

Isso você gera com o date('r') do PHP.

Acho que isso resolve :)

Apostilas na Web· 14 de dez.

Agora consegui resolver o meu problema...

Eu estava usando esse código:

$data = mysql_query("SELECT id, dmname, dmdescription, DATE_FORMAT(dmdate_published, '%d/%m/%Y - %H:%i') as dmdate_published FROM jos_docman WHERE published=1 ORDER BY id DESC LIMIT 30");
 Então eu modifiquei o código e estou usando esse aqui:

 

$data = mysql_query("SELECT id, dmname, dmdescription, dmdate_published FROM jos_docman WHERE published=1 ORDER BY id DESC LIMIT 30");
 Grato pela ajuda....

Tópico resolvido !