求指点 求助 圣诞快乐 ~

[neuuuuuuu]

<?php
 

$conn = mysql_connect("localhost", "root", "");

if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("root",$conn)or die(mysql_error());
mysql_query('set names GB2312');
$sql= update shopsystem set   name=$name, tel=$tel ,mail=$mail ,QQ=$QQ, addr=$addr, sex=$sex, brandname=$brandname, commoditybrand=$commoditybrand, productID=$productID, ordername=$ordername, shopname=$shopname, shopaddr=$shopaddr, invoicenumber=$invoicenumber, purchasingdate=$purchasingdate where id=$id;


if (!mysql_query($sql,$conn))
  {
  die ('Error: ' . mysql_error());
  }

mysql_close($conn);
?>

报错
Parse error: syntax error, unexpected 'shopsystem' (T_STRING) in G:\wamp\www\net work\xiugai.php on line 12

[果酱很好吃]

sql语句为何不用引号引起来 $sql= “update shopsystem set name=$name, tel=$tel ,mail=$mail ,QQ=$QQ, addr=$addr, sex=$sex, brandname=$brandname, commoditybrand=$commoditybrand, productID=$productID, ordername=$ordername, shopname=$shopname, shopaddr=$shopaddr, invoicenumber=$invoicenumber, purchasingdate=$purchasingdate where id=$id”;

[neuuuuuuu]

引号加了 也报错 = - Notice: Undefined variable: name in G:\wamp\www\net work\xiugai.php on line 12 Notice: Undefined variable: tel in G:\wamp\www\net work\xiugai.php on line 12 貌似执行了 但是数据库里是空白数据

[一起混吧]

$name ，$tel 变量在哪定义的？

[傲雪星枫]

1. $sql= update shopsystem set name=$name, tel=$tel ,mail=$mail ,QQ=$QQ, addr=$addr, sex=$sex, brandname=$brandname, commoditybrand=$commoditybrand, productID=$productID, ordername=$ordername, shopname=$shopname, shopaddr=$shopaddr, invoicenumber=$invoicenumber, purchasingdate=$purchasingdate where id=$id; 改为 $sql= "update shopsystem set name=$name, tel=$tel ,mail=$mail ,QQ=$QQ, addr=$addr, sex=$sex, brandname=$brandname, commoditybrand=$commoditybrand, productID=$productID, ordername=$ordername, shopname=$shopname, shopaddr=$shopaddr, invoicenumber=$invoicenumber, purchasingdate=$purchasingdate where id=$id"; 2.$name, $tel这两个变量你没有赋值。

[码无边]

贴出表结构看看

[neuuuuuuu]

<?php
$conn=mysql_connect('localhost','root','');
mysql_select_db('root');
 mysql_query("set names 'GBK'");
?>



<?php
$id = $_GET["id"];
$sql="select * from shopsystem where id=$id";
$query=mysql_query($sql);
$rs=mysql_fetch_array($query);


?>

<form method="post" action="xiugai.php">
<tr>
<td>
<P>：      <input type="hidden" id="id" value="<?php echo $rs['id']?>"/> *</P>
<P>：      <input type="text" id="name" value="<?php echo $rs['name']?>"/> *</P>
<P>：      <input type="text" id="tel" value="<?php echo $rs['tel']?>"/> *</P>
<P>：      <input type="text" id="email" value="<?php echo $rs['email']?>"/> *</P>
<P>：         <input type="text" id="QQ" value="<?php echo $rs['QQ']?>"'/> *</P>
<P>：      <input type="text" id="addr" value="<?php echo $rs['addr']?>"/> *</P>
<P>：      <input type="text" id="sex" value="<?php echo $rs['sex']?>"/> *</P>

<P>：  <input type="text" id="brandname" value="<?php echo $rs['name']?>"/> *</P>
<P>：  <input type="text" id="commoditybrand" value="<?php echo $rs['commoditybrand']?>"/> *</P>
<P>：  <input type="text" id="productID" value="<?php echo $rs['productID']?>"/> *</P>
<P>：  <input type="text" id="ordername" value="<?php echo $rs['ordername']?>"/> *</P>

<P>：  <input type="text" id="shopname" value="<?php echo $rs['shopname']?>"/> *</P>
<P>：  <input type="text" id="shopaddr" value="<?php echo $rs['shopaddr']?>"/> *</P>
<P>：  <input type="text" id="invoicenumber" value="<?php echo $rs['invoicenumber']?>"/> *</P>
<P>：  <input type="text" id="purchasingdate" value="<?php echo $rs['purchasingdate']?>"/> *</P>
<P>：1990-01-01  * </P>
<td><input name='del' type='submit' id='del' value='修改' /></td>
</tr>
</from>

<?php

 

$conn = mysql_connect("localhost", "root", "");

if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("root",$conn)or die(mysql_error());
mysql_query('set names GB2312');
$sql= "UPDATE shopsystem SET name=$name,tel=$tel,email=$email,QQ=$QQ,addr=$addr,sex=$sex,brandname=$brandname,commoditybrand=$commoditybrand,productID=$productID,ordername=$ordername,shopname=$shopname,shopaddr=$shopaddr,invoicenumber=$invoicenumber,purchasingdate=$purchasingdate WHERE  id=$id";



if (!mysql_query($sql,$conn))
  {
  die ('Error: ' . mysql_error());
  }

mysql_close($conn);
?>

完整的代码 = - 求助

[neuuuuuuu]

因为论坛屏蔽 = - input前面的字段我就删了 那个表单里所有变量都在报错