dongxi0523 2013-01-15 08: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 08:20
    关注

    use foreach instead

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

报告相同问题?