PHP - Parse Xml From Rss Feed Into Php?

echo "</select></td>\r\n  </tr>\r\n \r\n <tr>\r\n <td align=\"right\">Total Views Allowed:</td>\r\n <td><input type=\"text\" id=\"ad_total_views\" style=\"width:50px;\" value=\"\" disabled=\"disabled\" /> <label><input type=\"checkbox\" checked=\"checked\" onclick=\"if(this.checked==true){$('#ad_total_views').val('');$('#ad_total_views').attr('disabled','disabled');}else{$('#ad_total_views').val('');$('#ad_total_views').removeAttr('disabled');$('#ad_total_views').focus()}\" />Unlimited</label></td>\r\n          </tr>\r\n            \r\n            <tr>\r\n              <td align=\"right\">Total Clicks  Allowed:</td>\r\n              <td><input type=\"text\" id=\"ad_total_clicks\" style=\"width:50px;\" value=\"\" disabled=\"disabled\" /> <label><input type=\"checkbox\" checked=\"checked\" onclick=\"if(this.checked==true){$('#ad_total_clicks').val('');$('#ad_total_clicks').attr('disabled','disabled');}else{$('#ad_total_clicks').val('');$('#ad_total_clicks').removeAttr('disabled');$('#ad_total_clicks').focus()}\" />Unlimited</label></td>\r\n          </tr>\r\n        </table></td>\r\n   </tr>\r\n    <tr bgcolor=\"#FFFFFF\">\r\n     <td class=\"td_th\" align=\"center\">Smarty Code (Developer)</td>\r\n     <td>{\$ads->getAdCode(<span id=\"smartycode\">1</span>)}</td>\r\n   </tr>\r\n    <tr bgcolor=\"#FFFFFF\">\r\n      <td class=\"td_th\" align=\"center\">&nbsp;</td>\r\n      <td><input type=\"button\" value=\"Create New Campaign\" onclick=\"new_ad()\" /></td>\r\n    </tr>\r\n    </TBODY></TABLE>\r\n<br />\r\n\r\n<TABLE cellSpacing=1 cellPadding=4 width=\"100%\"  border=0>\r\n  <TBODY>\r\n  <TR class=\"td_title\">\r\n    <TD  colSpan=7>Ad Campaigns</TD></TR>\r\n  <TR bgColor=#ffffff>\r\n  \r\n    <TD width=\"10%\" align=\"center\" class=\"td_th\">&nbsp;</TD>\r\n    <TD width=\"4%\" align=\"center\" class=\"td_th\">ID</TD>\r\n    <TD width=\"29%\" align=\"center\" class=\"td_th\">Campaign Name</TD>\r\n    <TD width=\"12%\" align=\"center\" class=\"td_th\">Start Date</TD>\r\n    <TD width=\"11%\" align=\"center\" class=\"td_th\">End Date</TD>\r\n    <TD width=\"17%\" align=\"center\" class=\"td_th\">Viewed / Views Allowed</TD>\r\n    <TD width=\"17%\" align=\"center\" class=\"td_th\">Clicked / Clicks Allowed</TD>\r\n    </TR>\r\n ";

   $BoxSize = array("smallbox" = array("length" => 12, "width" => 10, "depth" => 2.5),
      "mediumbox" = array("length" => 30, "width" => 20, "depth" => 4),
      "largebox" = array("length" => 60, "width" => 40, "depth" => 11.5));
      

Hi

I get an error when trying to add a link to my rss feed
Code: [Select]
<link>http://www.jobjar.co.uk/jobdetails.php?keywords=lon0014&page=1</link>Something to do with the last part of the link because when I remove the page=1 it then works. How can I resolve this?

Also, will I have to manually update my xml file for rss feeds or can it be updated automatically? If so how?

Thanks

Hi All,

I'm trying to incorporate a BBC Sport RSS Feed into my website.


The following code will show me the news feeds as text and I can include the url's as text also but want to turn this into a clickable url. How do I do this, I cant work it? please help. 

$feed_url = "http://newsrss.bbc.co.uk/rss/sportonline_uk_edition/football/teams/s/shrewsbury/rss.xml";

  // Get data from feed file
  $response = file_get_contents($feed_url);
   
  // Insert XML into structure
  $xml = simplexml_load_string($response);

  // Browse structure
  foreach($xml->channel->item as $one_item)
    echo $one_item->title."<BR>"; 

I'm lost on this one. This code works fine in Firefox, but not my IE8. I think it has something to do with the <?php echo '<?xml version="1.0" encoding="utf-8"?>'; ?> line, but i'm not sure. IE says "Internet Explorer cannot display this feed" and "A name contained an invalid character. Line: 7 Character: 701." Any ideas?

<?php header('Content-Type: text/xml'); ?>
<?php echo '<?xml version="1.0" encoding="utf-8"?>'; ?>
<?php include('../vars.php'); ?>
<rss version="2.0">
  <channel>
    <title>Newsfeed</title>
    <description>News and Updates</description>
    <link>http://www.example.com</link>
    <language>en-us</language>
<?php
require_once("../conn.php");

  $query = "SELECT * FROM news";
  $data = mysqli_query($db, $query);

  while ($row = mysqli_fetch_array($data)) {

    echo '<item>';
    echo '  <title>' . $row['title'] . ' - ' . substr($row['content'], 0, 32) . '...</title>';
    echo '  <link>http://www.example.com/new.php?newsid=' . $row['newsid'] . '</link>';
    //echo '  <pubDate>' . $row['date'] . '</pubDate>';
    echo '  <description>' . $row['content'] . '</description>';
    echo '</item>';
  }
?>

  </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!

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

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. 

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?

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!

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 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 ?

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>