PHP - how can i make from array to comma separate for mysql

Question

PHP i am getting this:

array(2) { 
  [0]=> array(1) 
   { 
     ["username"]=> string(7) "9994344" 
   } 
  [1]=> array(1)
   {
     ["username"]=> string(7) "9994345" 
   } 
 }

How to make that into comma separate list

ex. SELECT *from table1 WHERE column IN ("9994344","9994345")

foreach loop but its slow.

user285594
– user285594

2014-02-03 05:33:54 +00:00
Commented Feb 3, 2014 at 5:33 — user285594
– user285594, Commented Feb 3, 2014 at 5:33

Barmar · Accepted Answer · 2014-02-03 05:36:29Z

3

$in_list = implode(',', array_map(function($x) {
    return '"' . $x['username'] . '"';
}, $array));

$sql = "SELECT * FROM table1 WHERE column IN ($in_list)";

answered Feb 3, 2014 at 5:36

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

Panama Jack Over a year ago

I like the use of array_map();

Satish Sharma · Accepted Answer · 2014-02-03 05:37:03Z

1

$ids=array(); 
while($row = mysql_fetch_assoc($result))
{
  $ids[]=$row["UserID"]; 
} 
echo implode(", ", $ids);

edited Feb 3, 2014 at 5:37

Satish Sharma

9,6356 gold badges31 silver badges52 bronze badges

answered Feb 3, 2014 at 5:35

dev4092

2,9111 gold badge18 silver badges15 bronze badges

1 Comment

Barmar Over a year ago

You're missing the quotes around the IDs.

Satish Sharma · Accepted Answer · 2014-02-03 05:52:16Z

1

try this

$arr_username = array();
foreach($arr as $arr_value)
{
    $arr_username[] = '"'.$arr_value['username'].'"';
}

$in = implode(",", $arr_username);

$sql = "SELECT * FROM table1 WHERE column IN ($in)";

edited Feb 3, 2014 at 5:52

answered Feb 3, 2014 at 5:40

Satish Sharma

9,6356 gold badges31 silver badges52 bronze badges

3 Comments

Barmar Over a year ago

You're missing the quotes around the usernames.

Satish Sharma Over a year ago

@Barmar i am updating the answer. whereas it can be work because username is a number. what you thing ?

Barmar Over a year ago

Now it's essentially the same as my answer, except I use array_map instead of a loop.

Collectives™ on Stack Overflow

PHP - how can i make from array to comma separate for mysql

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related