How to create a string that contains the keys of a given array in PHP?

Question

I have an array holding this data:

Array ( 
  [1402377] => 7 
  [1562441] => 7 
  [1639491] => 9 
  [1256074] => 10 
 )

How can create a string that contains the keys of the above array? Essentially, I need to create a comma separated string that consists of an array's keys

The string would look like: 'key','key','key'

Do I need to create a new array consisting of the keys from an existing array?

The reason I need to do this is because I will be querying a MySQL database using a WHERE in () statement. I would rather not have to query the database using a foreach statement. Am I approaching this problem correctly?

I've tried using a while statement, and I'm able to print the array keys that I need, but I need those keys to be an array in order to send to my model.

The code that allowed me to print the array keys looks like this:

while($element = current($array)) {
            $x = key($array)."\n";
            echo $x;
            next($array);
        }

Be careful about injection vulnerabilities. Familiarize yourself with the array functions. — outis
– outis, Commented Jan 13, 2012 at 7:28
possible duplicate of PHP Splitting an Array into two arrays - keys array and values array, MySQL Prepared statements with a variable size variable list. — outis
– outis, Commented Jan 13, 2012 at 8:01
...There is a way to get all keys of the array?, Print the keys of an array, Parameterizing an SQL IN clause?, PreparedStatement IN clause alternatives? — outis
– outis, Commented Jan 13, 2012 at 8:17

hoppa · Accepted Answer · 2012-01-13 07:24:43Z

3

$string = implode(',', array_keys($array));

By the way, for looping over an array consider not using current and next but use foreach:

foreach ($array as $key => $value) {
    //do something
}

This will automatically iterate over the array until all records have been visited (or not at all if there are no records.

answered Jan 13, 2012 at 7:24

hoppa

3,04120 silver badges22 bronze badges

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

Comments

Cyclonecode · Accepted Answer · 2012-01-13 07:24:36Z

2

$keys = array_keys($array);
$string = implode(' ',$keys);

In your case, were you are using the result in a IN clause you should do: $string = implode(',', $keys);

answered Jan 13, 2012 at 7:24

Cyclonecode

30.4k11 gold badges77 silver badges97 bronze badges

Comments

Sudhir Bastakoti · Accepted Answer · 2012-01-13 07:24:44Z

1


$yourString = '';
foreach($yourArr as $key => $val) {
 $yourString .=$key.",";
}
echo rtrim($yourString, ",");

//OR
$yourString = implode(",", array_keys($yourArray));

See : array_keys

answered Jan 13, 2012 at 7:24

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Comments

WoLfulus · Accepted Answer · 2012-01-13 07:27:19Z

1

implode(', ', array_keys($array));

answered Jan 13, 2012 at 7:27

WoLfulus

1,9771 gold badge14 silver badges22 bronze badges

Comments

Nazariy · Accepted Answer · 2012-01-13 07:25:34Z

0

Use php array_keys and implode methods

print implode(PHP_EOL, array_keys($element))

answered Jan 13, 2012 at 7:25

Nazariy

6,0785 gold badges40 silver badges61 bronze badges

Comments

OptimusCrime · Accepted Answer · 2012-01-13 07:31:55Z

0

The string would look like: 'key','key','key'

$string = '\'' . implode('\',\'', array_keys($array)) . '\'';

answered Jan 13, 2012 at 7:31

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

Comments

outis · Accepted Answer · 2012-01-13 08:15:00Z

0

Imploding the arguments and interpolating the result into the query can cause an injection vulnerability. Instead, create a prepared statement by repeating a string of parameter placeholders.

$paramList = '(' . str_repeat('?, ', count($array) - 1) . '?)'
$args = array_keys($array);
$statement = 'SELECT ... WHERE column IN ' . $paramList;
$query = $db->prepare($statement);
$query->execute($args);

answered Jan 13, 2012 at 8:15

outis

77.7k23 gold badges155 silver badges228 bronze badges

Collectives™ on Stack Overflow

How to create a string that contains the keys of a given array in PHP?

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related