// output data of each row
   while($row = $result->fetch_assoc()) {
        echo "<tr>";
        echo "<td>" .$row['id'] . "</td>";
        echo "<td>" .$row['Full_Name'] . "</td>";
        echo "<td>" .$row['Email_Address'] . "</td>";
        echo "<td>" .$row['Telephone_Number'] . "</td>";
        echo "<td>" .$row['pais'] . "</td>";
        echo "<td>" .$row['ciudad'] . "</td>";
        echo "<td>" .$row['nombre_hotel'] . "</td>";
        echo "<td>" .$row['fecha_in'] . "</td>";
        echo "<td>" .$row['Fecha_out'] . "</td>";
        echo "<td>" .$row['adultos'] . "</td>";
        echo "<td>" .$row['ninos'] . "</td>";
        echo "<td>" .$row['mensaje'] . "</td>";
        echo '<td><a class="btn btn-danger" href=delete.php?id=' . $row['id'] . '>Borrar</a></td>';
        echo "</tr>";
        echo "</table></div></div></div>";
    }
}

else {
    echo "0 results";
}
$conn->close();
include('footer.php');
?>