Viewing file:  mina-e.php (1.5 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
header("Content-Type: application/rss+xml; charset=UTF-8");
DEFINE ('DB_USER', 'us10505a');
DEFINE ('DB_PASSWORD', 'proba');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'db10505g');
$rssfeed = '<?xml version="1.0" encoding="UTF-8"?>';
$rssfeed .= '<rss version="2.0">';
$rssfeed .= '<channel>';
$rssfeed .= '<title>Mina General News Service</title>';
$rssfeed .= '<link>http://www.mina-info.me</link>';
$rssfeed .= '<description>Mina General News Service</description>';
$rssfeed .= '<language>en-uk</language>';
$rssfeed .= '<copyright>Copyright (C) 2017 MINA</copyright>';
$connection = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
or die('Could not connect to database');
mysql_select_db(DB_NAME)
or die ('Could not select database');
$query = "SELECT title,Slag,Id,date FROM news ORDER BY ID DESC LIMIT 50 ";
$result = mysql_query($query) or die ("Could not execute query");
while($row = mysql_fetch_array($result)) {
extract($row);
$rssfeed .= '<item>';
$rssfeed .= '<title>' . $title . '</title>';
$rssfeed .= '<description>' . $Slag . '</description>';
$rssfeed .= '<link>http://www.mina-info.me/servisi/faxeng/servisfaxeng.php3#' . $Id . '</link>';
$rssfeed .= '<pubDate>' . date("D, d M Y H:i:s O", strtotime($date)) . '</pubDate>';
$rssfeed .= '</item>';
}
$rssfeed .= '</channel>';
$rssfeed .= '</rss>';
echo $rssfeed;
?>
|