dongzhan9100 2012-05-06 08:39
浏览 778
已采纳

发生错误:SyntaxError:JSON.parse:意外字符

I'm trying to update a record with JQuery/JSON but I'm seeing this error:

An error has occurred:

[object Object]

parsererror

SyntaxError: JSON.parse: unexpected character

My JS:

jQuery('#commentForm').live('submit', function (event) {
event.preventDefault()


jQuery.ajax(edit_url, {
    data: jQuery(this).serialize(),
    dataType: 'json',
    type: 'POST',
    success: function (data) {
        if (data.error === 'OK') {
            alert('ok c good')
        } else {
            alert('hi' + data.error)
        }
    },
    error: function(x,y,z){
        alert('An error has occurred:
' + x + '
' + y + '
' + z);
    }
})

return false;
})

And my php:

$ret = array(
    'error'             =>  'OK',
);
$update =
    "UPDATE crm_set_users SET ".
        "crm_set_users_civilite = '".mysql_real_escape_string($crm_set_users_civilite)."',".
        "crm_set_users_nom = '".mysql_real_escape_string($crm_set_users_nom)."',".
        "crm_set_users_prenom = '".mysql_real_escape_string($crm_set_users_prenom)."',".
        "crm_set_users_email = '".mysql_real_escape_string($crm_set_users_email)."', ".
        "crm_set_users_telephone = '".mysql_real_escape_string($crm_set_users_telephone)."', ".
        "crm_set_users_portable = '".mysql_real_escape_string($crm_set_users_portable)."'";

if($crm_set_users_photo != ""){
    $update .=", crm_set_users_photo = '".mysql_real_escape_string($crm_set_users_photo)."'";
}   

$update .=
    "WHERE ".
        "crm_set_users_id = '".mysql_real_escape_string($user_id)."'";




echo json_encode($ret);
exit;

If my php is :

$ret = array(
    'error'             =>  'OK',
);
echo json_encode($ret);
exit;

then it works...

Tks for you help!

  • 写回答

2条回答 默认 最新

  • dr897777 2012-05-06 08:59
    关注

    Probably your PHP throws some Errors or Warnings, which make the returned document not a valid JSON string. Use a debugger like FireBug to see, what actual result is returned by your PHP script.

    Following the PHP docu for mysql_real_escape_string (link)it will throw an Error, if there is no active MySQL connection available. Maybe that's your problem.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 用ucinet怎么计算子群体个数和核心边缘结构拟合度
  • ¥15 nrf52810-c三个a 程序
  • ¥15 lego-loam跑出来的roll误差很大
  • ¥50 求一个半透明没有锯齿的圆角窗体的实现例子
  • ¥15 STM32cubeMX里的FreeRTOS无法释放内存
  • ¥15 CATIA有些零件打开直接单机确定终止
  • ¥15 请问有会的吗,用MATLAB做
  • ¥15 phython如何实现以下功能?查找同一用户名的消费金额合并—
  • ¥15 孟德尔随机化怎样画共定位分析图
  • ¥18 模拟电路问题解答有偿速度