// insert customer address插入客户信息
$query = "select customerid from customers where
name = '$name' and address = '$address'
and city = '$city' and state = '$state'
and zip = '$zip' and country = '$country'";
$result = mysql_query($query);
if(mysql_num_rows($result)>0) //这里是如果数据库已有客户信息,那么就不用再插入客户的信息了.
{
$customer = mysql_fetch_array($result, MYSQL_ASSOC);
$customerid = $customer['customerid'];
}
else //这里是如果数据库没有客户信息,那么插入他的信息
{
$query = "insert into customers values
('', '$name','$address','$city','$state','$zip','$country')";
$result = mysql_query($query);
if (!$result)
return false; $customerid = $result['customerid'];//(我的问题很可能出在这里,因为我想在下面引用这个新插入客户的ID,
//所以,这里写的不知是否正确。id是auto_crement;
}
以下是插入客户订单信息,它需要引用上面的$customerid.
$date = date('Y-m-d');
$query = "insert into orders values
('', $customerid, ".$_SESSION['total_price'].", '$date', 'PARTIAL', '$ship_name',
'$ship_address','$ship_city','$ship_state','$ship_zip',
'$ship_country')"; $result = mysql_query($query);
if (!$result)
return false; 不知道为什么挺入不了?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货