Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function get_unavailabities($sql) {
- include 'connect.php';
- $id = $_GET['id'];
- $select = $conn->prepare($sql);
- $select->bind_param('s', $id);
- $select->execute();
- $select->store_result();
- if ($select->num_rows > 0) {
- echo "<table>n
- <tr>n
- <th>Date</th>n
- <th>Delete</th>n
- </tr>n";
- $meta = $select->result_metadata();
- while ($field = $meta->fetch_field()) {
- $params[] = &$row[$field->name];
- }
- call_user_func_array(array($select, 'bind_result'), $params);
- while ($select->fetch()) {
- $date_from = new DateTime($row['dates']);
- $from_date = $date_from->format('d/m/Y');
- echo "<tr>n
- <td>".$from_date."</td>n
- <td><a href='includes/delete.php?dates=".$row['dates']."&apartment=".$row['apartmentID']."'>Delete</a></td>
- <tr>n";
- }
- echo "</table>n";
- $select->close();
- }
- }
- <table>
- <tr>
- <th>Date</th>
- <th>Delete</th>
- </tr>
- <tr>
- <td>03/09/2015</td>
- <td><a href='includes/delete.php?dates=2015-09-03&apartment=1'>Delete</a></td>
- <tr>
- <tr>
- <td>04/09/2015</td>
- <td><a href='includes/delete.php?dates=2015-09-04&apartment=1'>Delete</a></td>
- <tr>
- <tr>
- <td>05/09/2015</td>
- <td><a href='includes/delete.php?dates=2015-09-05&apartment=1'>Delete</a></td>
- <tr>
- <tr>
- <td>09/09/2015</td>
- <td><a href='includes/delete.php?dates=2015-09-09&apartment=1'>Delete</a></td>
- <tr>
- </table>
- if (isset($_GET['dates']) && isset($_GET['apartment'])) {
- $dates = $_GET['dates'];
- $apartment = $_GET['apartment'];
- include 'connect.php';
- $sql = "DELETE * FROM room_nights WHERE dates = '?' AND apartmentID = ?";
- $delete = $conn->prepare($sql);
- $delete->bind_param('ii', $dates, $apartment);
- $delete->execute();
- if ($delete->affected_rows > 0) {
- header('Location:../CMS-Apartments.php');
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement