-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathapi2.php
133 lines (111 loc) · 3.3 KB
/
api2.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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<?php
// Database connection settings
$host = '172.18.0.2';
$user = 'root';
$password = 'passw0rd';
$database = 'dmr-database';
$table = 'radioid_data';
$columns = ['RADIO_ID', 'CALLSIGN', 'FIRST_NAME', 'CITY', 'STATE', 'COUNTRY'];
// Error reporting for debugging
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
// Create connection
$conn = new mysqli($host, $user, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Function to escape SQL special characters
function escape($value) {
global $conn;
return $conn->real_escape_string($value);
}
// Fetch query parameters
$searchParams = [];
foreach ($columns as $column) {
if (isset($_GET[strtolower($column)])) {
$searchParams[$column] = $_GET[strtolower($column)];
}
}
// Display overview of options if no parameters are given
if (empty($searchParams)) {
header('Content-Type: application/json');
echo json_encode([
'message' => 'Please provide one or more of the following parameters: f.e. api.php?callsign=pd2emc',
'parameters' => array_map('strtolower', $columns)
]);
exit;
}
// Display loading message
echo "<html><body><div id='loading'>One moment please, until the data is pulled and ready to be shown...</div></body></html>";
// JavaScript to clear the screen and show the data
echo "
<script>
setTimeout(function() {
document.body.innerHTML = '';
}, 1000);
</script>
";
// Allow some time for the message to be displayed
flush();
ob_flush();
sleep(1);
// Build SQL query
$sql = "SELECT * FROM $table";
$whereClauses = [];
$fetchAll = false;
foreach ($searchParams as $column => $value) {
if ($value === '*') {
$fetchAll = true;
break;
}
if (strpos($value, '*') !== false) {
$value = str_replace('*', '%', escape($value));
$whereClauses[] = "$column LIKE '$value'";
} else {
$value = escape($value);
$whereClauses[] = "$column = '$value'";
}
}
if (!$fetchAll && count($whereClauses) > 0) {
$sql .= " WHERE " . implode(' AND ', $whereClauses);
}
// Function to fetch all results
function fetchAllResults($conn, $sql) {
$results = [];
$result = $conn->query($sql);
if ($result === false) {
return ['error' => 'Database query failed: ' . $conn->error];
}
while ($row = $result->fetch_assoc()) {
$results[] = $row;
}
return $results;
}
// Fetch all results
$output = fetchAllResults($conn, $sql);
// Close connection
$conn->close();
// Prepare JSON output
$jsonOutput = json_encode($output);
// Debug output
file_put_contents('debug_log.txt', print_r($jsonOutput, true));
?>
<script>
// Function to clear the screen and display the results
function displayResults() {
document.body.innerHTML = '';
var data = <?php echo json_encode($output); ?>;
// Check if data contains an error
if (data.error) {
document.body.textContent = 'Error: ' + data.error;
return;
}
var pre = document.createElement('pre');
pre.textContent = JSON.stringify(data, null, 2);
document.body.appendChild(pre);
}
// Wait for a moment before displaying the results
setTimeout(displayResults, 1000);
</script>