Foreach is returning only one record

Question

Foreach is returning only one record

Navigation

#1 by (4 votes)
#2 by (3 votes)

3

I have a problem with my code. I have the following code:

<?php
require('class/habeo.class.php');
$Habeo->DuplicateRegister('contatos', array('id'=>'1', 'id'=>'6'));
?>

This class duplicates the records I have in the database. It counts how many elements it has in the array and loopes to duplicate the id . The class that duplicates is as follows:

<?php
function($de, $condicao){   
    foreach($condicao as $campo=>$value){
        $SQL = mysql_query('INSERT INTO {$de} ({$Columns}) 
                                  SELECT {$Columns} FROM {$de} 
                                  WHERE {$campo}='{$value}');
    }
}
?>

The problem is that it only loops with 1, and there are 2 records in the array.

I have seen that the error is because the array indices are the same name id and so are returning only 1, now when I change the name it returns 2.

php loop

asked by anonymous 06.07.2014 / 05:11

2 answers

3

One option is to use an array:

array( array("id"=>1), array("id"=>2) )

And the loop would look like this:

foreach ($lista as $item) {
    $item["id"];
}

06.07.2014 / 17:15

What does popBackStack () do? Is it bad practice to use foreach within View?

score 4 · Accepted Answer

As Bacco said , you can not have more than one key with the same name in an array. But you can call your function multiple times:

$Habeo->DuplicateRegister('contatos', array('id'=>'1'));
$Habeo->DuplicateRegister('contatos', array('id'=>'6'));

If the IDs are in another array, loop out:

$ids = array(1, 6);
foreach($ids as $id) {
    $Habeo->DuplicateRegister('contatos', array('id'=>$id));
}