<?php
echo "姓名:".$_POST['name']."<br/>";
// echo $_POST['price']."<br/>";
// echo $_POST['type']."<br/>";
// echo $_POST['name']."<br/>";
echo "电话:". $_POST['tel']."<br/>";
echo "电邮:".$_POST['email']."<br/>";
echo "QQ:".$_POST['QQ']."<br/>";
echo "地址:".$_POST['addr']."<br/>";
echo "性别:".$_POST['sex']."<br/>";
echo "商品名称:".$_POST['brandname']."<br/>";
echo "商品品牌:".$_POST['commoditybrand']."<br/>";
echo "商品编号:".$_POST['productID']."<br/>";
echo "商品序号:".$_POST['ordername']."<br/>";
echo "商铺名称:".$_POST['shopname']."<br/>";
echo "商铺地址:".$_POST['shopaddr']."<br/>";
echo "发票编号:".$_POST['invoicenumber']."<br/>";
echo "购买日期:".$_POST['purchasingdate']."<br/>";
$dingdanhao = date("Y-m-dH-i-s");
$dingdanhao = str_replace("-","",$dingdanhao);
$dingdanhao .= rand(1000,2000);
echo "保用编号:". $dingdanhao;
$name=$_POST['name'];
$tel=$_POST['tel'];
$email=$_POST['email'];
$QQ=$_POST['QQ'];
$sex=$_POST['sex'];
$brandname=$_POST['brandname'];
$commoditybrand=$_POST['commoditybrand'];
$productID=$_POST['productID'];
$ordername=$_POST['ordername'];
$shopname=$_POST['shopname'];
$shopaddr=$_POST['shopaddr'];
$invoicenumber=$_POST['invoicenumber'];
$purchasingdate=$_POST['purchasingdate'];
require_once("conn.php");
if(mysql_query("insert into name set
name='$name',tel='$tel',email='$email',QQ='$QQ',sex='$sex',brandname='$brandname',commodity
brand='$commoditybrand',productID='$productID',ordername='$ordername',shopname='$shopname',
shopaddr='$shopaddr',invoicenumber='$invoicenumber',purchasingdate='$purchasingdate'",
$conn)){
echo "添加成功!<a href='testmysql.php'>查看数据库</a>";
}
else{
echo '添加失败!';
}
mysql_close($con);
?>
错误报告 如下 :
Notice: Undefined variable: con in D:\wamp\www\WWW\post.php on line 55
Call Stack
( ! ) Warning: mysql_close() expects parameter 1 to be resource, null given in D:\wamp\www\WWW\post.php on line 55
= - 求助
------解决思路----------------------
mysql_close($con);改成mysql_close($conn);
------解决思路----------------------
$con 写错了,应该是$conn
你上面的程序有写的。
mysql_query("insert into name set
name='$name',tel='$tel',email='$email',QQ='$QQ',sex='$sex',brandname='$brandname',commodity
brand='$commoditybrand',productID='$productID',ordername='$ordername',shopname='$shopname',
shopaddr='$shopaddr',invoicenumber='$invoicenumber',purchasingdate='$purchasingdate'",
$conn))