jquery+ajax+php

index.html

```

league
 
 
 
 
 
    作品类型
 
 
    作品名称
 
 
    参加人员
 
 
    指导老师
 
 
    联系电话
 
 
    学校名称
 
 
    报名
 
 
$('#sign').click(function() {
    alert('sign');
    var prodType = $('#prodType').val();
    var prodName = $("#prodName").val();
    var member = $("#member").val();
    var teacher = $("#teacher").val();
    var telephone = $("#telephone").val();
    var school = $("#school").val();
    if (prodType == '' || prodName == '' || member == '' || teacher == '' || telephone == '' || school == '') {
         alert("所有数据均必填");
     }else{
   if (telephone.length == 11) {
        $.ajax({
            type: "POST",
            url: "testDb.php",
            dataType: "JSON",
            data: {
                "prodType": prodType,
                "prodName": prodName,
                "member": member,
                "teacher": teacher,
                "telephone": telephone,
                "school": school,
            },
            success: function(data) {
                switch (data) {
                    case 1: //用户已存在
                        alert("报名成功")
                        break;
                    case 0: //注册成功
                        alert("报名失败")
                        break;
                }
 
            }
        })
    } else {
        alert('请检查您的联系方式');
    }
  }     
})      

testDB.php

``` prepare("INSERT INTO league VALUES (?, ?, ?, ?,?,?)");

$insert->bind_param('ssssss', $prodType,$prodName,$member,$teacher,$telephone,$school); //防止sql注入 $insert->execute(); echo 1;

} catch (Exception $e) { echo 0; }

​