我的第一个rss

最新推荐文章于 2024-09-14 12:53:27 发布

原创最新推荐文章于 2024-09-14 12:53:27 发布 · 481 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#rss #mysql #query #encoding #database #header

PHP 专栏收录该内容

52 篇文章

订阅专栏

LiftofftoSpaceExploration提供最新动态，包含MYRss订阅链接、RSS描述、Logo及数据库内容展示。

crss.php
----------------------------------------------
<?
$rss_name = 'MY Rss';
$rss_link = 'http://localhost/rss/';
$rss_desc = 'Liftoff to Space Exploration.';
$rss_logo = 'http://localhost/rss/images/rss_0.gif';
$charset = 'utf-8';
header("Content-type: application/xml;charset=".$charset."");

echo <<<EOD
<?xml version="1.0" encoding="$charset" ?>
<rss version="2.0">
    <channel>
        <title>$rss_name</title>
        <link>$rss_link</link>
        <description>$rss_desc</description>
        <generator>My Rss v1.0</generator>
        <image>
            <url>$rss_logo</url>
            <title>$rss_name</title>
            <link>$rss_link</link>
        </image>
EOD;

$conn = mysql_connect('localhost', 'root', '123456') or die('Could not connect: ' . mysql_error());
mysql_select_db('vdigital', $conn) or die ('Can/'t use database : ' . mysql_error());
$str = "SELECT * FROM `content` GROUP BY `id` ORDER BY `id` ASC LIMIT 5";
$result = mysql_query($str) or die("Invalid query: " . mysql_error());
if($result)
{
    //ѭ
    while ($arr = mysql_fetch_array($result)){
        echo <<<EOD
        <item>
            <title><![CDATA[{$arr['content_model']}]]></title>
            <link>http://localhost/rss/rss.php?id={$arr['id']}</link>
            <description><![CDATA[{$arr['SD']}]]></description>
            <author>{$arr['writer']}</author>
            <pubDate>{$arr['inserttime']}</pubDate>
        </item>
EOD;
    }
}
    echo <<<EOD
    </channel>
</rss>
EOD;
?>