php get the values from the array as like format

Question

I have an array like this

Array
(
    [0] => T-shirts
    [1] => Evening Dresses
    [2] => Dresses
    [3] => Clothes
)

Here I want to get the values of the array and add "" for each values and add , after each value So the valus should finally come like this

IN("T-shirts","Evening Dresses","Dresses","Clothes")

so for this I made my code like this

$category_pool = '';
foreach($categoryArray as $categoryArr)
    $category_pool .= $categoryArr.',';
    $category_pool = ((strpos($category_pool, ',') === false) ? (' = '.$category_pool.' ') : (' IN ("'.rtrim($category_pool, ',').'") '));

But here it is getting the value like

 IN ("T-shirts,Evening Dresses,Dresses,Clothes")

So can someone tell me how to make this value to come like

 IN("T-shirts","Evening Dresses","Dresses","Clothes")

Any help and suggestions will be really appreciable. Thanks

Alex · Accepted Answer · 2015-02-06 03:37:34Z

1

Quick solution is:

change your fragment:

$category_pool = '';
foreach($categoryArray as $categoryArr)
    $category_pool .= $categoryArr.',';
    $category_pool = ((strpos($category_pool, ',') === false) ? (' = '.$category_pool.' ') : (' IN ("'.rtrim($category_pool, ',').'") '));

with one my line:

$category_pool = 'IN ( "' . implode('","',$categoryArray).'")';

edited Feb 6, 2015 at 3:37

answered Feb 6, 2015 at 3:14

Alex

17.3k1 gold badge31 silver badges52 bronze badges

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

4 Comments

NewUser Over a year ago

so I don't have to use $category_pool .= $categoryArr.',';

Alex Over a year ago

I have no idea what is $category_pool stands for :-)

NewUser Over a year ago

I used your code but its showing its showing implode(): Invalid arguments passed The code is like this $category_pool = ((strpos($category_pool, ',') === false) ? (' = '.$category_pool.' ') : ('IN ( "' . implode('","',$category_pool).'")'));

Alex Over a year ago

I've updated an answer. but still not understand how MY implode could get error message, by the way your foreach published is not completed... but I hope you can understand what you should do

danronmoon · Accepted Answer · 2015-02-06 03:09:31Z

1

'IN(' 
. implode(
     ',', 
     array_map(function ($val) {
         return sprintf('"%s"', $val);
     }, $categoryArray)
  ) 
. ')';

answered Feb 6, 2015 at 3:09

danronmoon

3,8735 gold badges36 silver badges58 bronze badges

Collectives™ on Stack Overflow

php get the values from the array as like format

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related