dongxi0523 2013-01-15 16:05
浏览 31
已采纳

我的RSS代码有什么问题? [关闭]

I need a fresh pair of eyes to look at my RSS code because it is outputting a blank page. However, when I run var_dump() I am receiving output. Can you please let me know what is going?

 if($_GET['uid'] == ''){
    $usrid = $udata['user_name'];
}else{
    $usrid = $_GET['uid'];
}
    $udata = $userObj->fetchUser(array("user_name"=>$usrid));

$rssfeed = '<?xml version="1.0" encoding="utf-8"?>';
$rssfeed .= '<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">';
$rssfeed .= '<channel>';
$rssfeed .= '<title>Brags By '.$udata['full_name'].'</title>';
$rssfeed .= '<link>'.BASE_URL.'</link>';
$rssfeed .= '<description>'.SITE_TITLE2.'Be amazing. Get noticed.</description>';
$rssfeed .= '<language>en-us</language>';
$rssfeed .= '<copyright>Copyright (C) '.date("Y").' ' . SITE_TITLE2 . '</copyright>'; 

$dbSel = $db->dbh->prepare("SELECT *,UP.id as bragid FROM ".USERS_BRAG." as UP,".USERS." as U  where                   U.id = UP.user_id AND UP.status = :stat AND U.id= :uID ORDER BY UP.id DESC");    
$dbSel->execute(array(':stat'=>'1',':uID'=>$udata['id']));
$result=$dbSel->fetchAll(PDO::FETCH_ASSOC);
//
while($row = $result) {

    //echo var_dump($row);die;

    $img="<img src='".BASE_URL."public/bragimages/thumb/".$row['brag']."'>";
    $link=BASE_URL."bragdetails/".$row['bragid'];

    $rssfeed .= "<item>";
    $rssfeed .= "<title>".$row['brag_desc']."></title>";
    $rssfeed .= "<description>".$img."></description>";
    $rssfeed .= "<link>".$link."></link>";
    $rssfeed .= "<pubDate>".date("D, d M Y H:i:s O", strtotime($row['added_date']))."></pubDate>";
    $rssfeed .= "</item>";
}

$rssfeed .= '</channel>';
$rssfeed .= '</rss>';

echo $rssfeed;

Thanks for the help.

  • 写回答

1条回答 默认 最新

  • dta25920 2013-01-15 16:20
    关注

    use foreach instead

    foreach ($result as $row) {
    ...
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 AT89C51控制8位八段数码管显示时钟。
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 下图接收小电路,谁知道原理
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
  • ¥15 ETLCloud 处理json多层级问题
  • ¥15 matlab中使用gurobi时报错
  • ¥15 这个主板怎么能扩出一两个sata口