json and multi-dimensional array

For @garcon1986: encode the whole result set, not each row. Collect rows into a PHP array, optionally normalize fields (for example convert the "allDay" string to a boolean), then call json_encode once. Also send the JSON content-type header and check for encoding errors if results look wrong.

Example using mysqli (push each row, convert allDay to boolean, then encode once):

$rows = array();

while ($row = mysqli_fetch_assoc($result)) {
    if (isset($row['allDay'])) {
        $row['allDay'] = filter_var($row['allDay'], FILTER_VALIDATE_BOOLEAN);
    }
    $rows[] = $row;
}

header('Content-Type: application/json; charset=utf-8');
echo json_encode($rows);

Notes and troubleshooting:

• If using PDO, fetchAll(PDO::FETCH_ASSOC) returns the same array in one call.
• filter_var(..., FILTER_VALIDATE_BOOLEAN) converts "true"/"false"/"1"/"0" to real booleans before encoding.
• If json_encode returns false or output looks odd, diagnose with json_last_error_msg(); see the PHP docs: json_encode and json_last_error_msg.
• Avoid deprecated mysql_* functions; prefer mysqli or PDO for security and future compatibility (see mysqli_result::fetch_assoc and PDOStatement::fetchAll).