insert_customer_ok.php

十大精典PHP项目开发全程案例+代码

<?php  include("conn/conn.php");
if($Submit=="提交"){
   if(preg_match("/^(\d{11})$/",$customer_tel,$counts)){ 
     if(preg_match("/\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/",$customer_mail,$counts)){   
$sql="insert into tb_customer(customer_name,customer_tel,customer_mail,customer_address,customer_category,customer_birthday)values('".$customer_name."','".$customer_tel."','".$customer_mail."','".$customer_address."','".$customer_category."','".$customer_birthday."')";
	   $rs=new com("adodb.recordset");
	   $rs->open($sql,$conn,3,1);
echo "<script>alert('客户添加成功！');history.back();</script>";

 }else{
         echo "<script>alert('您输入的邮箱地址的格式不正确!!');history.back()</script>";

}}else{
         echo "<script>alert('您输入的电话号码的格式不正确!!');history.back()</script>";
}}
?>