一切都OK,就是中文搜索就报错。
json转码什么都试过了还是不行啊。求大神帮我看看

  • 'ywsj_event_name',
  • 1 => 'ywsj_type',
  • 2=> 'ywsj_bu',
  • 4=> 'ywsj_top_manager',
  • 5=> 'ywsj_presenter',
  • 6=> 'ywsj_start_date',
  • 7=> 'ywsj_end_date',
  • 8=> 'ywsj_handler',
  • 9=> 'ywsj_state'
  • );
  • $sql = "SELECT ywsj_event_name, ywsj_type, ywsj_bu, ywsj_top_manager,ywsj_presenter, ywsj_start_date,ywsj_end_date, ywsj_handler, ywsj_state";
  • $sql.=" FROM gta_oam_worksheet";
  • $query=mysqli_query($conn, $sql) or die("data.php: get gta_oam_worksheet");
  • $totalData = mysqli_num_rows($query);
  • $totalFiltered = $totalData;
  • - if( !empty($requestData['search']['value']) ) {
  • // if there is a search parameter
  • $sql = "SELECT ywsj_event_name, ywsj_type, ywsj_bu, ywsj_top_manager,ywsj_presenter, ywsj_start_date,ywsj_end_date, ywsj_handler, ywsj_state";
  • $sql.=" FROM gta_oam_worksheet";
  • $sql.=" WHERE ywsj_event_name LIKE '%".$requestData['search']['value']."%' "; // $requestData['search']['value'] contains search parameter
  • $sql.=" OR ywsj_type LIKE '%".$requestData['search']['value']."%' ";
  • $sql.=" OR ywsj_bu LIKE '%".$requestData['search']['value']."%' ";
  • $sql.=" OR ywsj_handler LIKE '%".$requestData['search']['value']."%' ";
  • $sql.=" OR ywsj_start_date LIKE '%".$requestData['search']['value']."%' ";
  • $sql.=" OR ywsj_state LIKE '%".$requestData['search']['value']."%' ";
  • $sql.=" OR ywsj_end_date LIKE '%".$requestData['search']['value']."%' ";
  • $sql.=" OR ywsj_presenter LIKE '%".$requestData['search']['value']."%' ";
  • $query=mysqli_query($conn, $sql) or die("data.php: get gta_oam_worksheet");
  • $totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result without limit in the query
  • $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." "; // $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc , $requestData['start'] contains start row number ,$requestData['length'] contains limit length.
  • $query=mysqli_query($conn, $sql) or die("data.php: get gta_oam_worksheet"); // again run query with limit
  • - } else {
  • $sql = "SELECT ywsj_event_name, ywsj_type, ywsj_bu, ywsj_top_manager,ywsj_presenter, ywsj_start_date,ywsj_end_date, ywsj_handler, ywsj_state";
  • $sql.=" FROM gta_oam_worksheet";
  • $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
  • $query=mysqli_query($conn, $sql) or die("data.php: get gta_oam_worksheet");
  • }
  • $data = array();
  • while( $row=mysqli_fetch_array($query) ) { // preparing an array
  • $nestedData=array();
  • $nestedData[] = $row["ywsj_event_name"];
  • $nestedData[] = $row["ywsj_type"];
  • $nestedData[] = $row["ywsj_bu"];
  • $nestedData[] = $row["ywsj_top_manager"];
  • $nestedData[] = $row["ywsj_presenter"];
  • $nestedData[] = $row["ywsj_start_date"];
  • $nestedData[] = $row["ywsj_end_date"];
  • $nestedData[] = $row["ywsj_handler"];
  • $nestedData[] = $row["ywsj_state"];
  • $data[] = $nestedData;
  • }
  • $json_data = array(
  • "draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
  • "recordsTotal" => intval( $totalData ), // total number of records
  • "recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
  • "data" => $data // total data array
  • );
  • echo json_encode($json_data); // send data as json format
  • - ?>
  • 复制代码