【求助】新增了个字段，但是没法输入数据

2016-07-07 15:22 来源：www.chinab4c.com 作者：ecshop专家

给产品增加了一个字段，goods_url，按照这个帖子（http://bbs.ecshop.com/thread-119955-1-1.html）的说明，添加字段成功，前台也能正常调用，但是就是在后台没法输入数据，总是显示默认数据，如附件所示。直接操作数据，能够正常输入url，前台正常调用，后台也能正常读入，但是一修改就又变成附件那样了。搞了一晚上也没搞定。下面是我的admin/goods.php的相关代码，求高手帮忙。

  1. /* 处理商品数据 */
  2. $shop_price = !empty($_POST['shop_price']) ? $_POST['shop_price'] : 0;
  3. $goods_url = !empty($_POST['goods_url']) ? $_POST['goods_url'] : 0;
  4. $market_price = !empty($_POST['market_price']) ? $_POST['market_price'] : 0;
  5. $promote_price = !empty($_POST['promote_price']) ? floatval($_POST['promote_price'] ) : 0;
  6. $is_promote = empty($promote_price) ? 0 : 1;
  7. $promote_start_date = ($is_promote && !empty($_POST['promote_start_date'])) ? local_strtotime($_POST['promote_start_date']) : 0;
  8. $promote_end_date = ($is_promote && !empty($_POST['promote_end_date'])) ? local_strtotime($_POST['promote_end_date']) : 0;
  9. $goods_weight = !empty($_POST['goods_weight']) ? $_POST['goods_weight'] * $_POST['weight_unit'] : 0;
  10. $is_best = isset($_POST['is_best']) ? 1 : 0;
  11. $is_new = isset($_POST['is_new']) ? 1 : 0;
  12. $is_hot = isset($_POST['is_hot']) ? 1 : 0;
  13. $is_on_sale = isset($_POST['is_on_sale']) ? 1 : 0;
  14. $is_alone_sale = isset($_POST['is_alone_sale']) ? 1 : 0;
  15. $goods_number = isset($_POST['goods_number']) ? $_POST['goods_number'] : 0;
  16. $warn_number = isset($_POST['warn_number']) ? $_POST['warn_number'] : 0;
  17. $goods_type = isset($_POST['goods_type']) ? $_POST['goods_type'] : 0;
  18. $give_integral = isset($_POST['give_integral']) ? intval($_POST['give_integral']) : '-1';
  19. $rank_integral = isset($_POST['rank_integral']) ? intval($_POST['rank_integral']) : '-1';

  21. $goods_name_style = $_POST['goods_name_color'] . '+' . $_POST['goods_name_style'];

  23. $catgory_id = empty($_POST['cat_id']) ? '' : intval($_POST['cat_id']);
  24. $brand_id = empty($_POST['brand_id']) ? '' : intval($_POST['brand_id']);

  26. $goods_img = (empty($goods_img) && !empty($_POST['goods_img_url']) && goods_parse_url($_POST['goods_img_url'])) ? htmlspecialchars(trim($_POST['goods_img_url'])) : $goods_img;
  27. $goods_thumb = (empty($goods_thumb) && !empty($_POST['goods_thumb_url']) && goods_parse_url($_POST['goods_thumb_url'])) ? htmlspecialchars(trim($_POST['goods_thumb_url'])) : $goods_thumb;
  28. $goods_thumb = (empty($goods_thumb) && isset($_POST['auto_thumb']))? $goods_img : $goods_thumb;

  30. /* 入库 */
  31. if ($is_insert)
  32. {
  33. if ($code == '')
  34. {
  35. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
  36. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
  37. "goods_url, " .
  38. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
  39. "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, " .
  40. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, rank_integral)" .
  41. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
  42. "'$brand_id', '$shop_price', '$goods_url', '$market_price', '$is_promote','$promote_price', ".
  43. "'$goods_url', ".
  44. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".
  45. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
  46. " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', ".
  47. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral')";
  48. }
  49. else
  50. {
  51. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
  52. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
  53. "goods_url, " .
  54. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
  55. "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, is_real, " .
  56. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)" .
  57. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
  58. "'$brand_id', '$shop_price', '$goods_url', '$market_price', '$is_promote','$promote_price', ".
  59. "'$goods_url', ".
  60. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".
  61. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
  62. " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', 0, '$is_on_sale', '$is_alone_sale', ".
  63. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$code', '$rank_integral')";
  64. }
  65. }
  66. else
  67. {
  68. /* 如果有上传图片，删除原来的商品图 */
  69. $sql = "SELECT goods_thumb, goods_img, original_img " .
  70. " FROM " . $ecs->table('goods') .
  71. " WHERE goods_id = '$_REQUEST[goods_id]'";
  72. $row = $db->getRow($sql);
  73. if ($proc_thumb && $goods_img && $row['goods_img'] && !goods_parse_url($row['goods_img']))
  74. {
  75. @unlink(ROOT_PATH . $row['goods_img']);
  76. @unlink(ROOT_PATH . $row['original_img']);
  77. }

  79. if ($proc_thumb && $goods_thumb && $row['goods_thumb'] && !goods_parse_url($row['goods_thumb']))
  80. {
  81. @unlink(ROOT_PATH . $row['goods_thumb']);
  82. }

  84. $sql = "UPDATE " . $ecs->table('goods') . " SET " .
  85. "goods_name = '$_POST[goods_name]', " .
  86. "goods_name_style = '$goods_name_style', " .
  87. "goods_sn = '$goods_sn', " .
  88. "cat_id = '$catgory_id', " .
  89. "brand_id = '$brand_id', " .
  90. "shop_price = '$shop_price', " .
  91. "goods_url = '$goods_url', " .
  92. "market_price = '$market_price', " .
  93. "is_promote = '$is_promote', " .
  94. "promote_price = '$promote_price', " .
  95. "promote_start_date = '$promote_start_date', " .
  96. "promote_end_date = '$promote_end_date', ";

  98. /* 如果有上传图片，需要更新数据库 */
  99. if ($goods_img)
  100. {
  101. $sql .= "goods_img = '$goods_img', original_img = '$original_img', ";
  102. }
  103. if ($goods_thumb)
  104. {
  105. $sql .= "goods_thumb = '$goods_thumb', ";
  106. }
  107. if ($code != '')
  108. {
  109. $sql .= "is_real=0, extension_code='$code', ";
  110. }
  111. $sql .= "keywords = '$_POST[keywords]', " .
  112. "goods_brief = '$_POST[goods_brief]', " .
  113. "seller_note = '$_POST[seller_note]', " .
  114. "goods_weight = '$goods_weight'," .
  115. "goods_url = '$goods_url'," .
  116. "goods_number = '$goods_number', " .
  117. "warn_number = '$warn_number', " .
  118. "integral = '$_POST[integral]', " .
  119. "give_integral = '$give_integral', " .
  120. "rank_integral = '$rank_integral', " .
  121. "is_best = '$is_best', " .
  122. "is_new = '$is_new', " .
  123. "is_hot = '$is_hot', " .
  124. "is_on_sale = '$is_on_sale', " .
  125. "is_alone_sale = '$is_alone_sale', " .
  126. "goods_desc = '$_POST[goods_desc]', " .
  127. "last_update = '". gmtime() ."', ".
  128. "goods_type = '$goods_type' " .
  129. "WHERE goods_id = '$_REQUEST[goods_id]' LIMIT 1";
  130. }
  131. $db->query($sql);
复制代码

ec1.jpg (15.92 KB)

ec1.jpg


回答：
不是看这里。你获取的时候。是不是intval处理了

不是看这里。你获取的时候。是不是intval处理了
netaxcess 发表于 2010-10-29 09:34


能告诉我看哪里吗，我技术基本不懂，都是跟着别人依葫芦画瓢