PHP - Trouble Parsing An Rss/xml Feed To Array

Hi,
I've run into a problem, or rather users of the ap I'm developing are likely to run into a problem.

I'm using simplexml with curl to parse RSS feeds.  Mostly that works just fine.

The trouble I've run into is that if a user is using feedburner.  If they enter the feedburner url (http://feeds2.feedburner.com/blah) when asked for the feed they want parsed it is not a problem.

If however they give the original feed url (http://mysite/feed) then the parser cannot load the feed.

The relevant code is:
Code: [Select]
$settings['feed-url']='http://mysite/feed';

//Fetch the RSS feed
$ch = curl_init( $settings['feed-url'] );
if(!($ch)) echo "Could not initialise feed";
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
if(!$feed = simplexml_load_string ( curl_exec($ch) )) echo "Could not load feed ".$settings ['feed-url'];
curl_close($ch);
That will result in the message displayed being "Could not load feed http://mysite/feed".
If I switched the feed to be http://feeds2.feedburner.com/blah then it would work perfectly.

I could tell people to just use their feedburner address, but it would be better if they could put in either.  My browser can handle it, so my ap should be able to handle it too.

Any ideas?  I can't find this problem mentioned anywhere. 

Hi,
Need help in parsing the . I am new to php and need to parsing and print only few elements in the arrary
 I have an array as below:

Array ( [@attributes] => Array ( [WARRANTYCATEGORY] => Customer Warranty [NA_RATING] => [TAGCATEGORY1] => [TAGCATEGORY1DESC] => [TAGCATEGORY2] => [RESPONSEDATE] => 08-14-2006 04:40:40 PM [CASEID] => 1435435 [DUTYMANAGERAPPROVALTEXT] => [COUNTER] => 0 [DESCRIPTION] => SPRLSL:Cluster Notification  [NA_BUGNO] => [PRIORITY] => 3 [WARRANTYPRODUCT] => WARR36MTH_HW_DISK [NA_DISRUPTION_EVENT] => [SERIALNUMBER] => 123456789 [NADUPCASEID] => [DMGERAPPRL] => [SYSNAME] => REWSRAPP34 [DATECLOSED] => 08-17-2006 04:47:37 PM [CASE_STATUSTEXT] => Closed [NASUPPORTOFFERING] => ST [CREATEDBY] => ) )


I need to access only CASEI D, CASE_STATUSTEXT and DATECLOSED from the above array

How can I access that ?

Thanks and Regards,
Usha

I have a situation were I need to just get a simple location.

I don't want any while loops or any of that jazz. 

I just want 1 string location every time. 

<?php

$ider = $_GET['id'];

        $conn = mysqli_connect("localhost", "Me", "pass", "MyDB"); 
        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
            }
            
        $sql = "SELECT Location FROM LifeSaver1 WHERE id =$ider";
        $result = $conn->query($sql);
        $obj = mysqli_fetch_object($result);
        $obj2 = $obj->Location;
        var_dump($obj);
?>

This is what it outputs 

Quote

string(11) "Boston"

I just need Boston. Can anyone give me a hint? 

Folks,

I want to parse a particular element from an array and nothing else.

Here is the Class (RecursiveTwitterSearch.php):

<?
/**
 * Wrapper class around the Twitter Search API for PHP
 * Based on the class originally developed by David Billingham
 * and accessible at http://twitter.slawcup.com/twitter.class.phps
 * @author Ryan Faerman <ryan.faerman@gmail.com>
 * @version 0.2
 * @package PHPTwitterSearch
 */
class TwitterSearch {
/**
 * Can be set to JSON (requires PHP 5.2 or the json pecl module) or XML - json|xml
 * @var string
 */
var $type = 'json';

/**
 * It is unclear if Twitter header preferences are standardized, but I would suggest using them.
 * More discussion at http://tinyurl.com/3xtx66
 * @var array
 */
var $headers=array('X-Twitter-Client: PHPTwitterSearch','X-Twitter-Client-Version: 0.1','X-Twitter-Client-URL: http://ryanfaerman.com/twittersearch');

/**
 * Recommend setting a user-agent so Twitter knows how to contact you inc case of abuse. Include your email
 * @var string
 */
var $user_agent='';

/**
 * @var string
 */
var $query='';

/**
 * @var array
 */
var $responseInfo=array();

/**
 * Use an ISO language code. en, de...
 * @var string
 */
var $lang;

/**
 * The number of tweets to return per page, max 100
 * @var int
 */
var $rpp;

/**
 * The page number to return, up to a max of roughly 1500 results
 * @var int
 */
var $page;

/**
 * Return tweets with a status id greater than the since value
 * @var int
 */
var $since;

/**
 * Returns tweets by users located within a given radius of the given latitude/longitude, where the user's location is taken from their Twitter profile. The parameter value is specified by "latitide,longitude,radius", where radius units must be specified as either "mi" (miles) or "km" (kilometers)
 * @var string
 */
var $geocode;

/**
 * When "true", adds "<user>:" to the beginning of the tweet. This is useful for readers that do not display Atom's author field. The default is "false"
 * @var boolean
 */
var $show_user = false;

/**
* @param string $query optional
*/
function TwitterSearch($query=false) {
$this->query = $query;
}

/**
* Find tweets from a user
* @param string $user required
* @return object
*/
function from($user) {
$this->query .= ' from:'.str_replace('@', '', $user);
return $this;
}

/**
* Find tweets to a user
* @param string $user required
* @return object
*/
function to($user) {
$this->query .= ' to:'.str_replace('@', '', $user);
return $this;
}

/**
* Find tweets referencing a user
* @param string $user required
* @return object
*/
function about($user) {
$this->query .= ' @'.str_replace('@', '', $user);
return $this;
}

/**
* Find tweets containing a hashtag
* @param string $user required
* @return object
*/
function with($hashtag) {
$this->query .= ' #'.str_replace('#', '', $hashtag);
return $this;
}

/**
* Find tweets containing a word
* @param string $user required
* @return object
*/
function contains($word) {
$this->query .= ' '.$word;
return $this;
}

/**
* Set show_user to true
* @return object
*/
function show_user() {
$this->show_user = true;
return $this;
}

/**
* @param int $since_id required
* @return object
*/
function since($since_id) {
$this->since = $since_id;
return $this;
}

/**
* @param int $language required
* @return object
*/
function lang($language) {
$this->lang = $language;
return $this;
}

/**
* @param int $n required
* @return object
*/
function rpp($n) {
$this->rpp = $n;
return $this;
}

/**
* @param int $n required
* @return object
*/
function page($n) {
$this->page = $n;
return $this;
}

/**
* @param float $lat required. lattitude
* @param float $long required. longitude
* @param int $radius required. 
* @param string optional. mi|km
* @return object
*/
function geocode($lat, $long, $radius, $units='mi') {
$this->geocode = $lat.','.$long.','.$radius.$units;
return $this;
}

/**
* Build and perform the query, return the results.
* @param $reset_query boolean optional.
* @return object
*/
function results($reset_query=true) {
$request  = 'http://search.twitter.com/search.'.$this->type;
$request .= '?q='.urlencode($this->query);

if(isset($this->rpp)) {
$request .= '&rpp='.$this->rpp;
}

if(isset($this->page)) {
$request .= '&page='.$this->page;
}

if(isset($this->lang)) {
$request .= '&lang='.$this->lang;
}

if(isset($this->since)) {
$request .= '&since_id='.$this->since;
}

if($this->show_user) {
$request .= '&show_user=true';
}

if(isset($this->geocode)) {
$request .= '&geocode='.$this->geocode;
}

if($reset_query) {
$this->query = '';
}

return $this->objectify($this->process($request))->results;
}

/**
* Returns the top ten queries that are currently trending on Twitter.
* @return object
*/
function trends() {
$request  = 'http://search.twitter.com/trends.json';

return $this->objectify($this->process($request));
}

/**
 * Internal function where all the juicy curl fun takes place
 * this should not be called by anything external unless you are
 * doing something else completely then knock youself out.
 * @access private
 * @param string $url Required. API URL to request
 * @param string $postargs Optional. Urlencoded query string to append to the $url
 */
function process($url, $postargs=false) {
$ch = curl_init($url);
if($postargs !== false) {
curl_setopt ($ch, CURLOPT_POST, true);
curl_setopt ($ch, CURLOPT_POSTFIELDS, $postargs);
        }
        
        curl_setopt($ch, CURLOPT_VERBOSE, 1);
        curl_setopt($ch, CURLOPT_NOBODY, 0);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_USERAGENT, $this->user_agent);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION,1);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $this->headers);

        $response = curl_exec($ch);
        
        $this->responseInfo=curl_getinfo($ch);
        curl_close($ch);
        
        if( intval( $this->responseInfo['http_code'] ) == 200 )
return $response;    
        else
            return false;
}

/**
 * Function to prepare data for return to client
 * @access private
 * @param string $data
 */
function objectify($data) {
if( $this->type ==  'json' )
return (object) json_decode($data);

else if( $this->type == 'xml' ) {
if( function_exists('simplexml_load_string') ) {
$obj = simplexml_load_string( $data );

$statuses = array();
foreach( $obj->status as $status ) {
$statuses[] = $status;
}
return (object) $statuses;
}
else {
return $out;
}
}
else
return false;
}
}






class RecursiveTwitterSearch extends TwitterSearch {
    var $request_count = 0;
    var $max_request_count = 5;
    var $max_id;
 
    function recursive_results() {
        $request  = 'http://search.twitter.com/search.'.$this->type;
        $request .= '?q='.urlencode($this->query);
 
        if(isset($this->rpp)) {
            $request .= '&rpp='.$this->rpp;
        }
 
        if(isset($this->page)) {
            $request .= '&page='.$this->page;
        }
 
        if(isset($this->lang)) {
            $request .= '?='.$this->lang;
        }
 
        if(isset($this->since)) {
            $request .= '&since_id='.$this->since;
        }
 
        if($this->show_user) {
            $request .= '&show_user=true';
        }
 
        if(isset($this->geocode)) {
            $request .= '&geocode='.$this->geocode;
        }
 
        if(isset($this->max_id)) {
            $request .= '&max_id='.$this->max_id;
        }
 
        $response = $this->objectify($this->process($request));
        $this->request_count++;
        if ($response) {
            $results = $response->results;
            if(!empty($response->next_page)) {
                preg_match('|\?page=([0-9]*)&max_id=([0-9]*)&|', $response->next_page, $matches);
                $this->page = $matches[1];
                $this->max_id = $matches[2];
                if ($this->request_count < $this->max_request_count) {
                    $results = array_merge($results, $this->recursive_results());
                }
            }
            return $results;
        }
        else return false;
    }
    function max_request_count($n) {
        $this->max_request_count = $n;
        return $this;
    }
}











?>



Here is how i am calling it:

<?php
require ("RecursiveTwitterSearch.php");
    $rts = new RecursiveTwitterSearch('paintball mask');
    echo '<pre>';
    print_r($rts->recursive_results());
    echo '</pre>';
    echo 'It took ' . $rts->request_count . ' request(s) to get this result.';
?>


If you observer the Output, u will see lot of array, i want to extract only "[text]" portion. 

So the desired output should be like:
Quote

vPaintball Mask http://bit.ly/czBA6S
The Paintball Republic does a short video about mask safety. LEARN. http://fb.me/KkMvjDWF
airsoft vs paintball mask http://goo.gl/fb/tyoxk
@mmorgansmithh like wearing a paintball mask on your head to starbucks
Tippmann US Army Ranger Paintball Goggle Mask - Camo: Tippmann US Army Ranger Paintball Goggle Mask - Camo ... http://bit.ly/9hFi3p

and so on.........





Infact, i prfer to use "foreach" to each each element so i can do further operation on it.

Can anyone help to achieve this?

Natty

I have an existing PHP array ($products) with various fields in it.... id / title / description / link / image link etc. etc. as per requirements for a Google Products feed (https://support.google.com/merchants/answer/7052112).

My issue is that, for clothing, Google want a separate record for each size available. My array includes the "size" field as a comma separated list e.g. 6,8,10,12,14 or XS,S,M,L,XL etc. etc.

So before creating the feed (a text file, which is currently outputting fine except for the size field issue) I need to duplicate each id where there's more than 1 size in that field, for each size, and then manipulate the fields a little so that (ignoring all the duplicated fields that would remain unchanged) instead of the single record : -

id            size                                                                        item group id
52           6,8,10,12,14,16,18,20,22,24,26

I'd have 11 records, item group id would be what the id is, the size appended to the id, and the size field only one (in sequence of those from the original), so: -

id            size        item group id

52-6       6              52
52-8       8              52
.
..
...
52-24     24           52
52-26     26           52

That's just one product....there are quite a lot, each with multiple sizes, but all in the same format within the $products array.

As always, any help / pointers / solutions much appreciated!