MySQL to PHP Array

Question

Can you please help me extracting MySQL data in php array.

my sql:

SELECT count(*) as total, post_type as type FROM wp_posts group by post_type;

to php, like below:

<?php $total = array(5,7, .. , ..); $type = array('Page', 'Post', '..',..'); ?>

Array should come from database

Thanks :)

Did you tried something?

rap-2-h
– rap-2-h

2016-05-26 12:11:52 +00:00
Commented May 26, 2016 at 12:11 — rap-2-h
– rap-2-h, Commented May 26, 2016 at 12:11

Community · Accepted Answer · 2017-05-23 10:28:36Z

1

You can't get two separate arrays from single SQL query either you have to run the mysql query two times or Write a PHP code which gives you the desired result.

Your current query will give result as follow.

Array
(
    [0] => Array
    (
        [total] => 5
        [post_type] => Page
    )
)

Now you have to traverse these array to create two separate arrays you want.

$total=array_column($result,'total');
$type = array_column($result,'post_type');

Above code will give you two separate arrays.

Thanks to Niet the Dark Absol for array_column, it looks more clean then traversing manually.

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered May 26, 2016 at 12:16

Alok Patel

8,0726 gold badges35 silver badges48 bronze badges

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

1 Comment

Niet the Dark Absol Over a year ago

Alternative: $total = array_column($result,'total'); $type = array_column($result,'post_type'); - documentation

Collectives™ on Stack Overflow

MySQL to PHP Array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related