Her er hvad jeg lige hurtigt fik strikket sammen:
feed.php:
<?
header("Content-Type: application/xml; charset=ISO-8859-1");
include("RSS.class.php");
$rss = new RSS();
echo $rss->GetFeed();
?>
RSS.clas.php:
<?
class RSS
{
public function RSS()
{
require_once ('mysql_connect.php');
}
public function GetFeed()
{
return $this->getDetails() . $this->getItems();
}
private function dbConnect()
{
DEFINE ('LINK', mysql_connect (DB_HOST, DB_USER, DB_PASSWORD));
}
private function getDetails()
{
$details = '<?xml version="1.0" encoding="ISO-8859-1" ?>
<rss version="2.0">
<channel>
<title>Design Specialisten Magazine RSS</title>
<link>www.designspecialisten.dk</link>
<description>Denne RSS side indeholder de artikler som kan læses på Design Specialisten Magazine</description>
<language>da</language>'
return $details;
}
private function getItems()
{
$itemsTable = "tutorials";
$this->dbConnect($itemsTable);
$query = "SELECT * FROM ". $itemsTable ."ORDER BY `id` ASC";
$result = mysql_db_query (DB_NAME, $query, LINK);
$items = '';
while($row = mysql_fetch_array($result))
{
$items .= '<item>
<title>'. $row["title"] .'</title>
<description>'. $row["manchet"] .'></description>
<link>http://www.designspecialisten.dk/magazine/tutorialvisning.php?id='. $row['id'] .'</link>
</item>';
}
$items .= '</channel>
</rss>';
return $items;
}
}
?>
mysql_connect.php(ret til):
<?
DEFINE ('DB_USER', 'your_username');
DEFINE ('DB_PASSWORD', 'your_password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'your_databasename');
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );
?>