CODEWITHSUNDEEP
javascriptphpjquerymysqldatepicker
Tominko
Tominko

Reputation: 35

JQuery Datepicker erases already filled date field

could anyone please help? I am using jquery datepicker for several fields and in an update form in php and it updates dates in database. All seems to work great except the fact that if some of the date fields are already populated in DB, the datepicker does not display them and upon update it erases the value in DB too. the php sample:

<script>
    $( function() {
        $( "#datepicker" ).datepicker();
        $( "#datepicker" ).datepicker("option", "dateFormat", "yy-mm-dd");
    } );
</script>

...

<td><input type="text" id="datepicker" name="IM_request" value="'.$row["IM_request"].'"/></td>

So the variable $row["IM_request"] does not display if datepicker is enabled. if i disable it, it works fine, but a lot of manual work. Any idea how to make the datepicker-enabled input field to display the value from DB?

Upvotes: 0

Views: 158

Answers (2)

ctbs1
ctbs1

Reputation: 146

<input type="text" id="txtSelectedDate" value="20-01-01" />

$('#txtSelectedDate').datepicker({
    showButtonPanel: true,
    dateFormat: 'dd-mm-yy',
});

JSFiddle example : http://jsfiddle.net/LgTZt/211/

Upvotes: 1

Tominko
Tominko

Reputation: 35

I finally found the solution. Instead of:

$( function() {
    $( "#datepicker" ).datepicker();
    $( "#datepicker" ).datepicker("option", "dateFormat", "yy-mm-dd");
} );

I should have used:

$( function() {
    $( "#datepicker" ).datepicker({dateFormat: "yy-mm-dd"});
} );

Upvotes: 0

Related Questions