I want to use the datepicker to query the data between two days.

I want to use the datepicker to query the data between two days.

I want to use the datepicker to query the data from MySQL database.

I add the 00:00:00 and 23:59:59 because my data type is timestamp ,but the code can't work.

Please help me !

This is my code.

test_jquery2.php
  2. <!doctype html>
  3. <html lang="en">
  4. <head>
  5.   <meta charset="utf-8">
  6.   <title>Computer Facilities Temperature & Humidity Log</title>
  7.     <style type="text/css">
  8.         .table_titles, .table_cells_odd, .table_cells_even {
  9.                 padding-right: 20px;
  10.                 padding-left: 20px;
  11.                 color: #000;
  12.         }
  13.         .table_titles {
  14.             color: #FFF;
  15.             background-color: #666;
  16.         }
  17.         .table_cells_odd {
  18.             background-color: #CCC;
  19.         }
  20.         .table_cells_even {
  21.             background-color: #FAFAFA;
  22.         }
  23.         table {
  24.             border: 2px solid #333;
  25.         }
  26.         body { font-family: "Trebuchet MS", Arial; }
  27.     </style>
  28.   <link rel="stylesheet" href="jquery-ui.css">
  29.   <script src="jquery-1.11.2.js"></script>
  30.   <script src="jquery-ui.js"></script>
  31.   <link rel="stylesheet" href="/resources/demos/style.css">
  32.   <script>
  33.   $(function() {
  34.     $( "#sdatepicker" ).datepicker({
  35. dateFormat: "yy-mm-dd",
  36. constrainInput: false
  37. });
  38.  $( "#edatepicker" ).datepicker({
  39. dateFormat: "yy-mm-dd",
  40. constrainInput: false
  41. });
  42.   });
  43.   
  44.   $(document).ready(function(){
  45.   $("#generate_log").click(function(){
  46.  var sdatepicker=jQuery("#sdatepicker").val() +" 00:00:00";
  47.  var edatepicker=jQuery("#edatepicker").val() +" 23:59:59";

  49.  
  50.  var data =
  51.  {
  52.   sdatepicker:sdatepicker ,
  53. edatepicker:edatepicker
  55. }
  56. jQuery.ajax({
  57. type: "POST",
  58. url: "test.php",
  59. data: data,
  60. success: function(response){
  61.  }
  62. });
  63.   });
  64. });
  65.   
  66.   
  67.   
  68.   </script>
  69. </head>
  70. <body>

  72. <h1>Computer Facilities Temperature & Humidity Log</h1>

  74. Start Date: <input type="text" id="sdatepicker">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  75. End Date: <input type="text" id="edatepicker">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  76. <input type="button" name="generate_log" id="generate_log" value="Generate Log" />
  77.  

  79.  
  80. </body>
  81. </html>

test.php
  2. <?php 
  3.     // Start MySQL Connection
  4.     include('dbconnect.php'); 
  5. ?>

  7. <html>
  8. <head>
  9.     
  10.     <style type="text/css">
  11.         .table_titles, .table_cells_odd, .table_cells_even {
  12.                 padding-right: 20px;
  13.                 padding-left: 20px;
  14.                 color: #000;
  15.         }
  16.         .table_titles {
  17.             color: #FFF;
  18.             background-color: #666;
  19.         }
  20.         .table_cells_odd {
  21.             background-color: #CCC;
  22.         }
  23.         .table_cells_even {
  24.             background-color: #FAFAFA;
  25.         }
  26.         table {
  27.             border: 2px solid #333;
  28.         }
  29.         body { font-family: "Trebuchet MS", Arial; }
  30.     </style>
  31. </head>
  32.     <table border="0" cellspacing="0" cellpadding="4">
  33.       <tr>
  34.             <td class="table_titles">ID</td>
  35.             <td class="table_titles">Date and Time</td>
  36.             <td class="table_titles">Temperature</td>
  37.             <td class="table_titles">Humidity</td>
  38.           </tr>
  39. <?php
  40.     // Retrieve all records and display them
  41. error_reporting(0);
  42.     $result = mysql_query("SELECT * FROM thdata WHERE event BETWEEN '".$sdatepicker."' AND '".$edatepicker."' ORDER BY id ASC");

  44.     // Used for row color toggle
  45.     $oddrow = true;

  47.     // process every record
  48.     while( $row = mysql_fetch_array($result) )
  49.     {
  50.         if ($oddrow) 
  51.         { 
  52.             $css_class=' class="table_cells_odd"'; 
  53.         }
  54.         else
  55.         { 
  56.             $css_class=' class="table_cells_even"'; 
  57.         }

  59.         $oddrow = !$oddrow;

  61.         echo '<tr>';
  62.         echo '   <td'.$css_class.'>'.$row["id"].'</td>';
  63.         echo '   <td'.$css_class.'>'.$row["event"].'</td>';
  64.         echo '   <td'.$css_class.'>'.$row["celsius"].'</td>';
  65.         echo '   <td'.$css_class.'>'.$row["humidity"].'</td>';
  66.         echo '</tr>';
  67.     }
  68. ?>
  69.     </table>
  70.     </body>
  71. </html>