Advertisement
Guest User

Untitled

a guest
Oct 21st, 2014
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. include('connect-db.php');
  2. $vlekach_number = $_POST['vnumber'];
  3. $start_date = $_POST['start_date'];
  4. $end_date = $_POST['end_date'];
  5.  
  6. $mysqli = new mysqli($server, $user, $pass ,$db);
  7. $result = $mysqli->query("SELECT * FROM table_name WHERE 16 LIKE '%$vnumber%' and 5 >= '$start_date' and 5 <='$end_date' ");
  8. $row = $result->fetch_assoc();
  9.  
  10. echo "<table id='table_id' class='display' border='1' style='text-align:center;'>
  11. <thead>
  12. <tr>
  13. <th>Date</th>
  14. <th>vnumber</th>
  15. <th>Produkt</th>
  16. <th>Money</th>
  17. </tr>
  18. </thead>
  19. ";
  20.  
  21. while($row = mysql_fetch_array($rs))
  22. {
  23. echo "<tr>";
  24. echo "<td>" . $row['5'] . "</td>";
  25. echo "<td>" . $row['16'] . "</td>";
  26. echo "<td>" . $row['53'] . "</td>";
  27. echo "<td>" . $row['44'] . "</td>";
  28. echo "</tr>";
  29. }
  30. echo "</table>";
  31.  
  32. // Close the database connection
  33. mysql_close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement