Some easy help with foreach()

brianb

I'm pulling some data from an XML feed.

There are 10 items, all setup in the same format...

I want each field to go into my MySQL database, in the proper fields.

Right now I'm doing this:

foreach ($titles[1] as $title)

{
INSERT INTO DB
}

The next piece of code is esntially what I'm trying to do...it's obviously wrong cause it's not working.

foreach ($titles[1] as $title, $totals[1] as $total, $descriptions[1] as $description)

{
INSERT eACH ELEMENT into it's field and INTO THE DB
}

Any help help is appreciated, especially some coding examples!

Thanks.

matt_4013

I'm pretty sure the foreach wont loop through multiple arrays like that. I think you'll have to specify them explicitly.

foreach($titles as $key=>$value) {
	// Put $value into database
}

foreach($totals as $key=>$value) {
	// Again, put $value into the database
}

Could suck if you had heaps to put in. In that case, I'd put all of your arrays into another array as they were being created earlier, and loop through that as well.

foreach($values as $key1=>$value1) {
	foreach($value1 as $key2=>$value2) {
		// Put $value2 into the database
	}
}

Hope that helps!

brianb

Hey Matt,

Thanks for the reply...

Maybe you can help here. I'm confused on how to put all of my arrays into one array, then input the data one by on into my DB.

Here's what each item looks like in my feed:

<item>
<title>Some Title</title>
<rank>1</rank>
<daily>33</daily>
<daily2>44</daily2>
<average>164</average>
<total>8702</total>
<link>http://www.somelink.com</link>
</item>

Now, in the feed there are 10 "items" that look like this. I have an array for each field being generated using preg_match_all()...

I need to get each "item" into my database entry by entry, with each entry's fileds correspoding with each field in the XML.

I really appreciate the help in any way!

Thanks!