Parašysiu PHP skriptą, kaip sukurti svetainės RSS srautą.
<?php
// Srauto pavadinimas
$rss_title= “Pavadinimas”;
// Svetaines adresas (su http://)
$rss_site= “http://www.google.lt”;
// Svetaines aprasymas (nebutina)
$rss_description= “Keletas zodziu apie svetaine.”;
// RSS srauto kalba (pvz., “lt”=lietuvių, “en”=anglų)
$rss_language=”lt”;
header(“Content-Type: text/xml;charset=utf-8″);
// Jungiames prie duomenu bazes
$dbhost = “localhost”;
$dbusername= “vartotojas”;
$dbpassword = “slaptazodis”;
$dbname = “bazespavadinimas”;
mysql_connect($dbhost,$dbusername,$dbpassword);
@mysql_select_db($dbname) or die(“Nepavyko prisijungti prie duomenu bazes”);
// Paimam norimus irasus (pvz., naujausiu straipsniu pavadinimus) is duomenu bazes
$query = “SELECT *
FROM lentele
ORDER BY data DESC
LIMIT 10″;
$result = mysql_query($query) or die(“Bloga uzklausa”) ;
$numrows = mysql_num_rows($result);
echo
‘<?xml version=”1.0″ encoding=”utf-8″ ?>
<rss version=”2.0″>
<channel>
<title>’.$rss_title.’</title>
<link>’.$rss_site.’</link>
<description>’.$rss_description.’</description>
<language>’.$rss_language. ‘</language>’;
for($i=0;$i<$numrows;$i++)
{
$subject = mysql_result($result,$i,’question’); // pavadinimas
$subject = htmlentities(strip_tags($subject));
$aprasymas = mysql_result($result,$i,’answer’);
$aprasymas = htmlentities(strip_tags($aprasymas));
$aprasymas = stripslashes($aprasymas);
$aprasymas=ucfirst($aprasymas);
$pos = strrpos(substr($aprasymas , 0 , 250) ,’ ‘ ) ;
$aprasymas=substr($aprasymas, 0 , $pos).”…”;
$link = mysql_result($result,$i,’id’);
$pubdate = mysql_result($result,$i,’data’);
echo ‘<item>
<title>’.$subject.’</title>
<link>’.$rss-site.’/’.$link.’.html</link>
<description>’.$aprasymas.’</description>
<pubDate>’.$pubdate.’</pubDate>
</item>
‘;
}
mysql_close();
echo ‘ </channel>
</rss>’;
?>
