所以我想要做的是:
运行以下查询:SELECT FW_ArtSrcLink FROM FW_ArtSrc WHERE OneSet =1输出两个结果:
我想将两个结果追加到$result变量中,并通过结果与$r中的结果(如图中所示为2)相互关联,然后输出$r的部分,从而生成
# Source of Article Info-->
$SrcTitle=$newsStory[$i]->title;
$SrcLink=$newsStory[$i]->link;
# Actual News Article Info -->
$title=$newsStory[$i]->title;
$desc=$newsStory[$i]->description;看起来像下面的完整代码,目前只从sports.yahoo.com/tennis/rss.xml的第二个结果中提取:
## Loop through results from mysql
try{
#connection string
// $dbconn = new PDO('mysql:host=localhost;port=3306;dbname=mydatabase',array(PDO::ATTR_PERSISTENT => true));
$dbconn = new PDO('mysql:host=localhost;port=3306;dbname=mydatabase','myuser','mypass',array(PDO::ATTR_PERSISTENT => true));
$q = $dbconn->prepare("SELECT FW_ArtSrcLink FROM FW_ArtSrc WHERE OneSet=1");
#call stored proc
$q->execute();
#get the rows into an array
$result = $q->fetchAll();
$newsStory[] = array();
foreach($result as $r){
$xmlUrl = $r['FW_ArtSrcLink'];
$ConvertToXml = simplexml_load_file($xmlUrl);
# -> Setup XML
$newsStory = $ConvertToXml->channel->item;
}
# -----> Load News Stories
for($i = 0;$i
# Source of Article Info-->
$SrcTitle=$newsStory[$i]->title;
$SrcLink=$newsStory[$i]->link;
# Actual News Article Info -->
$title=$newsStory[$i]->title;
$desc=$newsStory[$i]->description;
# Output Results ------------>
echo '
';
echo ''.'Title:'.$title.''.'(via: '.$SrcTitle.''.'
';
//echo 'Link:'.$link.'
';
echo 'Description'.$desc.'
';
##echo 'count '.count($result);
echo '
';
}
} // try我在这里做错了什么?
来自单个数据库结果的简单输出示例,我将其称为硬编码结果而不是动态使用
$xmlUrl ="http://edge1.catalog.video.msn.com/videoByTag.aspx?tag=Fox%20Sports_NBA%20news&ns=MSNVideo_Top_Cat&mk=us&sd=-1&sf=ActiveStartDate&vs=0&ind=&ps=&rct=&ff=88&responseEncoding=rss&title=FOX%20Sports%20Video%20on%20MSN:%20NBA&template=foxsports&p=foxsports";
$ConvertToXml = simplexml_load_file($xmlUrl);: