get value of query from jQuery date picker (format issue)

Question

i have a table with events and want to list all events based on the date range the user will pick. I use jQuery datepicker, take value from it and put to sql query to show the events be†ween selected date range. My date format is YYYY-mm-dd (f.e 2016-05-05),but when I select the date from date picker it comes as (YYYY-05-05). For some reason it does not convert yyyy to date, but does for month and day. here is my code:

 <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
 <script src="//code.jquery.com/jquery-1.10.2.js"></script>
 <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
 <link rel="stylesheet" href="/resources/demos/style.css">

 <script>
 $(function() {
 var firstdate = $('#firstdatepicker').datepicker({ dateFormat: 'YYYY- mm-dd' }).val();
 });
 </script>


 <script>
 $(function() {
 var lastdate = $('#lastdatepicker').datepicker({ dateFormat: 'YYYY-mm- dd' }).val();
 });
 </script>
</head>
<body>
<form method="post" action="archive.php">
  <p>First Date: <input name = "firstdatepicker" type="text"  id="firstdatepicker"></p>

 <p>Last Date: <input name = "lastdatepicker" type="text"  id="lastdatepicker"></p>

 <input type="submit" value="Get Data" name="data"/>

 </form>

And my query in php

 if(!isset($_POST['filters']) && isset($_POST['firstdatepicker']) && isset($_POST['lastdatepicker']) ){

 $firstdate = $_POST['firstdatepicker'];
 $lastdate = $_POST['lastdatepicker'];

$query= "SELECT *
        FROM Event
        WHERE Event.`start_date` BETWEEN '$firstdate' and '$lastdate'
        ORDER BY start_date DESC";

}

Please see the DOC regarding valid date format

A. Wolff
– A. Wolff

2016-12-11 15:55:08 +00:00
Commented Dec 11, 2016 at 15:55 — A. Wolff
– A. Wolff, Commented Dec 11, 2016 at 15:55

Jameson the dog · Accepted Answer · 2016-12-11 15:52:53Z

2

YYYY is not a valid date format, you should use yy (two lower case y)

also, just a suggestion - you should escape user input (post) with some kind of function like mysqli_real_escape_string or whatever fits your SQL connection

answered Dec 11, 2016 at 15:52

Jameson the dog

1,8061 gold badge12 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

deChristo · Accepted Answer · 2016-12-11 15:54:02Z

1

Change to:

var lastdate = $('#lastdatepicker').datepicker({ dateFormat: 'yy-mm-dd' }).val();

and

var firstdate = $('#firstdatepicker').datepicker({ dateFormat: 'yy-mm-dd' }).val();

Have a look at: http://api.jqueryui.com/datepicker/#option-dateFormat

answered Dec 11, 2016 at 15:54

deChristo

1,8882 gold badges21 silver badges30 bronze badges

1 Comment

user Over a year ago

Thanks a lot! It helped

Vagharsh · Accepted Answer · 2016-12-11 15:55:22Z

0

Use yy as 4 digit year placeholder: dateFormat: "yy-mm-dd"

answered Dec 11, 2016 at 15:55

Vagharsh

4062 silver badges6 bronze badges

Collectives™ on Stack Overflow

get value of query from jQuery date picker (format issue)

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related