explode an array and add array keys

Question

I have a string that looks like this,

IT, MEDIA, ADVERTISING

I am then doing the following code.

$criteria = explode(",", $string);

This obviously creates the following when print_r is run over the $criteria.

array([0] => IT, [1] => MEDIA, [2] => 'ADVERTISING')

I using $criteria to match for keywords in a database in codeigniter application, I am wanting to using something like,

$this->db->like($criteria);

for this to work though I need the $criteria array to look like this,

array([sector] => IT, [sector] => MEDIA, [sector] => 'ADVERTISING')

How can I do this?

Check the code/documentation, you are likely in need of array like array('sector' => array('IT', 'MEDIA', 'ADVERTISING')) — mkilmanas
– mkilmanas, Commented Jun 7, 2011 at 15:18

Crashspeeder · Accepted Answer · 2011-06-07 15:14:28Z

3

PHP can't have multiple values with the same key.

answered Jun 7, 2011 at 15:14

Crashspeeder

4,3112 gold badges18 silver badges21 bronze badges

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

6 Comments

mkilmanas Over a year ago

gee.. And I was like 5sec from submitting a "solution" :)

KingCrunch Over a year ago

+1 Nothing to include, except no language is able to do this. :) @Jordan: It does answer the question; its simply not possible to create such an array. Its like asking "How to fly to the moon with my car?". The only answer is "No way!" :D

Mark Baker Over a year ago

@Jordan - it answers the question by saying that it isn't possible, which is a 100% correct answer

Udders Over a year ago

how can I do multiple likes using codeigniter active recorder based on the exploded string, which can be variable in length.....so stuck!

Jordan Running Over a year ago

It does not solve the user's problem, which is how to perform this query in CodeIgniter using the given $string or $criteria. This "answer" is no better than "RTFM" at helping the poster more toward a solution to his actual problem.

|

DarthJDG · Accepted Answer · 2011-06-07 16:38:51Z

1

You cannot build an array like this. The keys of the array are identical, so the values will overwrite each other.

Also I think that the method you are looking for is where_in():

$names = array('Frank', 'Todd', 'James');

$this->db->where_in('username', $names);

// Produces: WHERE username IN ('Frank', 'Todd', 'James')

edited Jun 7, 2011 at 16:38

DarthJDG

16.6k11 gold badges52 silver badges56 bronze badges

answered Jun 7, 2011 at 15:21

Dragos

1394 bronze badges

Comments

Kien Nguyen · Accepted Answer · 2011-06-07 15:32:06Z

0

If you're trying to make OR WHERE clauses with an array like this:

$criteria = array(
    0 => 'IT',
    1 => 'MEDIA',
    2 => 'ADVERTISING',
)

You can loop through it and use like() and or_like() methods:

foreach ($criteria as $index => $value) {
    if ($index == 0)
        $this->db->like('sector', $value);
    else
        $this->db->or_like('sector', $value);
}

// Produces WHERE sector LIKE '%IT%' OR sector LIKE '%MEDIA%' OR sector LIKE '%ADVERTISING%';

answered Jun 7, 2011 at 15:32

Kien Nguyen

4185 silver badges12 bronze badges

Comments

anubhava · Accepted Answer · 2011-06-07 15:21:35Z

0

How about creating your array criteria like this:

$criteria = array('sector'=>explode(",", $string));

OUTPUT

var_dump($criteria);

array(1) {
  ["sector"]=>
  array(3) {
    [0]=>
    string(2) "IT"
    [1]=>
    string(6) " MEDIA"
    [2]=>
    string(12) " ADVERTISING"
  }
}

answered Jun 7, 2011 at 15:21

anubhava

790k67 gold badges603 silver badges671 bronze badges

Collectives™ on Stack Overflow

explode an array and add array keys

4 Answers 4

6 Comments

Comments

Comments

OUTPUT

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

Comments

Comments

OUTPUT

Comments

Your Answer

Sign up or log in

Post as a guest

Related