Putting into table from a complicated array using php

Question

I've got this array which is very confusing for me as a beginner. I just want to put the title, link and pubDate from 0=> SimpleXMLELement Object and 1 => SimpleXMLElement Object which has aa and bb in them into a my table pulled from mysql.

My table goes like:

 Title
 PubDate
 Link

and I want to put the 'aa' and 'bb' under each of the titles in the table.

This is what I have tried:

    foreach($con as $key => $val){
    while($key == title){
        $Title['title'] = $val;
    }
    return $Title['title'];
}

What I was trying to do was label the keys and values with $key and $val, and when $key = title, I wanted to put all the titles into one array, but unfortunately it did not work.

aldrin27 · Accepted Answer · 2015-08-17 02:15:36Z

2

Try this:

 $array_to_get = ['title', 'link', 'pubDate'];
    $newArray = [];
    $con = $xmlStructure->channel->item; //Object from xml
    foreach($con as $key => $val){
        if(in_array($key, $array_to_get)){
            $newArray['title'] = $val->title;
            $newArray['link'] = $val->link;
            $newArray['pubDate'] = $val->pubDate;
        }
    }
    print_r($newArray);

edited Aug 17, 2015 at 2:15

answered Aug 17, 2015 at 1:39

aldrin27

3,4184 gold badges31 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Masayuki Tonoki Over a year ago

It says there is an unexpected '[' in the first line of your programme. What should I do?

aldrin27 Over a year ago

change the [] to array();

Masayuki Tonoki Over a year ago

Don't know why, but it gives an error for the third line of your code as invalid argument supplied for foreach()

aldrin27 Over a year ago

I've updated my answer. I think it's an object. I get the xmlStructure from @Brendan Rollison

Brendan Rollinson · Accepted Answer · 2015-08-17 02:14:03Z

1

Assuming that $xmlStructure is the structure posted above, your code should look something like:

$items = $xmlStructure->channel->item;
$table = [];
foreach ($items as $item) {
    $table[] = [
        'title' => $item->title,
        'pubDate' => $item->pubDate,
        'link' => $item->link;
    ];
}

At the end of this, your $table array will contain an array of entities, each containing the three fields.

Then, constructing an HTML table (or table of another type) should be fairly straightforward.

edited Aug 17, 2015 at 2:14

answered Aug 17, 2015 at 1:41

Brendan Rollinson

2041 silver badge6 bronze badges

6 Comments

Masayuki Tonoki Over a year ago

It says there is an unexpected '[' in line 27 which is $table = [];

Brendan Rollinson Over a year ago

In older versions of PHP, you may need to use: $table = array();

Masayuki Tonoki Over a year ago

Sorry again, but it says invalid argument supplied for foreach in the 3rd line.

Brendan Rollinson Over a year ago

Updated the first line to fix that.

Masayuki Tonoki Over a year ago

` [0] => Array ( [title] => [pubDate] => [link] => )` It's so close, but somehow the values are empty in the array

|

Exploit · Accepted Answer · 2015-08-17 02:25:26Z

Actually that array is not complicated at all once you start to understand what is going on and how its structured it will continue to become a piece of cake over time. Instead of me showing you what to do i'm going to explain in detail how to read an array like that and how to go about it and that way you will know what to do in the future.

Example, lets say you want to access the version value in this portion of the array:

SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [version] => 2.0
        )
)

First you would have this stored in a variable and each level under the array is setup like this and say this array is stored in $container

//with @attributes you access it as a function, anything with @ is access as a function, example below.
$version = $container->attributes()->['version']

now say you want to access the title, link, pubdate etc.

you would do

$title = $container->channel->title;
$link = $container->channel->link;
$description = $container->channel->description
//notice how after channel i used it as an object instead of an array , its because after channel it mentions that its an SimpleXMLElement Object.

Now say you want to access each of the elements under item where it has values starting from 0.

$collection = $container->channel->item;

now this holds all the elements of item. To prove it simply do print_r($collection) and you will see a collection of data returned to you and to get an output of its collection you can just do a simple foreach loop to get all the values, as shown:

foreach($collection as $items)
{
    echo 'Title: ' . $items->title . '<br/>';
    echo 'Link: ' . $items->link . '<br/>';
    echo 'Pubdate' . $items->pubDate . '<br/>';
    //and so on
}

Once you understand this , then you can create your table or whatever else you have to do but you must first understand how to read arrays like this.

Collectives™ on Stack Overflow

Putting into table from a complicated array using php

3 Answers 3

4 Comments

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related