DateTime从FullCalendar转换为Controller PHP

Question

I'm using FullCalendar to display a calendar on the web page (no surprise there).
A user can add events on the calendar, which is then passed through POST to the CodeIgniter controller. The controller executes a function in the model to insert the data in the database.

The problem I'm facing is that the date time, when inserted in the database adds 4 minutes for a reason i do not understand.

This is the JavaScript used for FullCalendar:

$(document).ready(function() {
    var today = moment().day();
    $('#calendar').fullCalendar({
        header: {
            left: 'prev,next today',
            center: 'title',
            right: 'month,agendaWeek,agendaDay'
        },
        editable: true,
        defaultView: 'agendaWeek',
        eventLimit: true, // allow "more" link when too many events
        selectable: true,
        selectHelper: true,
        select: function(start, end) {
            var title = "<?=$anim['NOMANIM']?>";
            var id = "<?=$anim['CODEANIM']?>";
            if (title) {
                start   =   moment(start).format('YYYY-MM-DD HH:mm:ss');
                end     =   moment(end).format('YYYY-MM-DD HH:mm:ss');
                $.ajax({
                    url: '<?php echo base_url("index.php/activite/add_activite"); ?>',
                    data: 'title='+ title+'&id='+ id+'&start='+ start +'&end='+ end,
                    type: "POST",
                    success: function(json) {
                        alert(start); // THIS SHOWS THE CORRECT DATETIME
                    }
                })
            };
            $('#calendar').fullCalendar('renderEvent',
            {
                title: title,
                start: start,
                end: end,
            }, true); // stick? = true
            $('#calendar').fullCalendar('unselect');
        },
        events: <?=$events?>
    });
});

And here is the controller function:

public function add_activite() {
    $title = $_POST['title'];
    $id = $_POST['id'];

    $datetime_start = strtotime($_POST['start']);
    $datetime_end   = strtotime($_POST['end']);

    $date   = date('Y-m-d', $datetime_start);
    $start  = date('H:m:s', $datetime_start);
    $end    = date('H:m:s', $datetime_end);
    $this->EZ_query->insert_activite($date, $start, $end);
}

If you think there is something I'm doing not correctly beside the time problem, I'm open to any pointers :), Thanks!

Answer 1

Your data formatting in php is not correct, minutes are denoted by i not m (which is used my month already). See here: http://php.net/manual/en/function.date.php

So change:

$start  = date('H:i:s', $datetime_start);
$end    = date('H:i:s', $datetime_end);