我有一个AJAX请求从MySQL获取数据。根据请求,成功部分中的result
变量包含一个空字符串,""
。如果我将数据类型更改为json
则不会得到任何结果。
$.ajax({
url: "test.php",
dataType: 'text',
success: function(result) {
alert(result);
}
});
<?php
$con = mysqli_connect("localhost", "root", "", "test");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "SELECT * FROM 'tabel_name'";
$result = mysqli_query($con, $sql);
?>
结果出现此空字符串的原因可能是什么?我在表中有数据,没有任何异常。
在你的 php 代码中
<?php
$con=mysqli_connect("localhost","root","","test");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT * FROM 'tabel_name'";
$result=mysqli_query($con,$sql);
$resultant_array = array();
$index = 0;
while($row = mysql_fetch_array($result)) {
foreach($row as $column => $val) {
$result[$index][$column] = $val;
}
$index++;
}
echo json_ecode($resultant_array);
?>
这样,您将获得ajax成功承诺内的响应数据