56 行
2.1 KiB
PHP
56 行
2.1 KiB
PHP
<?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";
|
|
}
|
|
?>
|