<?php
// 数据库配置
$host = '127.0.0.1';
$dbname = 'mss_nahaichuan_c';
$username = 'mss_nahaichuan_c';
$password = 'MyNmyAaRj9yWKPKH';

try {
    // 连接数据库
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    echo "数据库连接成功！\n\n";
    
    // 检查商品表结构
    echo "=== ls_retail_goods 表结构 ===\n";
    $result = $pdo->query("DESCRIBE ls_retail_goods");
    $columns = $result->fetchAll(PDO::FETCH_ASSOC);
    foreach ($columns as $column) {
        echo $column['Field'] . " - " . $column['Type'] . " - " . $column['Null'] . " - " . $column['Default'] . "\n";
    }
    
    echo "\n=== ls_retail_goods_class 表结构 ===\n";
    $result = $pdo->query("DESCRIBE ls_retail_goods_class");
    $columns = $result->fetchAll(PDO::FETCH_ASSOC);
    foreach ($columns as $column) {
        echo $column['Field'] . " - " . $column['Type'] . " - " . $column['Null'] . " - " . $column['Default'] . "\n";
    }
    
    echo "\n=== ls_retail_goods_brand 表结构 ===\n";
    $result = $pdo->query("DESCRIBE ls_retail_goods_brand");
    $columns = $result->fetchAll(PDO::FETCH_ASSOC);
    foreach ($columns as $column) {
        echo $column['Field'] . " - " . $column['Type'] . " - " . $column['Null'] . " - " . $column['Default'] . "\n";
    }
    
    // 检查现有数据
    echo "\n=== 现有商品数量 ===\n";
    $result = $pdo->query("SELECT COUNT(*) as count FROM ls_retail_goods");
    $count = $result->fetch(PDO::FETCH_ASSOC);
    echo "商品总数: " . $count['count'] . "\n";
    
    echo "\n=== 现有分类数量 ===\n";
    $result = $pdo->query("SELECT COUNT(*) as count FROM ls_retail_goods_class");
    $count = $result->fetch(PDO::FETCH_ASSOC);
    echo "分类总数: " . $count['count'] . "\n";
    
    echo "\n=== 现有品牌数量 ===\n";
    $result = $pdo->query("SELECT COUNT(*) as count FROM ls_retail_goods_brand");
    $count = $result->fetch(PDO::FETCH_ASSOC);
    echo "品牌总数: " . $count['count'] . "\n";
    
} catch (Exception $e) {
    echo "错误: " . $e->getMessage() . "\n";
}
?>