27 lines
637 B
PHP
27 lines
637 B
PHP
<?php
|
|
header('Content-Type: application/json');
|
|
|
|
// Test database connection
|
|
$conn = new mysqli("localhost", "root", "", "webgis_unified");
|
|
if ($conn->connect_error) {
|
|
echo json_encode(['success' => false, 'error' => 'DB Connection: ' . $conn->connect_error]);
|
|
exit;
|
|
}
|
|
|
|
// Test table structure
|
|
$result = $conn->query("DESCRIBE data_unified");
|
|
$columns = [];
|
|
while($row = $result->fetch_assoc()) {
|
|
$columns[] = $row['Field'];
|
|
}
|
|
|
|
echo json_encode([
|
|
'success' => true,
|
|
'database' => 'webgis_unified',
|
|
'table' => 'data_unified',
|
|
'columns' => $columns,
|
|
'column_count' => count($columns)
|
|
]);
|
|
$conn->close();
|
|
?>
|