哪位高手麻烦帮我看下哪里错了，ecshop评论采集的
哪位高手麻烦帮我看下吧里错了，发布时加入`photo1`, `photo2`, `photo3`, `photo4`, `photo5`, `photo1_thumb`, `photo2_thumb`, `photo3_thumb`, `photo4_thumb`, `photo5_thumb`
`$photo1`, `$photo2`, `$photo3`, `$photo4`, `$photo5`, `$photo1_thumb`, `$photo2_thumb`, `$photo3_thumb`, `$photo4_thumb`, `$photo5_thumb`
就写入不到数据库里面
<?php
header('conten-type:text/html;charset=utf8');
require('data/config.php');
$conn = mysql_connect($db_host,$db_user,$db_pass ) or die("连接数据库失败!");
mysql_select_db($db_name,$conn);
mysql_query("set names utf8,sql_mode=''");
mysql_query("SET character_set_results=utf8");
$pre=$prefix;
/* 检查货号是否重复 */
if (!empty($_POST['goods_sn']))
{
$username = trim($_POST['username']);
$time1 = trim($_POST['time']);
$info = trim($_POST['info']);
$good_id = trim($_POST['goods_sn']);
$photo1 = trim($_POST['photo1']);
$photo2 = trim($_POST['photo2']);
$photo3 = trim($_POST['photo3']);
$photo4 = trim($_POST['photo4']);
$photo5 = trim($_POST['photo5']);
$photo1_thumb = trim($_POST['photo1_thumb']);
$photo2_thumb = trim($_POST['photo2_thumb']);
$photo3_thumb = trim($_POST['photo3_thumb']);
$photo4_thumb = trim($_POST['photo4_thumb']);
$photo5_thumb = trim($_POST['photo5_thumb']);
//$sql = "SELECT goods_id FROM " . $ecs->table('goods'). " WHERE goods_sn = '$_POST'";
// $good_id = $db->getOne($sql);
// exit($good_id);
if ($good_id > 0)
{
$sql = "INSERT INTO {$pre}comment (`comment_id`, `comment_type`, `id_value`, `email`, `user_name`, `content`, `comment_rank`, `add_time`, `ip_address`, `status`, `parent_id`, `user_id`, `photo1`, `photo2`, `photo3`, `photo4`, `photo5`, `photo1_thumb`, `photo2_thumb`, `photo3_thumb`, `photo4_thumb`, `photo5_thumb`)" . "VALUES ( NULL, '0', '$good_id', '', '$username', '$info', '5', '$time1', '', '1', '0', '0', `$photo1`, `$photo2`, `$photo3`, `$photo4`, `$photo5`, `$photo1_thumb`, `$photo2_thumb`, `$photo3_thumb`, `$photo4_thumb`, `$photo5_thumb`)";
// exit($sql);
mysql_query($sql);
echo "评论添加成功";
}
else{
echo "无此编号商品";
}
}else{
echo "请输入正确的商品编号";
}
?>
:(:(:(:(:(:(:(:(:(:(:(:(:(:(:(:(:(:( 这是入库的规则还是其它的？ 看不明白
页:
[1]