";
require_once '../config/database.php';
try {
$database = new Database();
$conn = $database->getConnection();
if ($conn) {
echo "✅ Database connected!
";
// Test query
$stmt = $conn->query("SHOW TABLES");
$tables = $stmt->fetchAll(PDO::FETCH_COLUMN);
echo "Tables found: " . count($tables) . "
";
// Check if our tables exist
$ourTables = ['skin_analysis_sessions', 'skin_concerns_detected', 'available_symptoms'];
foreach ($ourTables as $table) {
if (in_array($table, $tables)) {
echo "✅ {$table} exists
";
} else {
echo "❌ {$table} NOT found
";
}
}
} else {
echo "❌ Database connection failed!
";
}
} catch (Exception $e) {
echo "❌ Error: " . $e->getMessage() . "
";
}
?>