火车采集器软件交流官方论坛

 找回密码
 加入会员
搜索
火车采集器V9版免费下载火车浏览器 - 可视采集,万能群发,全自动脚本工具
查看: 4304|回复: 2

哪位高手麻烦帮我看下哪里错了,ecshop评论采集的

[复制链接]
发表于 2015-6-2 15:07:52 | 显示全部楼层 |阅读模式
哪位高手麻烦帮我看下吧里错了,发布时加入
`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[goods_sn]'";
       // $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 "请输入正确的商品编号";
    }

?>
发表于 2015-9-2 19:13:23 | 显示全部楼层
这是入库的规则还是其它的? 看不明白
您需要登录后才可以回帖 登录 | 加入会员

本版积分规则

QQ|手机版|Archiver|火车采集器官方站 ( 皖ICP备06000549 )

GMT+8, 2025-5-13 08:11

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表