dongpao1905 2014-01-24 00:33
浏览 28

创建一个rss feed并在Mysql上遇到一些麻烦

I can't seem to be able to get any images or titles from the mysql database even though I am connected, to the actual rss feed, and i am not sure what I am doing wrong.

<?php
define ("DB_HOST", "xxx"); // set database host
define ("DB_USER", "xxx"); // set database user
define ("DB_PASS","fgbsh"); // set database password
define ("DB_NAME","adfgadg"); // set database name

$link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
$db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");

$query = "SELECT story, description, pic, url FROM ".posts." WHERE status=1 ORDER BY   time_added desc";
$getBlogDisplay = mysql_query($query);

header("Content-type: text/xml"); 

echo "<?xml version='1.0' encoding='UTF-8'?> 
<rss version='2.0'>
<channel>
<title></title>
<link></link>
<description></description>
<language>en-us</language>"; 


while($dataBlogDisplay = mysql_fetch_array($getBlogDisplay)){

 $title         = $dataBlogDisplay['story']; 
 $link          = $dataBlogDisplay['url'];
$description    = $dataBlogDisplay['pic'];

echo "<item> 
<title>$title</title>
<link>$url</link>
<description>$description</description>
</item>"; 
} 
echo "</channel></rss>";
?>

and I am pretty sure my tables are named correctly too. This is the tutorial I have been using

http://www.discussdesk.com/create-rss-feed-with-php-mysql.htm

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 网络设备配置与管理这个该怎么弄
    • ¥20 机器学习能否像多层线性模型一样处理嵌套数据
    • ¥20 西门子S7-Graph,S7-300,梯形图
    • ¥50 用易语言http 访问不了网页
    • ¥50 safari浏览器fetch提交数据后数据丢失问题
    • ¥15 matlab不知道怎么改,求解答!!
    • ¥15 永磁直线电机的电流环pi调不出来
    • ¥15 用stata实现聚类的代码
    • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
    • ¥20 docker里部署springboot项目,访问不到扬声器