问题描述:
本地开发环境WAMPServer,thinkphp3.2.2,php版本5.6.25。项目部署到服务器时,发现服务器环境是IIS,php版本7。部署到服务器后,_订单页面_的datatable插件进行ajax请求时报404错误,_其他页面_的datatable插件进行ajax请求是正常的。
订单页面的js是从其他正常页面copy过来修改的,应该没错,而且我把本地php版本换成7后,只修改了数据库连接类型为mysqli,就完全正常,基本排除代码问题和php版本问题。
**此外直接访问ajax请求地址是正常的。**
贴下报错信息
以下是ajax请求的indexController下的datatable_order()方法。
public function datatable_order(){
$data = $_REQUEST;
$start = isset($data['start']) ? $data['start'] : 0;
$end = isset($data['length']) ? $data['length'] : 10;
$sn = isset($data['STAFF_NAME']) ? $data['STAFF_NAME'] : '';
$si = isset($data['STAFF_ID']) ? $data['STAFF_ID'] : '';
$et = isset($data['EXCHANGE_TYPE']) ? $data['EXCHANGE_TYPE'] : '';
$gi = isset($data['GOODS_ID']) ? $data['GOODS_ID'] : '';
$ic = isset($data['IS_CANCEL']) ? $data['IS_CANCEL'] : '';
$sql = "1=1 ";
if($sn!='') {
$sql .= "AND xs.sname LIKE '%$sn%' ";
}
if($si!='') {
$sql .= "AND xo.userid LIKE '%$si%' ";
}
if($et!='') {
$sql .= "AND xo.ostatus = '$et' ";
}
if($gi!='') {
$sql .= "AND xo.gid LIKE '%$gi%' ";
}
if($ic!='') {
$sql .= "AND xo.otype = '$ic' ";
}
$xo = M('xgqc_order xo');
$rs = $xo->field('xo.*,xs.sname,xs.sphone,xd.dname,xg.gtitle')
->join('left join xgqc_staff xs on xo.userid=xs.userid')
->join('left join xgqc_dept xd on xs.sdept=xd.did')
->join('left join xgqc_goods xg on xo.gid=xg.gid')
->where($sql)
->limit($start,$end)
->order('xo.create_time desc')
->select();
$res = array();
$index = 1;
foreach ($rs as $k=>$v){
$row = $v;
$row['INDEX'] = $index;
$index++;
$res[] = $row;
}
$rs = $xo->join('left join xgqc_staff xs on xo.userid=xs.userid')
->join('left join xgqc_dept xd on xs.sdept=xd.did')
->join('left join xgqc_goods xg on xo.gid=xg.gid')
->where($sql)
->count();
$total = 0;
if($rs){
$total = intval($rs);
}
echo json_encode(
array(
'iTotalRecords'=>intval($end), //本次加载记录数量
'iTotalDisplayRecords'=>$total, //总记录数量
'aaData'=> $res
)
);
}