• <legend id='jxJUy'><style id='jxJUy'><dir id='jxJUy'><q id='jxJUy'></q></dir></style></legend>

      <small id='jxJUy'></small><noframes id='jxJUy'>

        <bdo id='jxJUy'></bdo><ul id='jxJUy'></ul>
    1. <tfoot id='jxJUy'></tfoot>

        <i id='jxJUy'><tr id='jxJUy'><dt id='jxJUy'><q id='jxJUy'><span id='jxJUy'><b id='jxJUy'><form id='jxJUy'><ins id='jxJUy'></ins><ul id='jxJUy'></ul><sub id='jxJUy'></sub></form><legend id='jxJUy'></legend><bdo id='jxJUy'><pre id='jxJUy'><center id='jxJUy'></center></pre></bdo></b><th id='jxJUy'></th></span></q></dt></tr></i><div id='jxJUy'><tfoot id='jxJUy'></tfoot><dl id='jxJUy'><fieldset id='jxJUy'></fieldset></dl></div>

        如何使用 datepicker、ajax、php、mysql 在两个日期之间生成报告?

        how generate report between the two dates using datepicker,ajax,php,mysql.?(如何使用 datepicker、ajax、php、mysql 在两个日期之间生成报告?)

          <small id='LO9v4'></small><noframes id='LO9v4'>

          • <legend id='LO9v4'><style id='LO9v4'><dir id='LO9v4'><q id='LO9v4'></q></dir></style></legend>
            • <bdo id='LO9v4'></bdo><ul id='LO9v4'></ul>

                  <tbody id='LO9v4'></tbody>
                <tfoot id='LO9v4'></tfoot>

                <i id='LO9v4'><tr id='LO9v4'><dt id='LO9v4'><q id='LO9v4'><span id='LO9v4'><b id='LO9v4'><form id='LO9v4'><ins id='LO9v4'></ins><ul id='LO9v4'></ul><sub id='LO9v4'></sub></form><legend id='LO9v4'></legend><bdo id='LO9v4'><pre id='LO9v4'><center id='LO9v4'></center></pre></bdo></b><th id='LO9v4'></th></span></q></dt></tr></i><div id='LO9v4'><tfoot id='LO9v4'></tfoot><dl id='LO9v4'><fieldset id='LO9v4'></fieldset></dl></div>

                  本文介绍了如何使用 datepicker、ajax、php、mysql 在两个日期之间生成报告?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我的任务是使用 datepicker、ajax、php 和 mysql 在两个给定日期之间生成报告.下面是我的 html:

                  I have been given a task to generate a report between two given dates using datepicker,ajax,php and mysql. below is my html:

                          From date: <input type="text" id="fromdate" value="">   To date: <input type="text" id="todate" value="" onChange="showuser(document.getElementById('fromdate').value,document.getElementById('todate').value)">  
                          <br>
                          <div id="txtHint"><b>User informathions will be listed here.</b></div>
                  

                  脚本:

                  <script>
                    $(function() {
                      $( "#fromdate" ).datepicker();
                      $( "#todate" ).datepicker();
                    });
                    </script>
                  
                  <script type="text/javascript">
                  function showUser(fromdate,todate)
                  {
                    if (fromdate =="" && todate=="")
                      {
                       document.getElementById("txtHint").innerHTML="";
                       return;
                      } 
                  
                      if (window.XMLHttpRequest)
                       {// code for IE7+, Firefox, Chrome, Opera, Safari
                        xmlhttp=new XMLHttpRequest();
                       }
                    else
                      {// code for IE6, IE5
                       xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
                      }
                  
                    xmlhttp.onreadystatechange=function()
                      {
                       if (xmlhttp.readyState==4 && xmlhttp.status==200)
                        {
                          document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
                        }
                      }
                      xmlhttp.open("GET","bet_date.php?fromdate="+fromdate+"&todate="+todate,true);
                      xmlhttp.send();
                  }
                  </script>
                  

                  这是应该生成报告的 php 文件:bet_date.php

                  Here is the php file which is supposed to generate the report: bet_date.php

                  include("database.php"); 
                  $fromdate=$_GET["fromdate"];
                  $todate=$_GET["todate"];
                   $sql = "SELECT * FROM bookings WHERE date between '$fromdate' and '$todate'";
                   $result = mysql_query($sql);
                  
                   echo "<table border='1'>
                  <tr>
                  <th>id</th>
                  <th>date</th>
                  <th>start</th>
                  <th>name</th>
                  <th>email</th>
                  <th>phone</th>
                  <th>comments</th>
                  <th>approved</th>
                  </tr>";
                  
                  while($row = mysql_fetch_array($result))
                    {
                    echo "<tr>";
                    echo "<td>" . $row['id'] . "</td>";
                    echo "<td>" . $row['date'] . "</td>";
                    echo "<td>" . $row['start'] . "</td>";
                    echo "<td>" . $row['name'] . "</td>";
                    echo "<td>" . $row['email'] . "</td>";
                     echo "<td>" . $row['phone'] . "</td>";
                      echo "<td>" . $row['comments'] . "</td>";
                       echo "<td>" . $row['approved'] . "</td>";
                    echo "</tr>";
                    }
                  echo "</table>";
                  

                  问题是当我选择两个日期时,什么也没有发生.请在这种情况下帮助我.简单的例子将不胜感激.谢谢.

                  The problem is when I select both the date then nothing happens. kindly help me in this situation. simple examples would be greatly appreciated. Thanks.

                  推荐答案

                  把你的 html 改成这样:你有 showUser() 而不是 showuser() 所以改变 inputonchage="showUser()".

                  change your html to this:you have showUser() not showuser() so change in input onchage="showUser()".

                  onchange 事件写入两个 input.so 将触发的两个字段.如果您仅从前端发送日期,并且数据库中的日期列的类型为 datetime..

                  write onchange event to both the inputs.so on both fields they will trigger. and in your sql use date(date) if you are sending only date from front-end and date column in database is of type datetime..

                  "SELECT * FROM bookings WHERE date(date) between '$fromdate' and '$todate'";
                  
                  
                    From date: <input type="text" id="fromdate" value="" onChange="showUser()">   To date: <input type="text" id="todate" value="" onChange="showUser()"> 
                  
                  function showUser()
                  {
                  
                  var fromdate = $( "#fromdate" ).val();
                  var todate= $( "#todate" ).val();
                  
                  // rest of your code:
                  
                  
                  
                  
                  }
                  

                  希望您在 php 中正确获取 post/get 参数.

                  hope you are getting post/get parameters properly in php.

                  这篇关于如何使用 datepicker、ajax、php、mysql 在两个日期之间生成报告?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  Appending GET parameters to URL from lt;formgt; action(将 GET 参数附加到来自 lt;formgt; 的 URL行动)
                  Forcing quot;Save Asquot; dialog via jQuery GET(强制“另存为通过 jQuery GET 对话框)
                  PHP - get certain word from string(PHP - 从字符串中获取某个单词)
                  How to debug a get request in php using curl(如何使用 curl 在 php 中调试 get 请求)
                  get a # from a url in php(从 php 中的 url 获取 #)
                  PHP - include() file not working when variables are put in url?(PHP - 将变量放入 url 时,include() 文件不起作用?)

                      <tfoot id='yBl0O'></tfoot>

                          • <bdo id='yBl0O'></bdo><ul id='yBl0O'></ul>
                          • <legend id='yBl0O'><style id='yBl0O'><dir id='yBl0O'><q id='yBl0O'></q></dir></style></legend>
                            <i id='yBl0O'><tr id='yBl0O'><dt id='yBl0O'><q id='yBl0O'><span id='yBl0O'><b id='yBl0O'><form id='yBl0O'><ins id='yBl0O'></ins><ul id='yBl0O'></ul><sub id='yBl0O'></sub></form><legend id='yBl0O'></legend><bdo id='yBl0O'><pre id='yBl0O'><center id='yBl0O'></center></pre></bdo></b><th id='yBl0O'></th></span></q></dt></tr></i><div id='yBl0O'><tfoot id='yBl0O'></tfoot><dl id='yBl0O'><fieldset id='yBl0O'></fieldset></dl></div>

                              <tbody id='yBl0O'></tbody>

                            <small id='yBl0O'></small><noframes id='yBl0O'>