PHP Multiple foreach

Question

I am trying to insert data from an array in mysql. I have multiple arrays. I have been trying to do something along the lines of this.

foreach ($titles as $title && $descriptions as $description) {
    mysql_query("INSERT INTO `stock` VALUES('', '$title', '$description')");
}

I would like mysql table to look like this.

item_id    title    description
_______________________________

1          title1   description1
2          title2   description2
...

Now I have figured out this won't work is there any alternative to this. I have seen examples of while loops to do this but i am struggling to understand how that would work. All help is appreciated in advance.

Gabriel Santos · Accepted Answer · 2012-07-31 01:33:05Z

3

if size of $titles equal size of $descriptions and, you have sequencial arrays, you can do:

<?php
$titles = array(
    'foo',
    'bar'
);
$descriptions = array(
    'foo description',
    'bar description'
);

for($i = 0; $i < count($titles); $i++) {
    $title = $titles[$i];
    $description = $descriptions[$i];

    mysql_query("INSERT INTO `stock` VALUES('', '$title', '$description')");
}

answered Jul 31, 2012 at 1:33

Gabriel Santos

4,9742 gold badges45 silver badges74 bronze badges

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

Comments

nickb · Accepted Answer · 2012-07-31 01:34:41Z

3

You're looking for a MultipleIterator, which will iterate over both arrays easily:

$iter = new MultipleIterator;
$iter->attachIterator( new ArrayIterator( $titles));
$iter->attachIterator( new ArrayIterator( $descriptions));

foreach( $iter as $data) {
    list( $title, $description) = $data;
    // Do your SQL insert with $title and $description
}

answered Jul 31, 2012 at 1:34

nickb

59.7k13 gold badges115 silver badges149 bronze badges

Collectives™ on Stack Overflow

PHP Multiple foreach

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related