-
Notifications
You must be signed in to change notification settings - Fork 0
/
allEvents.php
60 lines (50 loc) · 2.08 KB
/
allEvents.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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<?php
//Connect to db
include_once "connect.php";
$numberOfEvents = 0; // Start with no events found
$arr[0] = 0;
// Check if date variable is set
if (isset($_POST["year"]) && isset($_POST["month"]) && isset($_POST["network"])) {
$year = trim($_POST["year"]); // set date
$month = trim($_POST["month"]);
$network = trim($_POST["network"]);
$allNetworks = 'Ottawa Area';
if (strlen($month) < 2)
$month = "0" . $month;
for ($day = 1; $day <= 31; $day++) {
$dayS = $day;
if (strlen($day) < 2)
$dayS = "0" . $day;
$date = $mysqli->real_escape_string("%" . $year . "-" . $month . "-" . $dayS . "%"); // Get date term
if ($network == $allNetworks) {
// Query to get the events on this date in entire DB (all networks)
$query = "SELECT COUNT(*) FROM events WHERE start_date LIKE ? ";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param("s", $date); // Bind parameters
$stmt->execute(); // Execute statement
$stmt->bind_result($eventid); // Bind result variables
// fetch values
$stmt->bind_result($count);
while ($stmt->fetch()) {
$arr[$day] = $count;
}
}
} else {
// Query to get the events on this date on a specific network
$query = "SELECT COUNT(*) FROM events WHERE (start_date LIKE ? AND event_network=?) OR (start_date LIKE ? AND event_network=?) ";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param("ssss", $date, $network, $date, $allNetworks); // Bind parameters
$stmt->execute(); // Execute statement
$stmt->bind_result($eventid); // Bind result variables
// fetch values
$stmt->bind_result($count);
while ($stmt->fetch()) {
$arr[$day] = $count;
}
}
}
}
}
$mysqli->close(); // Close connection
echo json_encode($arr); // echo the output (JSON) which will be interpreted in javascript as an object
?>