报错代码:UPDATE `goods` SET `freight_payer`="buyer", `detail_url`="http://item.taobao.com/item.htm?id=35141486991&spm=2014.21609800.0.0", `title`="实拍秋冬新款 百搭扣千格鸟修身 小脚长裤", `pic_url`="http://img02.taobaocdn.com/bao/uploaded/i2/14141028695665324/T16kGOFapeXXXXXXXX_!!0-item_pic.jpg", `price`="59.00", `coupon_price`="59.00", `begin_time`="1382976000", `end_time`="1384704000", `promote_id`="6", `category_id`="0", `num`="3000", `pindao_id`="6", `description`="" WHERE `id`=""<?phpinclude './../../include/admincommon.inc.php';
$id = $_GET["id"];
$currentPage='goods_manage';
$manageGroup = 'contentGroup';$categoryArr = rGetCategoryArr();
$pindaoArr = rGetPindaoArr();
$promoteArr = rGetPromotePositionArr('goods');$sql = "select * from `goods` where `id`=$id";
foreach ($pdo->query($sql) as $row)
{
$id = $row['id'];
$detail_url = $row['detail_url'];
$title = $row['title'];
$pic_url = $row['pic_url'];
$price = $row['price'];
$coupon_price = $row['coupon_price'];
$begin_time = $row['begin_time'];
$end_time = $row['end_time'];
$title = str_replace("<", "[", $title);
$title = str_replace(">", "]", $title);
$promote_id= $row['promote_id'];
$pindao_id= $row['promote_id'];
$category_id = $row['category_id'];
$num=$row['num'];
$nick=$row['nick'];
$description=$row['description'];
$freight_payer = $row['freight_payer'];
}$updateMessage='';
$dopost = isset($_POST['dopost'])?$_POST['dopost']:'';
if ($dopost == 'update')
{
$freight_payer =$_POST['freight_payer'];
$id = $_POST['id'];
$detail_url = $_POST["detail_url"];
$title = $_POST["title"];
$pic_url = $_POST["pic_url"];
$price = $_POST["price"];
$coupon_price = $_POST["coupon_price"];
$begin_time = strtotime($_POST["begin_time"]);
$end_time = strtotime($_POST["end_time"]);
$promote_id= $_POST['promote_id'];
$pindao_id= $_POST['pindao_id'];
$category_id = $_POST['category_id'];
$num=$_POST['num'];
$nick=$_POST['nick'];
$description=$_POST['description'];
if ($detail_url == "" || $title == "" || $pic_url == "" || $price == "" || $coupon_price == "")
{
$updateMessage = "请把商品信息填写完整!!";
}
else
{
//修改数据库开始
$sql = 'UPDATE `goods` SET `freight_payer`="'.$freight_payer.'", `detail_url`="' . $detail_url . '", `title`="' . $title . '", `pic_url`="' . $pic_url . '", `price`="' . $price .
'", `coupon_price`="' . $coupon_price . '", `begin_time`="' . $begin_time . '", `end_time`="' . $end_time . '", `promote_id`="' . $promote_id .
'", `category_id`="' . $category_id . '", `num`="'.$num.'", `pindao_id`="'.$pindao_id.'", `description`="'.$description.'" WHERE `id`='.$id;
$result = $pdo->exec($sql);
if ($result > 0)
{
$updateMessage = "修改成功";
}
else
{
echo $sql;
$updateMessage = "修改失败";
}
}
}
$id = $_GET["id"];
$currentPage='goods_manage';
$manageGroup = 'contentGroup';$categoryArr = rGetCategoryArr();
$pindaoArr = rGetPindaoArr();
$promoteArr = rGetPromotePositionArr('goods');$sql = "select * from `goods` where `id`=$id";
foreach ($pdo->query($sql) as $row)
{
$id = $row['id'];
$detail_url = $row['detail_url'];
$title = $row['title'];
$pic_url = $row['pic_url'];
$price = $row['price'];
$coupon_price = $row['coupon_price'];
$begin_time = $row['begin_time'];
$end_time = $row['end_time'];
$title = str_replace("<", "[", $title);
$title = str_replace(">", "]", $title);
$promote_id= $row['promote_id'];
$pindao_id= $row['promote_id'];
$category_id = $row['category_id'];
$num=$row['num'];
$nick=$row['nick'];
$description=$row['description'];
$freight_payer = $row['freight_payer'];
}$updateMessage='';
$dopost = isset($_POST['dopost'])?$_POST['dopost']:'';
if ($dopost == 'update')
{
$freight_payer =$_POST['freight_payer'];
$id = $_POST['id'];
$detail_url = $_POST["detail_url"];
$title = $_POST["title"];
$pic_url = $_POST["pic_url"];
$price = $_POST["price"];
$coupon_price = $_POST["coupon_price"];
$begin_time = strtotime($_POST["begin_time"]);
$end_time = strtotime($_POST["end_time"]);
$promote_id= $_POST['promote_id'];
$pindao_id= $_POST['pindao_id'];
$category_id = $_POST['category_id'];
$num=$_POST['num'];
$nick=$_POST['nick'];
$description=$_POST['description'];
if ($detail_url == "" || $title == "" || $pic_url == "" || $price == "" || $coupon_price == "")
{
$updateMessage = "请把商品信息填写完整!!";
}
else
{
//修改数据库开始
$sql = 'UPDATE `goods` SET `freight_payer`="'.$freight_payer.'", `detail_url`="' . $detail_url . '", `title`="' . $title . '", `pic_url`="' . $pic_url . '", `price`="' . $price .
'", `coupon_price`="' . $coupon_price . '", `begin_time`="' . $begin_time . '", `end_time`="' . $end_time . '", `promote_id`="' . $promote_id .
'", `category_id`="' . $category_id . '", `num`="'.$num.'", `pindao_id`="'.$pindao_id.'", `description`="'.$description.'" WHERE `id`='.$id;
$result = $pdo->exec($sql);
if ($result > 0)
{
$updateMessage = "修改成功";
}
else
{
echo $sql;
$updateMessage = "修改失败";
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货