Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2015
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.09 KB | None | 0 0
  1. function get_unavailabities($sql) {
  2. include 'connect.php';
  3. $id = $_GET['id'];
  4. $select = $conn->prepare($sql);
  5. $select->bind_param('s', $id);
  6. $select->execute();
  7. $select->store_result();
  8. if ($select->num_rows > 0) {
  9. echo "<table>n
  10. <tr>n
  11. <th>Date</th>n
  12. <th>Delete</th>n
  13. </tr>n";
  14. $meta = $select->result_metadata();
  15. while ($field = $meta->fetch_field()) {
  16. $params[] = &$row[$field->name];
  17. }
  18. call_user_func_array(array($select, 'bind_result'), $params);
  19. while ($select->fetch()) {
  20. $date_from = new DateTime($row['dates']);
  21. $from_date = $date_from->format('d/m/Y');
  22.  
  23. echo "<tr>n
  24. <td>".$from_date."</td>n
  25. <td><a href='includes/delete.php?dates=".$row['dates']."&apartment=".$row['apartmentID']."'>Delete</a></td>
  26. <tr>n";
  27. }
  28. echo "</table>n";
  29. $select->close();
  30. }
  31.  
  32. }
  33.  
  34. <table>
  35. <tr>
  36. <th>Date</th>
  37. <th>Delete</th>
  38. </tr>
  39. <tr>
  40. <td>03/09/2015</td>
  41. <td><a href='includes/delete.php?dates=2015-09-03&apartment=1'>Delete</a></td>
  42. <tr>
  43. <tr>
  44. <td>04/09/2015</td>
  45. <td><a href='includes/delete.php?dates=2015-09-04&apartment=1'>Delete</a></td>
  46. <tr>
  47. <tr>
  48. <td>05/09/2015</td>
  49. <td><a href='includes/delete.php?dates=2015-09-05&apartment=1'>Delete</a></td>
  50. <tr>
  51. <tr>
  52. <td>09/09/2015</td>
  53. <td><a href='includes/delete.php?dates=2015-09-09&apartment=1'>Delete</a></td>
  54. <tr>
  55. </table>
  56.  
  57. if (isset($_GET['dates']) && isset($_GET['apartment'])) {
  58. $dates = $_GET['dates'];
  59. $apartment = $_GET['apartment'];
  60.  
  61. include 'connect.php';
  62. $sql = "DELETE * FROM room_nights WHERE dates = '?' AND apartmentID = ?";
  63. $delete = $conn->prepare($sql);
  64. $delete->bind_param('ii', $dates, $apartment);
  65. $delete->execute();
  66.  
  67. if ($delete->affected_rows > 0) {
  68. header('Location:../CMS-Apartments.php');
  69. }
  70. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement