requireLogin(); echo "

資料庫連接測試

"; try { require_once '../config/database.php'; $database = new Database(); $db = $database->getConnection(); echo "

✅ 資料庫連接成功

"; // Test query $query = "SELECT COUNT(*) as count FROM brands"; $stmt = $db->prepare($query); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); echo "

品牌數量: " . $result['count'] . "

"; // Test insert $test_name = '測試品牌_' . time(); $query = "INSERT INTO brands (name, website, industry, description) VALUES (:name, :website, :industry, :description)"; $stmt = $db->prepare($query); $stmt->bindParam(':name', $test_name); $stmt->bindParam(':website', 'https://test.com'); $stmt->bindParam(':industry', '測試'); $stmt->bindParam(':description', '測試描述'); if ($stmt->execute()) { echo "

✅ 測試插入成功

"; // Clean up $query = "DELETE FROM brands WHERE name = :name"; $stmt = $db->prepare($query); $stmt->bindParam(':name', $test_name); $stmt->execute(); echo "

🧹 測試數據已清理

"; } else { echo "

❌ 測試插入失敗

"; } } catch (Exception $e) { echo "

❌ 資料庫錯誤: " . $e->getMessage() . "

"; } ?>