Write PHP function to return JSON after WP_Query and re-order / total some data

In WordPress I have a custom post type. In each post of this custom post type is a custom field named "report" this custom field (post meta field) stores a JSON blob which is an array of objects (JSON)

An example of the JSON is below, this is stored in the post meta / custom field of the custom post type.

[{"entrances":"1","ga:date":"20080918","ga:landingPagePath":"/","ga:sourceMedium":"aol / organic","pageviews":"5","sessions":"1","totalValue":"0.0","transactionRevenue":"0.0","transactions":"0","transactionsPerSession":"0.0","uniquePurchases":"0"},{"entrances":"1","ga:date":"20080918","ga:landingPagePath":"/[url removed, login to view]","ga:sourceMedium":"aol / organic","pageviews":"7","sessions":"1","totalValue":"0.0","transactionRevenue":"0.0","transactions":"0","transactionsPerSession":"0.0","uniquePurchases":"0"}]

Note that one report for one day has multiple JSON objects with different pageview entries

Your job is to create a PHP function which uses WP_Query, to query all of the posts from the custom post type between two dates. So $query = new WP_Query('posts_per_page -1 etc...... To query dates you will use [url removed, login to view]

Now for each post which is returned. The PHP function will get all post meta reports. Then return total pageviews per day. And return JSON which is array of arrays, the first value is day, the second is total pageviews for that date


"total_pageviews": [

[20080918, 10],

[20080919, 52]



I have a few more similar projects to format JSON data I hope to have this completed very soon thank you

Taidot: PHP, WordPress

Näytä lisää: php api return json, write php query smarty, php function order

About the Employer:
( 5 reviews ) Mount Sinai, United States

Projektin tunnus: #14799323

Myönnetty käyttäjälle:


hello sir i am very good php developer i have dene lots of work in rest and soap api thanks Relevant Skills and Experience hello sir i am very good php developer i have dene lots of work in rest and soap api tha Lisää

20 $ USD 1 päivässä
(47 arvostelua)

8 freelanceria on tarjonnut keskimäärin 28 $ tähän työhön


I have experience in making these kind of websites and has many satisfied clients. Will provide example websites on request. [url removed, login to view] Relevant Skills and Experience HTML, CSS, WORDPRESS AND PHP Proposed M Lisää

25 $ USD 1 päivässä
(73 arvostelua)

Hi, sir I have a great skill in wordpress. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via chat. Thanks. Relevant Skills and Experience I have been developing f Lisää

25 $ USD 1 päivässä
(60 arvostelua)

Hey, can you give me sample data in database to make it ? Rocky .

35 $ USD 1 päivässä
(25 arvostelua)
50 $ USD 1 päivässä
(4 arvostelua)
15 $ USD 1 päivässä
(14 arvostelua)
25 $ USD 1 päivässä
(0 arvostelua)

I’ve carefully gone through your job posting. I ’m an expert HTML/CSS, wordpress, core php , laravel, codeigniter developer with more than 4 years experiences Relevant Skills and Experience I ’m an expert HTML/CSS, wo Lisää

25 $ USD 1 päivässä
(0 arvostelua)