ajax +json 传递不过去文本框输入的参数,求大神指教 后台的参数能传回
前端代码
```
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title>TEST</title>
<script type="text/javascript" src="js/echarts.js"></script>
<script type="text/javascript" src="js/jquery-2.1.4.js"></script>
</head>
<body>
<input type="text" id="username">
<input type="text" id="password">
<button id="sub">查询</button>
<span id="text"></span>
<div id="main" style="height:400px"></div>
<script type="text/javascript">
$(document).ready(function(){
$("#sub").on("click",function(){
var myChart = echarts.init(document.getElementById('main'));
var arr1=[],arr2=[];
function arrTest(){
var username=$('#username').val();
var password=$('#password').val();
$.ajax({
type:"post",
async:false,
url:"json.php",
result:{username:username,password:password},
dataType:"json",
success:function(result){
if (result) {
for (var i = 0; i < result.length; i++) {
arr1.push(result[i].name);
arr2.push(result[i].age);
}
}
}
})
return arr1,arr2;
}
arrTest();
var option = {
tooltip: {
show: true
},
legend: {
data:['age']
},
xAxis : [
{
type : 'category',
data : arr1
}
],
yAxis : [
{
type : 'value'
}
],
series : [
{
"name":"age",
"type":"bar",
"data":arr2
}
]
};
myChart.setOption(option);
});
});
</script>
</body>
```
后端
```
<?php
// require("db_config.php");
//连接数据库
header('Content-type:text/json;charset=utf-8');
$conn = oci_connect('PC_MES', 'PC_mes951', '192.168.4.119/orcl');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
else {
}
//$p = $_GET["username"];
$p="20180621";
$query8 = "SELECT STAGE name,SUM(MAIN_QTY) age FROM((";
$query8 .= " SELECT distinct a.lot_id,b.stage,a.main_qty";
$query8 .= " FROM sn_report.STG_MES_WIP_LOT_HIS A,";
$query8 .= " SN_REPORT.STG_MES_CT_FLOW B";
$query8 .= " WHERE A.QUEUE_TIME >=";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')";
$query8 .= " AND A.QUEUE_TIME <";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')+1";
$query8 .= " AND A.LAST_STEP_NAME = B.STEPNAME";
$query8 .= " AND A.STAGE_ID <> B.STAGE";
$query8 .= " AND B.PART_NAME = A.PART_NAME";
$query8 .= " AND A.GRADE2 <> 'SL'";
$query8 .= " AND A.TRANS_TYPE IN ('NEWPART','MOVENEXT','SKIPLOT')";
$query8 .= " AND NVL(substr(A.STAGE_ID,-6),'A') <> 'REWORK'";
$query8 .= " and NVL(substr(b.stage,-6),'A') <> 'REWORK')";
$query8 .= " Union ALL";
$query8 .= " (select a.lot_id,a.stage_id,a.main_qty from sn_report.STG_MES_WIP_LOT_HIS A";
$query8 .= " where A.STATE = 'FIN'";
$query8 .= " AND A.TRACK_OUT_TIME >";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')";
$query8 .= " AND A.TRACK_OUT_TIME <=";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')+1))";
$query8 .= " GROUP BY STAGE";
$query= $query8;
$stid = oci_parse($conn, $query);
if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if(!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
exit;
}
$result="";
$array= array();
class User{
public $name;
public $age;
}
while($row = oci_fetch_array($stid, OCI_RETURN_NULLS)){
$user=new User();
$user->name = $row['0'];
$user->age = $row['1'];
$array[]=$user;
}
$result=json_encode($array);
// echo "{".'"name"'.":".$age."}";
oci_close($conn);
echo json_encode($array);
?>
```
前端代码
```
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title>TEST</title>
<script type="text/javascript" src="js/echarts.js"></script>
<script type="text/javascript" src="js/jquery-2.1.4.js"></script>
</head>
<body>
<input type="text" id="username">
<input type="text" id="password">
<button id="sub">查询</button>
<span id="text"></span>
<div id="main" style="height:400px"></div>
<script type="text/javascript">
$(document).ready(function(){
$("#sub").on("click",function(){
var myChart = echarts.init(document.getElementById('main'));
var arr1=[],arr2=[];
function arrTest(){
var username=$('#username').val();
var password=$('#password').val();
$.ajax({
type:"post",
async:false,
url:"json.php",
result:{username:username,password:password},
dataType:"json",
success:function(result){
if (result) {
for (var i = 0; i < result.length; i++) {
arr1.push(result[i].name);
arr2.push(result[i].age);
}
}
}
})
return arr1,arr2;
}
arrTest();
var option = {
tooltip: {
show: true
},
legend: {
data:['age']
},
xAxis : [
{
type : 'category',
data : arr1
}
],
yAxis : [
{
type : 'value'
}
],
series : [
{
"name":"age",
"type":"bar",
"data":arr2
}
]
};
myChart.setOption(option);
});
});
</script>
</body>
```
后端
```
<?php
// require("db_config.php");
//连接数据库
header('Content-type:text/json;charset=utf-8');
$conn = oci_connect('PC_MES', 'PC_mes951', '192.168.4.119/orcl');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
else {
}
//$p = $_GET["username"];
$p="20180621";
$query8 = "SELECT STAGE name,SUM(MAIN_QTY) age FROM((";
$query8 .= " SELECT distinct a.lot_id,b.stage,a.main_qty";
$query8 .= " FROM sn_report.STG_MES_WIP_LOT_HIS A,";
$query8 .= " SN_REPORT.STG_MES_CT_FLOW B";
$query8 .= " WHERE A.QUEUE_TIME >=";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')";
$query8 .= " AND A.QUEUE_TIME <";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')+1";
$query8 .= " AND A.LAST_STEP_NAME = B.STEPNAME";
$query8 .= " AND A.STAGE_ID <> B.STAGE";
$query8 .= " AND B.PART_NAME = A.PART_NAME";
$query8 .= " AND A.GRADE2 <> 'SL'";
$query8 .= " AND A.TRANS_TYPE IN ('NEWPART','MOVENEXT','SKIPLOT')";
$query8 .= " AND NVL(substr(A.STAGE_ID,-6),'A') <> 'REWORK'";
$query8 .= " and NVL(substr(b.stage,-6),'A') <> 'REWORK')";
$query8 .= " Union ALL";
$query8 .= " (select a.lot_id,a.stage_id,a.main_qty from sn_report.STG_MES_WIP_LOT_HIS A";
$query8 .= " where A.STATE = 'FIN'";
$query8 .= " AND A.TRACK_OUT_TIME >";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')";
$query8 .= " AND A.TRACK_OUT_TIME <=";
$query8 .= " to_date('$p 08:00:00','yyyymmdd hh24:mi:ss')+1))";
$query8 .= " GROUP BY STAGE";
$query= $query8;
$stid = oci_parse($conn, $query);
if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if(!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
exit;
}
$result="";
$array= array();
class User{
public $name;
public $age;
}
while($row = oci_fetch_array($stid, OCI_RETURN_NULLS)){
$user=new User();
$user->name = $row['0'];
$user->age = $row['1'];
$array[]=$user;
}
$result=json_encode($array);
// echo "{".'"name"'.":".$age."}";
oci_close($conn);
echo json_encode($array);
?>
```