Insert a date into the database via jquery+php

Question

I have a datepicker like this

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.css" />

    <form action="dashboard.php" name="form1" class="form1" method="POST">
        <input type="text" id="dtSelectorStatic" />

    </form>
</li>

And a script like that:

jQuery(function($) {
    $("#dtSelectorStatic").datepicker({dateFormat: "dd-mm-yy"});
    var d = new Date();
    var month = d.getMonth()+1;
    var day = d.getDate();
    var output = d.getFullYear() + '/' +
    (month<10 ? '0' : '') + month + '/' +
    (day<10 ? '0' : '') + day;

    $("#dtSelectorStatic").datepicker("setDate", new Date(output));

    console.log(output);

    $('#dtSelectorStatic').on('change', function() {
        console.log('Submiting form');
        console.log(output);
        $('#form1').submit();

    }).trigger('change');
});

I have a function to insert all data into the database and I need to pass this datepicker value to the insert function

Note: The whole code is on the same page . php

Answer 1

I still don’t understand why not use one:

<input type="date" name="data" id="dtSelectorStatic">

<script>
$("#dtSelectorStatic").change(function(){
$("#form1").submit()
});
</script>

If what you want is to submit a form with the change of a date there is your answer, if not explain better.

Answer 2

Have you added the part that makes the request? What’s this I’m not seeing.

Executing your code. I noticed that the date comes in "Brazilian" format. Which is the format that represents, respectively: dd/mm/YYYY.

Will the field that will receive the date, in the database, is with that same pattern (dd/mm/YYYY), or it is in the pattern "YYYY-mm-dd"?

Depending on how this value will be stored in the database, you have to convert to such.

Check the description of the fields of the table which data format is accepted. Then just convert to it (if it is of type Date, in the YYYY-mm-dd pattern).

Hugs!