Count json objects in array

Question

Struggling to get the count of all objects in my array to spit out number in json. Can anyone help?

try {
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   

    $stmt = $conn->prepare('SELECT * FROM date_blocks WHERE user_id = :user_id');
    $stmt->execute(array('user_id' => $user_id));

    while($row = $stmt->fetch()) {
        $startTime = strtotime($row['start_date']);
        $endTime = strtotime($row['end_date']);


        for ($i = $startTime; $i <= $endTime; $i = $i + 86400) {
            $getDate = date('Y-m-d H:i:s', $i); 
            $return[]=array('date'=>$getDate,
                    'id'=>$row['id']);
        }


    }
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}
header('Content-type: application/json');
echo json_encode($return);

unicorn80 · Accepted Answer · 2014-02-06 12:33:35Z

1

Getting the number of elements in JSON format you could do this at the end of your script:

header('Content-type: application/json');
echo json_encode(count($return));

answered Feb 6, 2014 at 12:33

unicorn80

1,2172 gold badges10 silver badges15 bronze badges

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

1 Comment

user3189734 Over a year ago

That simple, duh. Thank you for your help!

Collectives™ on Stack Overflow

Count json objects in 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