-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathGetAcceptedMeetings.php
45 lines (35 loc) · 1.16 KB
/
GetAcceptedMeetings.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<?php
include "Conx.php";
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Headers: Content-Type');
header('Access-Control-Allow-Methods: GET');
header('Content-Type: application/json');
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$user_id = $_GET['user_id'];
if (!$user_id) {
echo json_encode(['success' => false, 'message' => 'User ID is required']);
exit;
}
$query = "
SELECT m.id, m.event_title, m.start_date, m.start_time, m.end_time, m.location
FROM clientmeeting cm
INNER JOIN meetings m ON cm.meeting_id = m.id
WHERE cm.client_id = ?
";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$meetings = [];
while ($row = $result->fetch_assoc()) {
$meetings[] = $row;
}
echo json_encode(['success' => true, 'meetings' => $meetings]);
} else {
echo json_encode(['success' => false, 'message' => 'No accepted meetings found']);
}
$stmt->close();
}
$conn->close();
?>