PHP, array manipulation to get keys with all same name

Question

I have this array posting to my controller:

Array
(
    [id] => Array
        (
            [0] => 95
            [1] => 69
        )
)

I want:

Array(

    [id] => 95
    [id] => 69
)

As I am using CodeIgniter's $this->db->delete() function and it takes the array key value as the column for the WHERE clause. I have this code at the moment:

foreach($ids as $k => $v){

    $formatIds['id'] = $v;

}

Which just gives me one of the rows and not the rest.

I then tried:

foreach($ids as $k => $v){

    $formatIds['id'][] = $v;

}

But this gives me a MultiDimensional array...

Why do you want a broken array? It makes no sense for two different values to have the same key. I think you should change your approach. — Tom Fenech
– Tom Fenech, Commented Mar 18, 2015 at 16:38
This is not possible, because it is logically senseless. It contradicts the basic idea of an associative array. — arkascha
– arkascha, Commented Mar 18, 2015 at 16:39
Array( [0] => 95 [1] => 69 ) is possible; but you can't have multiple array elements with the same key — Mark Baker
– Mark Baker, Commented Mar 18, 2015 at 16:40
ok so if I try using the first array i posted above in the CodeIgniter function to delete rows it tries something like this in the query DELETE FROM table WHERE 0 = 95, DELETE FROM table WHERE 1 = 69.... So how can I achieve what I want — Richard
– Richard, Commented Mar 18, 2015 at 16:44

Mark Baker · Accepted Answer · 2015-03-18 16:48:26Z

4

The answer to your question is "not possible": array keys must always be unique.

The answer to what you're trying to do is to use where_in():

$names = array(95,69);
$this->db->where_in('id', $names);
$this->db->delete('mytable');

answered Mar 18, 2015 at 16:48

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Collectives™ on Stack Overflow

PHP, array manipulation to get keys with all same name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related