如何使用 datepicker、ajax、php、mysql 在两个日期之间生成报告? [英] how generate report between the two dates using 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 在两个日期之间生成报告?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！