php 数据能够获取 但无法写入数据库 同一文件另一个表可能写入
//session_id(sid);
// session_start();
require_once(../connect/conn_sql.php); //包含数据库链接文件
if( $_post[txt_taker]!= && $_post[txt_address]!= && $_post[txt_tel]!= && $_post[txt_paymethod]!= ) {
$taker = $_post[txt_taker]; //收货人
$address = $_post[txt_address]; //收货地址
$tel = $_post[txt_tel]; //联系电话
$paymethod = $_post[txt_paymethod];//付款方式
$username = $_post[txt_username]; //会员名
$pnums = $_post[txt_pnums]; //商品数量
$omoney = $_post[txt_omoney]; //订单金额
$remark = $_post[txt_remark]; //备注
$onum = date('ymdhis').$username; //生成订单号
$createtime = date('y-m-d h:i:s');; //订单提交日期
$str1 = insert into tb_order (m_name,o_num,p_nums,o_money,o_taker,o_address,o_tel,o_paymethod,o_createtime,o_status,o_remark)
values('$username','$onum',$pnums,$omoney,'$taker','$address','$tel','$paymethod','$createtime',0,'$remark');
echo $str1;
$insert1 = mysql_query($str1); //执行sql语句
echo $insert1; //添加到订单商品详细表
session_start();
$array=explode(@,$_session['producelist']);
$arrayquatity=explode(@,$_session['quatity']);
$s=0;
$i=0;
for($i=0;$iif($s!=0 ) {
for($i=0;$i$pid =$array[$i]; //商品编号
$sql=select * from tb_product where p_id =.$pid; $arr = mysql_query($sql); $info=mysql_fetch_array($arr);
$onum = date('ymdhis').$username;
$p_unitprice =$info['p_vprice'];//单价
$p_nums =$arrayquatity[$i]; //数量
$p_price = $arrayquatity[$i]*$info['p_vprice']; //小计价格
$str2 = insert into tb_order_product (o_num,p_id,p_unitprice,p_nums,p_flod,p_price) values('$onum',$pid,$p_unitprice,$p_nums,1,$p_price); $insert2 = mysql_query($str2); //执行sql语句
}
}
if( $insert1 && $insert2) //如果两张表的数据都插入成功
{
$_session['qk'] = yes; //清空购物车
echo ; }
else { echo ;
}
}
else { echo ;