Viewing file: minab.php (1.48 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', 'db10505e'); $rssfeed = '<?xml version="1.0" encoding="UTF-8"?>'; $rssfeed .= '<rss version="2.0">'; $rssfeed .= '<channel>'; $rssfeed .= '<title>Mina Business Servis</title>'; $rssfeed .= '<link>http://www.mina-info.me</link>'; $rssfeed .= '<description>Mina Ekonomski servis</description>'; $rssfeed .= '<language>sr</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 1000 "; $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/servisirss/biznis/stampa.php3?Id=' . $Id . '</link>'; $rssfeed .= '<pubDate>' . date("d M Y H:i p", strtotime($date)) . '</pubDate>'; $rssfeed .= '</item>'; } $rssfeed .= '</channel>'; $rssfeed .= '</rss>'; echo $rssfeed; ?>
|