求各位大神帮忙看看
功能:读取文本框text1的值通过ajax传到后台作为数据库查询的条件,希望返回的json作为下拉框中的值,截图上可以看出,json数据已经生成。
问题:json无法返回,通过error查看,报parsererror错误。
下面贴出代码和相关截图
前台html
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<script type="text/javascript" src="jquery.min.js"></script>
<title>Document</title>
</head>
<script>
$(function(){
//getSelectVal();
$("input[name=text1]").change(function(){
alert($("input[name=text1]").val())
getSelectVal();
});
});
function getSelectVal(){
$.ajax({
contentType: "application/json" ,
url:'select.php',
data:{text1:$("input[name=text1]").val()},
async:false,
dataType:'json',
success:function (result) {
for(var i=1;i<result.length;i++){
$('#select1').append("<option value='"+select[i].partNumber+"'>"+select[i].partNumber+"</option>");
}
},
error: function(XMLHttpRequest, textStatus, errorThrown) {
alert(XMLHttpRequest.status);
alert(XMLHttpRequest.readyState);
alert(textStatus);
},
});
}
</script>
<body>
<label>大类:</label>
<input type="text" name="text1" value="">
<label>小类:</label>
<select name="select1" id="select1">
</select>
</body>
</html>
后台php
<?ph
header("Content-type: text/html; charset=utf-8");
error_reporting(E_ALL || ~E_NOTICE);
$text1 = $_GET['text1'];
var_dump($text1);
$db=@new mysqli("localhost","root","xxxxxxxx","xxxxxx");
mysqli_set_charset($db,"UTF-8");
if(mysqli_connect_errno()){
echo"数据库连接失败!<br />";
echo mysqli_connect_error();
exit;
}
if(isset($bigid)){var_dump(isset($bigid));
$q=("select partNumber from part_list where orderNumber ='$text1'");
$rs=$db->query($q);
while($row=mysqli_fetch_array($rs)){
$result[] = array("partNumber"=>$row[partNumber]);
}
echo json_encode($result);
}
功能:读取文本框text1的值通过ajax传到后台作为数据库查询的条件,希望返回的json作为下拉框中的值,截图上可以看出,json数据已经生成。
问题:json无法返回,通过error查看,报parsererror错误。
下面贴出代码和相关截图
前台html
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<script type="text/javascript" src="jquery.min.js"></script>
<title>Document</title>
</head>
<script>
$(function(){
//getSelectVal();
$("input[name=text1]").change(function(){
alert($("input[name=text1]").val())
getSelectVal();
});
});
function getSelectVal(){
$.ajax({
contentType: "application/json" ,
url:'select.php',
data:{text1:$("input[name=text1]").val()},
async:false,
dataType:'json',
success:function (result) {
for(var i=1;i<result.length;i++){
$('#select1').append("<option value='"+select[i].partNumber+"'>"+select[i].partNumber+"</option>");
}
},
error: function(XMLHttpRequest, textStatus, errorThrown) {
alert(XMLHttpRequest.status);
alert(XMLHttpRequest.readyState);
alert(textStatus);
},
});
}
</script>
<body>
<label>大类:</label>
<input type="text" name="text1" value="">
<label>小类:</label>
<select name="select1" id="select1">
</select>
</body>
</html>
后台php
<?ph
header("Content-type: text/html; charset=utf-8");
error_reporting(E_ALL || ~E_NOTICE);
$text1 = $_GET['text1'];
var_dump($text1);
$db=@new mysqli("localhost","root","xxxxxxxx","xxxxxx");
mysqli_set_charset($db,"UTF-8");
if(mysqli_connect_errno()){
echo"数据库连接失败!<br />";
echo mysqli_connect_error();
exit;
}
if(isset($bigid)){var_dump(isset($bigid));
$q=("select partNumber from part_list where orderNumber ='$text1'");
$rs=$db->query($q);
while($row=mysqli_fetch_array($rs)){
$result[] = array("partNumber"=>$row[partNumber]);
}
echo json_encode($result);
}