37 lines
1003 B
PHP
37 lines
1003 B
PHP
<?php
|
|
include_once('connection.php');
|
|
include_once('functions.php');
|
|
$conn = openDatabaseConnection();
|
|
|
|
$sql = "SELECT
|
|
c.*,
|
|
u.first_name,
|
|
u.last_name,
|
|
u.profile_pic
|
|
FROM campsites c
|
|
LEFT JOIN users u ON c.user_id = u.user_id";
|
|
|
|
$result = $conn->query($sql);
|
|
|
|
$campsites = [];
|
|
while ($row = $result->fetch_assoc()) {
|
|
$campsites[] = [
|
|
'id' => $row['id'],
|
|
'name' => $row['name'],
|
|
'description' => $row['description'],
|
|
'website' => $row['website'],
|
|
'telephone' => $row['telephone'],
|
|
'latitude' => $row['latitude'],
|
|
'longitude' => $row['longitude'],
|
|
'thumbnail' => $row['thumbnail'],
|
|
'user' => [
|
|
'first_name' => $row['first_name'],
|
|
'last_name' => $row['last_name'],
|
|
'profile_pic' => $row['profile_pic']
|
|
]
|
|
];
|
|
}
|
|
|
|
header('Content-Type: application/json');
|
|
echo json_encode($campsites);
|