Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>
- 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>";
- "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:
- }
- I have Created Whole Tutorial for Date Wise Report, so once try it
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement