我的数据没有使用ajax保存在数据库中 [英] my data is not saving in database using ajax

问题描述

这是javacript和ajax不知道什么是错误，我尝试了这个没有ajax的工作，但与ajax不工作。

this is javacript and ajax dont know what is error i tried this without ajax its working but with ajax not working.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js">
</script>
<script type="text/javascript" >
$(function() {
$(".submit").click(function() {
var name = $("#User_Name").val();
var email = $("#User_Email").val();
var mobno = $("#User_Email").val();
var landlineno = $("#user_MobileNo").val();
var proprTd = $("#propertyids").val();
var dataString = 'User_Name='+ name + 'User_Email=' + email + 'User_Email=' + mobno + 'user_MobileNo=' + landlineno + 'propertyids=' + proprTd;

if(name=='' || email=='' || mobno=='' || landlineno=='')
{
$('.success').fadeOut(200).hide();
$('.error').fadeOut(200).show();
}
else
{
$.ajax({
type: "POST",
url: "SaveContactDetails.php",
data: dataString,
success: function(){
$('.success').fadeIn(200).show();
$('.error').fadeOut(200).hide();
}
});
}
return false;
});
});
</script>

这是html代码
不知道什么是错误， ajax无效。

this is html code dont know what is error i tried this without ajax its working but with ajax not working.

<form method="post" name="form" >
<input type="hidden" name="propertyid" id="propertyids" value="<?php echo $Propid  ?>" >
                <input id="individual" name="rdoiam" value="individual" type="radio" class="input-38-ieo">
                Individual
                <input id="Agent" name="rdoiam" value="individual" type="radio" class="input-38-ieo">
                Agent
                <input id="builder" name="rdoiam" value="individual" type="radio" class="input-38-ieo">
                Builder <span id="ReqTypeErrorDiv12968081_left" class="span-41-ieo"></span> </li>
              <li class="li-42-ieo">
                <label class="label-43-ieo">Name<span class="span-37-ieo">*</span></label>
                :
                <input type="text" id="User_Name"  name="User_Name" maxlength="30" class="input-45-ieo11">
<input  type="text" class="input-276-ieo11" id="Mobileno" name="user_MobileNo"  maxlength="12">
<input  type="text" class="input-276-ieo11" id="userLandlineno" name="userLandlineno"  maxlength="12">
</form>

这是php文件

<?php
   include 'config.php';

    $iam ="";
    $User_Name="";
    $User_Email="";
     $user_MobileNo="";
     $user_LandlineNo="";
     $txtMessage="";
   if (isset($_POST['rdoiam']))
 {
 $iam =$_POST['rdoiam'];
 }

      if (isset($_POST['User_Name']))
 {
  $User_Name=$_POST['User_Name'];
 }
      if (isset($_POST['User_Email']))
 {
   $User_Email=$_POST['User_Email'];
 }
      if (isset($_POST['user_MobileNo']))
 {
  $user_MobileNo=$_POST['user_MobileNo'];
 }
          if (isset($_POST['userLandlineno']))
 {
 $user_LandlineNo=$_POST['userLandlineno'];
 }
 if(isset($_POST['txtMessage']))
 {

    $txtMessage=$_POST['txtMessage'];
 }


   $Propid=$_POST['propertyid'];




        $iam =trim($iam);
    $User_Name=trim($User_Name);
    $User_Email=trim($User_Email);
     $user_MobileNo=trim($user_MobileNo);
     $user_LandlineNo=trim($user_LandlineNo);
     $txtMessage=trim($txtMessage);


$str="Call sp_SaveContactDetails('".$iam."','".$User_Name."','".$User_Email."','".$user_MobileNo."','".$user_LandlineNo."','".$txtMessage."','".$Propid."')";

   // $sql=mysql_query($str);
    if(!mysql_query($str)) 
{ 
 die('Error:'.mysql_error()); 
 } 
 else 

 { 







  }
     ?>

推荐答案

您缺少& 在您的数据字符串中：

You are missing & in your data string:

var dataString = 'User_Name='+ name + 'User_Email=' + email + 'User_Email=' + mobno + 'user_MobileNo=' + landlineno + 'propertyids=' + proprTd;

它必须是：

It has to be:

var dataString = 'User_Name='+ name + '&User_Email=' + email + '&User_Email=' + mobno + '&user_MobileNo=' + landlineno + '&propertyids=' + proprTd;

这就是为什么它没有发送正确的数据，只要你想。当然，你可以序列化你所有的数据......

Thats why its not sending proper data, as you want. Of course, you can serialize all your data...

你也应该使用encodeURIComponent，因为如果用户添加&或=，你的字符串将会中断。

Also you should be using encodeURIComponent because if the user adds a & or =, your string is going to break.

这篇关于我的数据没有使用ajax保存在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！