SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Apr 2013
    Posts
    104
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Loop over an array.

    Hi,

    I have array of web analytics data.

    I want to get data from array and insert into database.

    I am not able to traverse array and it look difficult for me.

    Please help in to get [aggregates] and [resultsRows] data.

    I will store [aggregates] , [resultsRows] country and browser type data.


    Code:
    SimpleXMLElement Object
    (
        [timePeriod] => SimpleXMLElement Object
            (
                [period] => date_range
                [startDate] => 20100312
                [endDate] => 20140331
                [startTime] => 1268380800
                [endTime] => 1396335599
                [label] => 03/12/2010 - 03/31/2014
            )
    
        [aggregates] => SimpleXMLElement Object
            (
                [metric] => Array
                    (
                        [0] => SimpleXMLElement Object
                            (
                                [@attributes] => Array
                                    (
                                        [name] => visitDuration
                                        [value] => 10
                                        [label] => Avg. Visit Duration
                                    )
    
                            )
    
                        [1] => SimpleXMLElement Object
                            (
                                [@attributes] => Array
                                    (
                                        [name] => bounces
                                        [value] => 4
                                        [label] => Bounces
                                    )
    
                            )
    
                        [2] => SimpleXMLElement Object
                            (
                                [@attributes] => Array
                                    (
                                        [name] => repeatVisitors
                                        [value] => 3
                                        [label] => Repeat Visitors
                                    )
    
                            )
    
                        [3] => SimpleXMLElement Object
                            (
                                [@attributes] => Array
                                    (
                                        [name] => newVisitors
                                        [value] => 1
                                        [label] => New Visitors
                                    )
    
                            )
    
                        [4] => SimpleXMLElement Object
                            (
                                [@attributes] => Array
                                    (
                                        [name] => visits
                                        [value] => 5
                                        [label] => Visits
                                    )
    
                            )
    
                        [5] => SimpleXMLElement Object
                            (
                                [@attributes] => Array
                                    (
                                        [name] => pageViews
                                        [value] => 13
                                        [label] => Page Views
                                    )
    
                            )
    
                    )
    
            )
    
        [resultsTotal] => 4
        [resultsReturned] => 4
        [resultsPerPage] => 25
        [resultsRows] => SimpleXMLElement Object
            (
                [row] => Array
                    (
                        [0] => SimpleXMLElement Object
                            (
                                [dimension] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => date
                                                        [value] => 20140302
                                                        [label] => Date
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => browserType
                                                        [value] => Chrome
                                                        [label] => Browser Type
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => country
                                                        [value] => united states
                                                        [label] => Country
                                                    )
    
                                            )
    
                                    )
    
                                [metric] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visitDuration
                                                        [value] => 0
                                                        [label] => Avg. Visit Duration
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => bounces
                                                        [value] => 1
                                                        [label] => Bounces
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => repeatVisitors
                                                        [value] => 1
                                                        [label] => Repeat Visitors
                                                    )
    
                                            )
    
                                        [3] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => newVisitors
                                                        [value] => 0
                                                        [label] => New Visitors
                                                    )
    
                                            )
    
                                        [4] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visits
                                                        [value] => 1
                                                        [label] => Visits
                                                    )
    
                                            )
    
                                        [5] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => pageViews
                                                        [value] => 1
                                                        [label] => Page Views
                                                    )
    
                                            )
    
                                    )
    
                            )
    
                        [1] => SimpleXMLElement Object
                            (
                                [dimension] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => date
                                                        [value] => 20140302
                                                        [label] => Date
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => browserType
                                                        [value] => Firefox
                                                        [label] => Browser Type
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => country
                                                        [value] => united states
                                                        [label] => Country
                                                    )
    
                                            )
    
                                    )
    
                                [metric] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visitDuration
                                                        [value] => 0
                                                        [label] => Avg. Visit Duration
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => bounces
                                                        [value] => 1
                                                        [label] => Bounces
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => repeatVisitors
                                                        [value] => 1
                                                        [label] => Repeat Visitors
                                                    )
    
                                            )
    
                                        [3] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => newVisitors
                                                        [value] => 0
                                                        [label] => New Visitors
                                                    )
    
                                            )
    
                                        [4] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visits
                                                        [value] => 1
                                                        [label] => Visits
                                                    )
    
                                            )
    
                                        [5] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => pageViews
                                                        [value] => 1
                                                        [label] => Page Views
                                                    )
    
                                            )
    
                                    )
    
                            )
    
                        [2] => SimpleXMLElement Object
                            (
                                [dimension] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => date
                                                        [value] => 20140302
                                                        [label] => Date
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => browserType
                                                        [value] => Other
                                                        [label] => Browser Type
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => country
                                                        [value] => united states
                                                        [label] => Country
                                                    )
    
                                            )
    
                                    )
    
                                [metric] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visitDuration
                                                        [value] => 0
                                                        [label] => Avg. Visit Duration
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => bounces
                                                        [value] => 1
                                                        [label] => Bounces
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => repeatVisitors
                                                        [value] => 1
                                                        [label] => Repeat Visitors
                                                    )
    
                                            )
    
                                        [3] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => newVisitors
                                                        [value] => 0
                                                        [label] => New Visitors
                                                    )
    
                                            )
    
                                        [4] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visits
                                                        [value] => 1
                                                        [label] => Visits
                                                    )
    
                                            )
    
                                        [5] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => pageViews
                                                        [value] => 1
                                                        [label] => Page Views
                                                    )
    
                                            )
    
                                    )
    
                            )
    
                        [3] => SimpleXMLElement Object
                            (
                                [dimension] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => date
                                                        [value] => 20140303
                                                        [label] => Date
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => browserType
                                                        [value] => Chrome
                                                        [label] => Browser Type
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => country
                                                        [value] => united states
                                                        [label] => Country
                                                    )
    
                                            )
    
                                    )
    
                                [metric] => Array
                                    (
                                        [0] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visitDuration
                                                        [value] => 25
                                                        [label] => Avg. Visit Duration
                                                    )
    
                                            )
    
                                        [1] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => bounces
                                                        [value] => 1
                                                        [label] => Bounces
                                                    )
    
                                            )
    
                                        [2] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => repeatVisitors
                                                        [value] => 1
                                                        [label] => Repeat Visitors
                                                    )
    
                                            )
    
                                        [3] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => newVisitors
                                                        [value] => 1
                                                        [label] => New Visitors
                                                    )
    
                                            )
    
                                        [4] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => visits
                                                        [value] => 2
                                                        [label] => Visits
                                                    )
    
                                            )
    
                                        [5] => SimpleXMLElement Object
                                            (
                                                [@attributes] => Array
                                                    (
                                                        [name] => pageViews
                                                        [value] => 10
                                                        [label] => Page Views
                                                    )
    
                                            )
    
                                    )
    
                            )
    
                    )
    
            )
    
    )

    -Thanks

  2. #2
    SitePoint Zealot
    Join Date
    Apr 2013
    Posts
    104
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •