code snippets and example scrips, MySql, Website Design and Development

Create RSS feed from DB

Leave a comment

RSS.class.php


getDetails() . $this->getItems();
}
private function dbConnect()
{
DEFINE ('LINK', mysql_connect (DB_HOST, DB_USER, DB_PASSWORD));
}
private function getDetails()
{
$details = '


Quickplay Blog http://www.quickplaysport.com Quickplaysport French News
EN
';

/* can add this in if needs be

image_title
image_url image_link image_width
image_height

*/
return $details;
}
private function getItems()
{

$itemsTable = "aw_blog";
$this->dbConnect($itemsTable);
$query = "SELECT * FROM ". $itemsTable . " WHERE store_id = 0 AND status = 1 ORDER BY post_id DESC ";
$result = mysql_db_query (DB_NAME, $query, LINK);
$items = '';
while($row = mysql_fetch_array($result))
{

$link = "http://www.quickplaysport.com/blog/" . $row['identifier'];
$attribution_link = "The article " . $row['title'] . " first appeared on Quickplaysport.com

";

$items .= '
' . $row['title'] . ' ' . $link . '
';
}
$items .= '
';
return $items;
}
}
?>

[/code]

mysql_connect.php

index.php


GetFeed();
?>