<?php
$aConfig['DataBaseNaam'] = "";
$aConfig['DataBaseServer'] = "localhost";
$aConfig['DataBaseGebruikersnaam'] = "";
$aConfig['DataBaseWachtwoord'] = "";
?>
<?php
function showFeed($sSite, $sUrl, $iItems = 10, $iCache = 10, $sLayout = '<a href="{link}" target="_blank">{title}</a><br />')
{
$rQuery = mysql_query(
"SELECT
Id,
(TIMESTAMPDIFF(MINUTE, Date, NOW()) >= " . $iCache . ")
AS Cache
FROM
Feeds
WHERE
Site = '" . mysql_real_escape_string($sSite) . "'
ORDER BY
Id ASC
LIMIT 1"
);
if(!$rQuery)
{
throw new Exception("Something went wrong while executing the MySQL-query: " . mysql_error());
}
if(!mysql_num_rows($rQuery) OR ($aItem = mysql_fetch_assoc($rQuery) AND $aItem['Cache'] == 1))
{
$rQuery = mysql_query(
"DELETE FROM
Feeds
WHERE
Site = '" . mysql_real_escape_string($sSite) . "'"
);
if(!$rQuery)
{
throw new Exception("Something went wrong while executing the MySQL-query: " . mysql_error());
}
$oFeed = new DOMDocument();
$oFeed->load($sUrl);
$aItems = $oFeed->getElementsByTagName("item");
foreach($aItems AS $oItem)
{
$oItemTitle = $oItem->getElementsByTagName("title");
$aItem['Title'] = $oItemTitle->item(0)->nodeValue;
$oItemLink = $oItem->getElementsByTagName("link");
$aItem['Link'] = $oItemLink->item(0)->nodeValue;
$oItemDescription = $oItem->getElementsByTagName("description");
$aItem['Description'] = $oItemDescription->item(0)->nodeValue;
$oItemDate = $oItem->getElementsByTagName("pubDate");
$aItem['Date'] = $oItemDate->item(0)->nodeValue;
$oItemCategory = $oItem->getElementsByTagName("category");
$aItem['Category'] = $oItemCategory->item(0)->nodeValue;
$rQuery = mysql_query(
"INSERT INTO
Feeds
(
Site,
Title,
Link,
Description,
ItemDate,
Category,
Date
)
VALUES
(
'" . mysql_real_escape_string($sSite) . "',
'" . mysql_real_escape_string($aItem['Title']) . "',
'" . mysql_real_escape_string($aItem['Link']) . "',
'" . mysql_real_escape_string($aItem['Description']) . "',
'" . mysql_real_escape_string($aItem['Date']) . "',
'" . mysql_real_escape_string($aItem['Category']) . "',
NOW()
)"
);
if(!$rQuery)
{
throw new Exception("Something went wrong while executing the MySQL-query: " . mysql_error());
}
}
}
$rQuery = mysql_query(
"SELECT
*
FROM
Feeds
WHERE
Site = '" . mysql_real_escape_string($sSite) . "'
ORDER BY
Id ASC
LIMIT " . $iItems
);
if(!$rQuery)
{
throw new Exception("Something went wrong while executing the MySQL-query: " . mysql_error());
}
if(mysql_num_rows($rQuery))
{
while($aItem = mysql_fetch_assoc($rQuery))
{
$sLayoutToShow = str_replace("{title}", htmlspecialchars(stripslashes($aItem['Title'])), $sLayout);
$sLayoutToShow = str_replace("{link}", htmlspecialchars(stripslashes($aItem['Link'])), $sLayoutToShow);
$sLayoutToShow = str_replace("{description}", htmlspecialchars(stripslashes($aItem['Description'])), $sLayoutToShow);
$sLayoutToShow = str_replace("{date}", htmlspecialchars(stripslashes($aItem['ItemDate'])), $sLayoutToShow);
$sLayoutToShow = str_replace("{category}", htmlspecialchars(stripslashes($aItem['Category'])), $sLayoutToShow);
echo $sLayoutToShow;
}
}
}
?>
<?php
try
{
if(!mysql_connect($aConfig['DataBaseServer'], $aConfig['DataBaseGebruikersnaam'], $aConfig['DataBaseWachtwoord']))
{
throw new Exception("Something went wrong while connecting to the MySQL-server: " . mysql_error());
}
if(!mysql_select_db($aConfig['DataBaseNaam']))
{
throw new Exception("Something went wrong while connecting to the MySQL-database: " . mysql_error());
}
}
catch(Exception $e)
{
die($e->getMessage());
}
?>
