Explode php array

Question

I have following array result :

Array ( [0] => company_1 [1] => company_10 [2] => company_15 )

I want the result something like this as i can use in the mysql IN query clause:

$result= "1, 10, 15";

I use explode function but again it is returning both array values separately like this:

Array ( [0] => Array ( [0] => company [1] => 1 ) [1] => Array ( [0] => company [1] => 10 ) [2] => Array ( [0] => company [1] => 15 ) )

But wondering how can i only get numbers separately and stored in one string.

Any help ? '

why do you explode an array to make a string? surely you want to implode? — andrew, Sep 01 '14 at 01:31
@andrew: yes. but first i have to use explode as i can separate the number from company. — RK., Sep 01 '14 at 01:33
http://stackoverflow.com/questions/907806/php-mysql-using-an-array-in-where-clause — The Alpha, Sep 01 '14 at 01:34

Kevin · Accepted Answer · 2014-09-01T01:45:17.223

3

If your initial data is an array, just explode them again each them gather them inside then finally use implode. Example:

$result = array('company_1', 'company_10', 'company_15');
$result = array_map(function($piece){
    return explode('_', $piece)[1]; // note: for php 5.4 or greater
    // return str_replace('company_', '', $piece);
}, $result);
$result = implode(', ', $result);
echo $result; // 1, 10, 15

edited Sep 01 '14 at 01:45

answered Sep 01 '14 at 01:34

Kevin

41,694
12
53
70

1

if `company_` is constant, dagons solution is probably for the best – Kevin Sep 01 '14 at 01:37

score 1 · Answer 2 · answered Sep 01 '14 at 01:33

1

You have to pick the second part after you explode.

$result = array_map(function ($val) {
  $tmp = explode('_', $val);
  return isset($tmp[1]) ? $tmp[1] : null;
}, $array);

$result = implode(',', $result); // "1,10,5"

answered Sep 01 '14 at 01:33

xdazz

158,678
38
247
274

I think you want `_`, not `-` – Phil Sep 01 '14 at 01:34
3

str_replace() is probably quicker if "company_" never changes – Sep 01 '14 at 01:34
@Dagon's right. A simple `implode` and `str_replace` would be faster and simpler – Phil Sep 01 '14 at 01:36
2

I want that first sentence framed for my office. – Sep 01 '14 at 01:37

Explode php array

2 Answers2