我有一个ajax请求获取json字符串,但由于某种原因它已经开始返回“undefined”,json字符串确实返回有效的JSON,但它只是不工作!ajax请求不返回值
Ajax请求:
if (editSeq) {
$.ajax({
url: './json/admin/getData.php',
type: 'POST',
async: false,
data: { SEQ: editSeq },
dataType: 'json',
success: function (data) {
var HTML = data.HTML;
$('#blankform').append(HTML);
alert(HTML);
}
});
JSON:
include("../../includes/db.php");
$SEQ = $_POST["SEQ"];
$sth = sqlsrv_query($conn,"SELECT HTML from TBL_DATA WHERE Sequence = " . $SEQ);
$rows = array();
while($r = sqlsrv_fetch_array($sth,SQLSRV_FETCH_ASSOC)) {
$rows[] = $r;
}
if($sth === false)
{
echo "Error in query preparation/execution.\n";
die(print_r(sqlsrv_errors(), true));
}
print json_encode($rows);
?>
这是我的JSON响应:
[
{
"HTML": " \n\n
}
]
2014-01-26
realtek
+1
首先,使用PHP中的参数化查询! http:// stackoverflow。com/questions/60174/how-can-i-prevent-sql -injection-in-php http://www.codinghorror.com/blog/2005/04/give-me-parameterized-sql-or-give -me-death.html –
+0
json在php方面看起来如何? –
+0
尝试回显而不是打印....? –