CODEWITHSUNDEEP
phpjquerymysqlsymfonydatepicker
Deynis
Deynis

Reputation: 327

Symfony2 and DateTimePicker bad date format?

I am trying to select a datetime with a symfony form. This is my form :

/**
 * @param FormBuilderInterface $builder
 * @param array $options
 */
public function buildForm(FormBuilderInterface $builder, array $options)
{
    $builder
        ->add('formation_date','datetime',array('label' => "Séance le :",
        'widget' => 'single_text',
        'format' => 'dd/MM/yyyy hh:mm',
        'attr' => array('class' => 'date', 'readonly' => 'readonly')
        ))               
    ;
}

And I am using a jquery datetimepicker. This is my script on the page to adjust the data :

<script type="text/javascript">
$(document).ready(function() {
$.datepicker.setDefaults(
    $.extend(
        {'dateFormat':'dd/mm/yy'},
        $.datepicker.regional['fr']
    )
);
$.timepicker.setDefaults(
    $.extend(
        {'timeFormat':'hh:mm:00'}
    )
);
  jQuery('.date').datetimepicker({
    changeYear: true,
    showButtonPanel: true,
    monthNames: ['Janvier','Février','Mars','Avril','Mai','Juin','Juillet','Août','Septembre','Octobre','Novembre','Décembre'],
    dayNames: ['Dimanche','Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi'],
    dayNamesShort: ['Dim.','Lun.','Mar.','Mer.','Jeu.','Ven.','Sam.'],
    dayNamesMin: ['D','L','M','M','J','V','S'],
    currentText: 'Aujourd\'hui',
    closeText: 'Fermer',
    prevText: 'Précédent',
    nextText: 'Suivant',
    minDate: "y", 
    maxDate: "+10y"
    });
});
</script>

But the time is not correct in the database. Although I post string '21/06/2014 12:00:00' (length=19 it is 00:00:00 in database and in my entity after handleRequest.

    > object(DateTime)[809]
public 'date' => string '2014-06-21 00:00:00' (length=19)
public 'timezone_type' => int 1
public 'timezone' => string '+00:00' (length=6)

And I have DateTime::__construct(): Failed to parse time string (21/06/2014 12:00:00) at position 0 (2): Unexpected character if I try to do this :

$date = new DateTime($request->request->get('intranet_rhbundle_dateformation')["formation_date"]);

so, I have no idea to solve it...

Upvotes: 1

Views: 2116

Answers (1)

Brewal
Brewal

Reputation: 8189

For the Failed to parse time string problem, try this : 

$date = new DateTime::createFromFormat(
    'd/m/Y H:i:s',
    $request->request->get('intranet_rhbundle_dateformation')["formation_date"]
);

DateTime::createFromFormat()

Upvotes: 2

Related Questions