无法从出勤记录中检索日期

Question

我有考勤记录数据库

id = emp_id \ attendance_date.

我插入了attendance_date by varchar(200).I，如果选择datetime picker.My日期格式是m/d/Y，则希望在startdate和enddate之间检索日期。如果我检索04/1/2015 and 04/30/2015，如果我检索12/1/2014 and 12/31/2014，它不是displayed.But，记录是displayed.The问题，month.It在month.How前面有不必要的零，我能这样做吗？拜托帮帮我?数据库就是这样的。id emp_id attendance_date 1 1 10/4/2014 10:36 2 1 10/30 2014 9:36

attendanceRecord.php

    <form enctype="multipart/form-data" method="post" class="form-inline" role="form" action="attendance_search.php">    

    <!--Start Date-->  
         <div class="">
            <div class="form-group required">
                   <label for="startdate" class="control-label">Start Date:</label>                                
                  <input class="form-control"  placeholder="Choose Date " type="text" id="datepicker-8" name="startdate" required="required" />                    
               </div>
        </div><br/><br/>

        <!--End Date-->  
         <div class="">
            <div class="form-group required">
                   <label for="enddate" class="control-label">End Date:</label>                               
                  <input class="form-control"  placeholder="Choose Date " type="text" id="datepicker-9" name="enddate" required="required" />

               </div>              
        </div>
         <!--Create Button-->     
    <div class=""> <br/>         
        <input class="btn btn-success" type="submit" value="Search" />          
    </div>
   </form>  

**attendance_search.php**





<form method="post" name="salaryform" action="" class="form-vertical">         

               <div class="table table-hover">       
                <table border="1" cellspacing="0" class="table" >                 
                   <tr class="success" >                     
                      <th>Employee ID</th>                    
                      <th>Date</th>                   
                      <th>Timein Timeout</th>                                                             
                  </tr> 
                  <?php
                     include 'connect.php';
                     error_reporting(E_ALL ^ E_NOTICE);             
                                                                           if(!empty($_POST)){                  
                     $startdate= mysql_real_escape_string(date( "m/d/Y H:i:s",strtotime($_POST["startdate"])));
                     $enddate= mysql_real_escape_string(date("m/d/Y H:i:s",strtotime($_POST["enddate"])));                   


                    $sql="SELECT * FROM attendance2 WHERE attendance_date   between '".$startdate."' and '".$enddate."'";                   

                    $retval = mysql_query($sql);
                    if (!$retval) {
                        die('Could not get data: ' . mysql_error());
                    }
                    while ($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
                        echo '<tr class="active">';
                        echo '<td >'.$row['emp_id'].'</td>';                                                      
                        echo '<td>'.$row['attendance_date'].'</td>';                
                        echo '<td>'.$row['timein_timeout'].'</td>';   

                    }


                    echo '</tr>';
                    echo '</table>';                                
                    }

                   ?>           
               </table>   

             </div>              
         </form>    

Answer 1

如果你不需要开始日期和结束日期的时间，那么你可以这样做，

$startdate = mysql_real_escape_string(date( "m/d/Y",strtotime($_POST["startdate"])));
$enddate = mysql_real_escape_string(date("m/d/Y",strtotime($_POST["enddate"])));                   


$sql="SELECT * FROM attendance2 WHERE date(attendance_date)   between '".$startdate."' and '".$enddate."'";