dqeznd1697 2014-05-03 10:13
浏览 44
已采纳

试图通过ajax调用php页面

On submit alert is working but inside ajax code not working. value store in var and go to ajax page where i trying to use mysql insert query but its not working properly. I after ajax success result is not display, For a sec ajax file name shows in NET (error console)

JQuery Code:

$(document).ready(function(){   
$('#submit').click(function(){
var project_ID = $('#project_name').val();
var accommodation=$('#accommodation').val();
var no_of_floors=$('#no_of_floors').val();
var no=$('#no').val();
 if(project_ID==''){
    alert('Select Project Name');
}
if(accommodation==''){
    alert('Select Accomodation Scale');
}
 if($('#typeI').prop('checked')){
    var type1=$('#typeI').val();
    }
if($('#typeII').prop('checked')){
    var type2=$('#typeII').val();
    }
if($('#typeIII').prop('checked')){
    var type3=$('#typeIII').val();
    }
if($('#typeIV').prop('checked')){
    var type4=$('#typeIV').val();
    }
    if(project_ID!="" && accommodation!='') 
   {
    $.ajax({url:"villa_Accomo_type.php?project_ID="+project_ID
   +"&accommodation="+accommodation+"&type1="+type1+"&type2="+type2
   +"&type3="+type3+"&type4="+type4+"&no_of_floors="+no_of_floors+"&no="+no,
      success:function(result){
          res=result;
        alert(res);

     }

}); 
   }
 });
 });

AJAX PAGE

    <?php
$project_ID    = $_GET['project_ID'];
$accommodation = $_GET['accommodation'];
$type1         = $_GET['type1'];
$type2         = $_GET['type2'];
$type3         = $_GET['type3'];
$type4         = $_GET['type4'];
$no_of_floors  = $_GET['no_of_floors'];
$no            = $_GET['no'];

echo $insert = "insert into villas_scale (project_id,scale,type,
  no_of_floors,no)    values('$project_ID',
'$accommodation','$type1','$no_of_floors','$no')";
mysql_query($insert);

echo $insert2 = "insert into villas_scale (project_id,scale,
 type,no_of_floors,no) values('$project_ID',
'$accommodation','$type2','$no_of_floors','$no')";
mysql_query($insert2);

echo $insert3 = "insert into villas_scale (project_id,scale,
  type,no_of_floors,no) values('$project_ID',
'$accommodation','$type3','$no_of_floors','$no')";
mysql_query($insert3);
echo $insert4 = "insert into villas_scale (project_id,scale,
 type,no_of_floors,no) values('$project_ID',
'$accommodation','$type4','$no_of_floors','$no')";
mysql_query($insert4);

?> 
  • 写回答

1条回答 默认 最新

  • dongque4778 2014-05-03 10:19
    关注

    I have to edit so many errors in your code .jsFiddle

    var no = $('#no').val();
    if (project_ID === '') {
        alert('Select Project Name');
    }
    if (accommodation === '') {
        alert('Select Accomodation Scale');
    }
    if ($('#typeI').prop('checked')) {
        var type1 = $('#typeI').val();
    }
    if ($('#typeII').prop('checked')) {
        var type2 = $('#typeII').val();
    }
    if ($('#typeIII').prop('checked')) {
        var type3 = $('#typeIII').val();
    }
    if ($('#typeIV').prop('checked')) {
        var type4 = $('#typeIV').val();
    }
    if (project_ID !== "" && accommodation !== '') {
        $.ajax({
            url: "villa_Accomo_type.php",//This should the url where you send data
            type: 'GET',
            data: project_ID = "project_ID" + project_ID + " & accommodation = " + accommodation + " & type1 = " + type1 + " & type2 = " + type2 + " & type3 = " + type3 + " & type4 = " + type4 + " & no_of_floors = " + no_of_floors + " & no = " + no, // here you need the specify your serialize object 
            success: function (result) {
                alert(result);
    
            }
    
        });
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 5037端口被adb自己占了
  • ¥15 Error in check.length("fill") : 'gpar'成分'fill'的长度不能为零
  • ¥15 python:excel数据写入多个对应word文档
  • ¥60 全一数分解素因子和素数循环节位数
  • ¥15 ffmpeg如何安装到虚拟环境
  • ¥188 寻找能做王者评分提取的
  • ¥15 matlab用simulink求解一个二阶微分方程,要求截图
  • ¥30 乘子法解约束最优化问题的matlab代码文件,最好有matlab代码文件
  • ¥15 写论文,需要数据支撑
  • ¥15 identifier of an instance of 类 was altered from xx to xx错误