jQuery Ajax JSON object values are NULL

Question

I'm doing something like this, but getting null values even though the JSON looks like it's coming though formatted correctly. To avoid the returned integer values being wrapped in double quotes I added absint. Any idea where I am going wrong? PHP v.5.5.23. Thanks.

class.php

public function stats($interval) {          
        global $wpdb;
        $title = $this->title;

        if (is_object($wpdb) && is_a($wpdb, 'wpdb')) {
            $totals = $wpdb->get_results("
            SELECT * FROM wp_video_stats WHERE vid_title = '$title' AND DATE(updated) = DATE_SUB(DATE(NOW()), INTERVAL '$interval' DAY)"); 
         }

         foreach ($totals as $row) {
            $days = absint($row->days);
            $weeks = absint($row->weeks);
            $months = absint($row->months);     
         }

         return array(
           'title'=>$title,
           'days'=>$days,
           'weeks'=>$weeks,
           'months'=>$months
         );  

}

$array = $results->stats(2);

if(!empty($_SERVER['HTTP_X_REQUESTED_WITH']) &&  
   strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
   header('Content-type: application/json');

   echo json_encode($array);

   exit();
}

page.php

<script>
$.ajax({
    url : '/class.php',
        type : 'POST',
        dataType : 'json',
        success : function (data) {         
           console.log(data);  
        },
        error : function () {
           console.log("error");
        }
})
</script>

JSON

{
    "title":"title_test",
    "days":217,
    "weeks":37,
    "months":3
}

console.log

Object {title: "title_test", days: null, weeks: null, months: null}

How many results are you expecting also? If more than one will overwrite variables in loop. Do a dump of $totals and see it in your console ... echo json_encode($totals); exit; — charlietfl
– charlietfl, Commented Feb 23, 2016 at 19:41

Community · Accepted Answer · 2017-05-23 11:50:32Z

1

I eventually figured this out. A reference to wp-load.php was required in my custom page. Thankfully I found this post Cant access wp-load.php dynamically showing a way to include the file which worked for me locally.

$root = dirname(dirname(dirname(dirname(__FILE__))));

if (file_exists($root.'/wp-load.php')) {
    require_once($root.'/wp-load.php');
} else {
    require_once($root.'/wp-config.php');
}

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Feb 24, 2016 at 2:30

Jamie

3714 silver badges17 bronze badges

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

2 Comments

Death-is-the-real-truth Over a year ago

Mark your answer also for others help.

Jamie Over a year ago

Will do Anant I have to wait until tomorrow. Cheers.

Collectives™ on Stack Overflow

jQuery Ajax JSON object values are NULL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related