Convert associative array of strings to flat array of integer (values only)

Question

I cant figure out how to get Array 1 and make it look like Array 2 so that I can send it as parameters for my prepared statements method.

ARRAY 1: (what I currently have)

array(5) { [0]=> array(2) { ["id"]=> string(1) "1" [0]=> string(1) "1" } [1]=> array(2) { ["id"]=> string(3) "314" [0]=> string(3) "314" } [2]=> array(2) { ["id"]=> string(3) "315" [0]=> string(3) "315" } [3]=> array(2) { ["id"]=> string(3) "316" [0]=> string(3) "316" } [4]=> array(2) { ["id"]=> string(3) "317" [0]=> string(3) "317" } }

ARRAY 2: What I'm trying to get it to be. (please ignore that 1 item is missing)

array(4) { [0]=> int(314) [1]=> int(315) [2]=> int(316) [3]=> int(317) }

I'm trying to accomplish this in PHP php7.1 if that matters.

I THINK this is enough information but if its not please let me know. I just didnt want to bog you down with all sorts of code and explanation that I'm not sure you need.

What I've tried so far (although possibly not properly):

$category_ids2 = array_values($category_ids);

The trick is in traversing the first array correctly. Check this article. Then you just need to get the individual values and populate your simple array. — Paulo Hgo
– Paulo Hgo, Commented Feb 21, 2018 at 22:38

AbraCadaver · Accepted Answer · 2018-02-21 22:47:10Z

5

There's a function for extracting one column and another for converting to integer:

$category_ids = array_map('intval', array_column($category_ids, 'id'));

Without array_column:

$category_ids = array_map(function($v) { return (int)$v['id']; }, $category_ids);

However, this looks suspiciously like database results. If so, then just build the array the way you want when fetching the results. Also, using the fetch assoc of your database library would eliminate the 0 index in each array.

edited Feb 21, 2018 at 22:47

answered Feb 21, 2018 at 22:40

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

3 Comments

Brett Williams Over a year ago

Thank you so much for your help. you are 100% correct that it is database result, but being very new to php in general, and even newer to PDO, i'm having trouble trying to figure out how to do the query without post process of converting with PDO. I will try and do more research on that though since I now know it seems to be possible. thank you so much :).

Brett Williams Over a year ago

With your direction I was able to figrue out how to do it directly from the query. Thank you so much :D. Answer can be found here for those interested. stackoverflow.com/questions/6047724/…

Brett Williams Over a year ago

Sorry, was my first post wasn't aware of marking them. I THINK I have done so now. (If that is what the check mark is)

Krish · Accepted Answer · 2018-02-21 22:43:00Z

1

$array = [['id' => '1', '0' => '1'], 
      ['id' => '314', '0' => '314'],
      ['id' => '315', '0' => '315'],
      ['id' => '316', '0' => '316'],
      ['id' => '317', '0' => '317']];

echo "<pre>";

$ids = array_column($array, 'id');


unset($ids['0']); 
var_dump($ids);

$integerIDs = array_map('intval', $ids);

var_dump($integerIDs);

Explanation:

you should use array_column to get ids http://php.net/manual/en/function.array-column.php
then unset if position zero is not required
array_map('intval', $ids); each and every values will be converted into int

answered Feb 21, 2018 at 22:43

Krish

3872 silver badges13 bronze badges

Comments

jh1711 · Accepted Answer · 2018-02-21 22:49:03Z

0

First use array_column to flatten the array. Then combine array_map with intval to cast the strings to integers. All together:

$category_ids2 = array_map('intval', array_column($category_ids, 'id'));

edited Feb 21, 2018 at 22:49

answered Feb 21, 2018 at 22:41

jh1711

2,3381 gold badge14 silver badges20 bronze badges

Collectives™ on Stack Overflow

Convert associative array of strings to flat array of integer (values only)

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related