PHP - Get Content From Rss Feed

Hi, I have a small piece of code that creates an RSS feed using a mysql database. The issue is the page itself is blank however if I right click and view source I can see all the feed there. I convert the dat time field into a standard RSS date field. The web address is http://vinovote.com/news/feed.php

My code is as follows

Code: [Select]
<?php echo '<?xml version="1.0" encoding="UTF-8"?>'; ?>



<rss version="2.0">
<channel>
<title>Vinovote.com</title>
<description>The Latest News And Views From Around The Web</description>
<link>http://www.vinovote.com/</link>
<copyright>Your copyright information</copyright>

<?php
require_once('../Connections/connection.php');
mysql_select_db($database_vinovotedb, $vinovotedb);
$doGet = mysql_query("SELECT
feed_content.feed_content_id,
feed_content.feed_id,
feed_content.url,
feed_content.title,
feed_content.content,
feed_content.item_time,
Date_FORMAT(feed_content.item_time,'%a, %d %b %Y %T') AS pubDate
FROM feed_content
order by item_time desc
LIMIT 50
", $vinovotedb) or die(mysql_error());

while($result = mysql_fetch_array($doGet)){
?>

     <item>
        <title> <?php echo $result['title']; ?></title>
        <description> <?php echo $result['content'];?></description>
        <link><?php echo $result['url'];?></link>
        <pubDate> <?php echo  $result['pubDate']; ?></pubDate>
     </item> 
<?php } ?> 

</channel>
</rss>

hi all,

i am trying to just get a couple things from this RSS feed: http://www.sierraavalanchecenter.org/bottomline-rss.php

I would like to grab the danger rose image on the left, the text that tells of the Avalanche danger ie... "Avalanche Danger Remains LOW..." and the date.

I have tried using a few things like:
$html = 'http://www.sierraavalanchecenter.org/bottomline-rss.php';$dom = new DOMDocument;$dom->loadHTML($html);$xpath = new DOMXPath($dom);$res = $xpath->query('//div[@id="dangericon"]');if ($res->item(0) !== NULL) {  $test = $res->item(0)->nodeValue;}()

...without any luck. Anyone have some advice for me?

thanks!

Hello!
I'm trying to develop some kind of RSS news aggregator and I want to show only feeds younger than 1day. I figured i could transform RSS pubDate to timestamp (strtotime()), but there are some feeds without timestamp (like: http://izklop.com/xmldata/rsslinks.xml). Is there any other way to do it, so I could find timestamp from those feeds without pubdate?

If there isn't any other way, do You think it is ok, to just show last 5 feeds?

I hope I made my self clear, and please forgive me for my English

I have tried sitemap.org and a few others but have not found anything that will give the results I am after.

I have a blog site that has a URL and a Description for the URL and wish to have the description show as the anchor text which is linked to the URL, all data is taken from MySQL.

Does anyone have a code that will generate something like this ?

Hi,

I've written some code to take information from an SQL database and write it out in the RSS format (Although it doesn't validate).

The problem is i'd like the page to have the .rss (or .xml) file extension, I'm not sure if there's any advantages in having this but thought i'd ask.

I've got the following code:

Code: [Select]
<?php 
header('Content-type: text/xml');
print '<?xml version="1.0"?>';
print '<rss version="2.0">';
        print '<channel>';
include("phpfunctions.php");
db_connect();

//select all from users table
$select="SELECT title, link, description FROM news";
$result = mysql_query($select) or die(mysql_error());

//If nothing is returned display error no records
if (mysql_num_rows($result) < 1) {
die("No records");
}

//loop through the results and write each as a new item

while ($row = mysql_fetch_assoc($result)) {
    $item_title = $row["title"];
    $item_link = $row["link"];
    $item_desc = $row["description"];

        print '<item>';
           print '<title>' . $item_title . '</title>';
            print '<link>' . $item_link . '</link>';
            print '<description>' . $item_desc . '</description>';
        print '</item>';


}
print '</channel>';
print '</rss>';

?>


This seems to work fine as i get what i expect and i'm assuming i can do the same to output .xml but is there a way to have it in a proper .rss / .xml file so that an aggregator or someone could read this properly.

Cheers,

Reece

hi i want to add some content to my site using xml rss

i have a feed i want to show, and the only thing i can find to show it on my page or widgets
but they dont look like i want it to look, so i want to make a php script that reads the xml file and then parses it into my website

dont know if this is even possible ...

but if its possible, is it also possible to filter the feed on certain keywords?

I have a php script that saves some data as a .xml document.  When I view this in my browser I can subscribe to the feed (I am using firefox).  However I asked someone else to see if they could subscribe (they were using IE) but the couldn't.  Therefore how can users subscribe to my feed?  Will only some be able to subscribe?

Thanks for any help. 

Hello all
That forum is my last desperate attemp to do what i want to do.
Ok here is the story

I want to create  a simple rss feed in conjuction with php and mysql.
I dont want admin areas ect , i just want when i insert a new listing to my database to be able shown up to my (future) rss subscribers.
To be more technically specific i want to show to my surfers updates about 2 tables in my database not all the tables.
The example i found so far were about only 1 table, plus i was encounting errors to my script.

I would like some ideas, directions if someone is kind enough to help a sad developer 

Thanks in advance!

I'm been searching and can't seem to figure this out.

I want to take an RSS feed from a news site and display it on my site.

any help?

Does anybody have any recommendations for PHP scripts to pull in a Twitter feed? I've tried several but each seem to just give me error messages!

I basically just need a PHP alternative so that the tweets can be read by search engines.

Thanks.

I'm not sure you can do this but i would like to grab the image gif from the rss feed of yahoo weather. For instance

http://weather.yahooapis.com/forecastrss?p=77056

I pulled this script from a tutorial online and it works great for displaying the temperature and condition and i realize those values are located within the xml. But i would like to grab the image located between the <description> tags (if you look at the source of the rss feed). I don't know if this is possible or not. Thanks.

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Yahoo! Weather API RSS</title>
<?php 
function retrieveYahooWeather($zipCode="92832") {
    $yahooUrl = "http://weather.yahooapis.com/forecastrss";
    $yahooZip = "?p=$zipCode";
    $yahooFullUrl = $yahooUrl . $yahooZip; 
    $curlObject = curl_init();
    curl_setopt($curlObject,CURLOPT_URL,$yahooFullUrl);
    curl_setopt($curlObject,CURLOPT_HEADER,false);
    curl_setopt($curlObject,CURLOPT_RETURNTRANSFER,true);
    $returnYahooWeather = curl_exec($curlObject);
    curl_close($curlObject);
    return $returnYahooWeather;
}
$localZipCode = "77056"; // Houston, Tx
$weatherXmlString = retrieveYahooWeather($localZipCode);
$weatherXmlObject = new SimpleXMLElement($weatherXmlString);
$currentCondition = $weatherXmlObject->xpath("//yweather:condition");
$currentTemperature = $currentCondition[0]["temp"];
$currentDescription = $currentCondition[0]["text"];

?>
</head>
<body>
<h1>Houston, TX</h1>
<ul>
    <li>Current Temperatu <?=$currentTemperature;?>&deg;F</li>
    <li>Current Description: <?=$currentDescription;?></li>
</ul>

</body>
</html>

Hi, I am reading a feed with this code


foreach ($xml->channel->item as $item) { 
echo $item->title;
echo '<br>';
}

and outputs
Code: [Select]
title 1
title 2
title 3
.... and so on until 10
I wants in reverse order to output last rss feed first like:
Code: [Select]
title 10
title 9
title 8
.... and so on until 1, how can i do it? i tried with rsort($xml->channel->item) butt getting this error:
Quote

Warning: rsort() expects parameter 1 to be array, object given in

Thanks for help

Hey all,

I'm currently making myself a blog website from scratch. It's sort of my personal project; I'm using it to get a feel for PHP (and it'd look great on my resume!).

Anyway, I'm using the following PHP code to get the items from my RSS feed, and display them. Problem is, my first item shows twice! I'm thinking it's a problem with my loop, but I'm not sure. Any ideas:

My PHP code to render my RSS is as follows:

<?php
         //Purpose: This loads the XML document using the DOMParser, and mixes it w/ HTML to style and format it.
         try
         {
         $xmldoc = new DOMDocument();
         $xmldoc->load('test_RSS_feed.xml');
         $content = null; //HTML mixed with XML results go here
         $allitems = $xmldoc->getElementsByTagName('item');
         foreach ($allitems as $item)
         {
         //get ALL instances of wanted element(s)
         $titles = $item->getElementsByTagName('title');
         $dates = $item->getElementsByTagName('pubDate');
         $descriptions = $item ->getElementsByTagName('description');
         
         //will include the CSS classes for these eventually!
         $content.= ('
            <ul class ="blog_entry">
               <li class="title_entry">
               '.$titles->item(0)->nodeValue.
               '</li>
               <li class="date_entry">
               '.$dates->item(0)->nodeValue.
               '</li>
               <br>
               <li class="description_entry">
               '.$descriptions->item(0)->nodeValue.
               '</li>
            </ul>
            <br><br><br>');
         echo $content;
         }
         }
         catch(Exception $e)
         {
         echo $e->getMessage();
         }
         ?>

And the XML in my RSS feed is as follows:


<?xml version= "1.0" encoding = "UTF-8" ?> <!--Every XML doc starts with this -->
<?xml-stylesheet type="text/css" href="sample_xml_css.css" ?> <!--stylesheet for RSS feed-->
<rss version = "2.0">
   <channel>
      <!--RSS feed information-->
      <title>My first RSS feed</title>
      <description>This is my first foray into RSS. I may use this to create a blog!</description>
      <lastBuildDate>Mon, Oct. 11, 2010 13:13:26 GMT</lastBuildDate> <!--date format complies to different standards-->
      <webMaster>mserrano0410@gmail.com</webMaster> <!--has email of webmaster-->
         <item>
            <title>My first item; this is the title.</title>
            <link>http://www.example.com/sample_item.html</link> <!--provides a link to the RSS item; required-->
            <pubDate>Mon, Oct 11, 2010 13:15:20 GMT</pubDate> <!--Every date complies to formatting standards-->
            <description>We are now inside of an item; this is a description tag.</description>
         </item>
         <item>
            <title>My second item.</title>
            <link>http://www.google.com</link>
            <pubDate>Fri, Oct 15, 2010 23:02:40 GMT</pubDate>
            <description>This is a second helping of examples biatch!</description>
         </item>
         <!--can create as many items as you want, but it MUST have:
            1) Title
            2) Link to item; when clicked, takes you directly to that item. This is a SEPARATE HTML document!
            3) Description
            -->
   </channel>
</rss>

Thanks in advance,
Marvin

I'm creating an RSS feed that can be read through an Android app.  I've pulled in RSS feeds from CNN and other places and they all seem to have the same setup.  They have
Title1|||Description1|||Link1
Title2|||Description2|||Link2
ect.

How do I create the 3 | (Shift + Backslash) and not have them show up in the feed when viewed through a browser?  It's been a while since I've done PHP and I don't remember doing anything like this.

Hello, I got myself a RSS feed for my posts, which can be seen he
codexplained.tk/feed/rss.php

This is the code used for it:
Code: [Select]
<?php
// header
header("Content-Type: application/xml; charset=UTF-8");
require("../widgets/functions.php");

// Make a MySQL Connection
connectToDB();

echo '
<rss version="2.0">
<channel>
<title>Codexplained RSS Feed</title>
<link>http://www.codexplained.tk</link>
<description>For all your coding needs</description>
<language>en</language>
';

$query = "SELECT * FROM posts ORDER BY Id DESC LIMIT 15";
$res = mysql_query($query);

$num=mysql_numrows($res);

$i = 0;
while ($i < $num)
{
$subject=mysql_result($res,$i,"Subject");
$id=mysql_result($res,$i,"Id");
$content=mysql_result($res,$i,"Content");

$content = str_replace("<br />", "\n", $content);
$content = str_replace("<?php", "&lt;?php", $content);
$content = str_replace("?>", "?&gt;", $content);
$content = htmlentities($content);
$content = substr($content, 0,400);

echo '
<item>
<title>'.$subject.'</title>
<link>http://www.codexplained.tk/index.php?postDetails='.$id.'</link>
<description>'.$content.'</description>
</item>';
$i++;
}
echo '
</channel>
</rss>
';
?>
Now, I wish to know how to make the time display correctly, and not just according to refresh date.

I tried something with <pubDate> but I couldn't figure it out. Help would be appreciated!