exec('set names utf8');
//取出ID对应的商品
$sql="select * from products where proID=$id";
$rs=$dbcn->query($sql);
$rows=$rs->fetch(PDO::FETCH_ASSOC);//因为只取出一条数据,所以不需要循环
//修改业务逻辑
if(isset($_POST['submit'])){
$proname=$_POST['proname'];
$proguide=$_POST['proguide'];
$proprice=$_POST['proprice'];
$proamount=$_POST['proamount'];
$proimages=$_POST['proimages'];
$proweb=$_POST['proweb'];
//拼接sql语句
$sql="update products set
proname= '$proname',
proguide='$proguide',
proprice='$proprice',
proamount='$proamount',
proimages='$proimages',
proweb='$proweb'
where proID=$id";
//执行修改语句
if($dbcn->exec($sql)){
header('location:admin.php');
}else{
echo '修改失败!';
}
}
?>