- cnly19872016-08-11论坛元老76630
一切都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
- - ?>
- 复制代码