iteration through an array

yanisdon19 · May 15, 2007

Hi,

I am new to this, so I hope you can give me a hand.

My data source is a generic XML file. With the help of PHP's SimpleXML I am actually able to parse the XML file into an object/array.

So far so good.

Now I like to loop through that array and write the data appropriately into a mySQL-DB width correlative field names, whereas $rss->items contains the data.

With the following foreach I only get something like this:

             foreach ($rss->items as $a => $b) {

                   echo $a,'="',$b,"\"\n";

   }

0="Array"

1="Array"

2="Array"

I have the following array:

Psycho · May 15, 2007

No, problem. But, first you have to specify the structure of your database tables and which fields in the array map to which fields in the database.

EDIT: Also, one piece of inportant information would be whether or not you would be inserting the same records multiple times. I would assume so since these are RSS feeds. So, you would have to decide which piece of data is the unique identifier for each record - the URL?

yanisdon19 · May 15, 2007

Hi,

Thanks for the prompt response.

Well, the unique identifier would be [items] [$i] [dsm] [metadata_dc.identifier.uri] => http://test/testspace/handle/10096/678

It is basically always a string [with a file handle].

You are right, I've got to map the data to the appropriate fieldname in the DB, but for the moment let's assume they are named after the $key => part of the array (e.g. [metadata_dc.creator] would map to [metadata_dc.creator] in mySQL).

So essentially I'd like to find an apporach for the loop.

Cheers

yanisdon · May 15, 2007

EDIT:

Something I like to add:

if I do this I'll actually get that:

foreach ($rss->items as $a => $b) {
                print_r ($b);
        }

//print_r ($b['dsm']); would therefore contain:

 

                /* 
            [source] => testdocs
            [relevance] => 1.0
            [metadata_score] => 1.0
            [metadata_collection] => Test Institute Documents
            [metadata_collectionid] => 3
            [metadata_collectionurl] => http://test/testspace/handle/10096/4
            [metadata_content] => 1244095381
            [metadata_dc.date.accessioned] => 2007-05-07T04:54:22Z
            [metadata_dc.date.available] => 2007-05-07T04:54:22Z
            [metadata_dc.date.copyright] => 2007-01-01T00:00:00Z
            [metadata_dc.date.created] => 2006-01-01T00:00:00Z
            [metadata_dc.date.issued] => 2007-05-07T04:54:22Z
            [metadata_dc.date.lastmodified] => 2007-05-07T14:24:22Z
            [metadata_dc.description.provenance] => Submitted by Peter Tester (test@test.com) on 2007-05-07T04:54:22ZNo. of bitstreams: 0
            [metadata_dc.identifier.uri] => (URL address blocked: See forum rules)
            [metadata_dc.language] => en
            [metadata_dc.title] => test date indexing
            [metadata_filename] => (URL address blocked: See forum rules)
            [metadata_id] => 1244095381
            [metadata_mimetype] => text/html
            [metadata_size] => 0
            [metadata_url] => (URL address blocked: See forum rules)
               */

Now I've got to write my INSERT stuff within that loop, right?

Cheers

Psycho · May 15, 2007

Try this:

<?php
$valuesList = array();

foreach ($rss->items as $rss_array) {

    $thisRecord = array();

    //Put these in the order that you want them inserted into the database
    $thisRecord[] = $rss_array[dsm][metadata_dc.identifier.uri];
    $thisRecord[] = $rss_array[title];
    $thisRecord[] = $rss_array[link];
    $thisRecord[] = $rss_array[dsm][source];
    $thisRecord[] = $rss_array[dsm][[relevance];
    $thisRecord[] = $rss_array[dsm][metadata_score];
    $thisRecord[] = $rss_array[dsm][metadata_collection];
    $thisRecord[] = $rss_array[dsm][metadata_collectionid];
    $thisRecord[] = $rss_array[dsm][metadata_collectionurl];
    $thisRecord[] = $rss_array[dsm][metadata_content];
    $thisRecord[] = $rss_array[dsm][metadata_dc.date.accessioned];
    $thisRecord[] = $rss_array[dsm][metadata_dc.date.available];
    $thisRecord[] = $rss_array[dsm][metadata_dc.date.copyright];
    $thisRecord[] = $rss_array[dsm][metadata_dc.date.created];
    $thisRecord[] = $rss_array[dsm][metadata_dc.date.issued];
    $thisRecord[] = $rss_array[dsm][metadata_dc.date.lastmodified];
    $thisRecord[] = $rss_array[dsm][metadata_dc.description.provenance];
    $thisRecord[] = $rss_array[dsm][metadata_dc.language];
    $thisRecord[] = $rss_array[dsm][metadata_dc.title];
    $thisRecord[] = $rss_array[dsm][metadata_filename];
    $thisRecord[] = $rss_array[dsm][metadata_id];
    $thisRecord[] = $rss_array[dsm][metadata_mimetype];
    $thisRecord[] = $rss_array[dsm][metadata_size];
    $thisRecord[] = $rss_array[dsm][metadata_url];

    $valuesList[] = "('" . implode("','", $thisRecord[]) . "')";
    unset($thisRecord[]);

}

$query = 'INSERT INTO table (identifier, title, link, source, relevance, score, collection,
                             collectionid, collectionurl, content, accessioned, available,
                             copyright, created, issued, lastmodified, provenance, language,
                             meta_title, filename, meta_id, mimetype, size, url)
          VALUES ' . implode(",", $valuesList);

echo $query;

?>

yanisdon · May 16, 2007

Thank you. I'll try it and let you know about the outcome.

cheers

Jan

Sign In

iteration through an array

Recommended Posts

yanisdon19

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

yanisdon19

Link to comment

Share on other sites

yanisdon

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

yanisdon

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information