🔧 IoT System Test
";
// Test 1: Database Connection
echo "1️⃣ Database Connection
";
try {
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
if ($db) {
echo "
✅ Database connected successfully!
";
} else {
echo "
❌ Database connection failed!
";
exit;
}
} catch (Exception $e) {
echo "
❌ Error: " . htmlspecialchars($e->getMessage()) . "
";
exit;
}
echo "
2️⃣ IoT Tables Check
";
$tables = ['iot_devices', 'iot_commands', 'iot_logs', 'iot_sensors_data', 'iot_schedules'];
$missing_tables = [];
foreach ($tables as $table) {
$check = $db->query("SHOW TABLES LIKE '{$table}'");
if ($check->rowCount() > 0) {
$count = $db->query("SELECT COUNT(*) FROM {$table}")->fetchColumn();
echo "
✅ Table '{$table}' exists ({$count} rows)
";
} else {
$missing_tables[] = $table;
echo "
❌ Table '{$table}' NOT FOUND
";
}
}
if (!empty($missing_tables)) {
echo "
";
}
echo "
3️⃣ Sample Data
";
try {
$devices = $db->query("SELECT * FROM iot_devices LIMIT 5")->fetchAll(PDO::FETCH_ASSOC);
if (!empty($devices)) {
echo "
📱 Found " . count($devices) . " devices:
";
echo "
" . json_encode($devices, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE) . "
";
} else {
echo "
⚠️ No devices found. Add some devices to test!
";
}
} catch (Exception $e) {
echo "
❌ Query Error: " . htmlspecialchars($e->getMessage()) . "
";
}
echo "
4️⃣ API Endpoints
";
$apis = [
'Devices API' => '../api/iot/devices.php',
'Commands API' => '../api/iot/commands.php',
'Logs API' => '../api/iot/logs.php',
'ESP Control API' => '../api/esp_control.php'
];
foreach ($apis as $name => $path) {
if (file_exists($path)) {
echo "
✅ {$name} exists
";
} else {
echo "
❌ {$name} NOT FOUND at {$path}
";
}
}
echo "