更改期间数据表冻结显示条目

Question

I have like below: After I have changed show entries to 25 in datatable, the datatable seems no response. Its just show processing inside datatable body.

This the server side script for show entries:

$sLimit = "";
        if ( isset( $_POST['iDisplayStart'] ) )
        {
                $sLimit = " LIMIT ".mysql_real_escape_string( $_POST['iDisplayStart'] ).", ".
                        mysql_real_escape_string( $_POST['iDisplayLength'] );
        }

why its happen? how to fix that? Exactly I have two datatables inside this page.I put them in different tabs.

Datatable script

html table

serverside script

---

The trouble come during show range column but if not use this column all can work properly.the query like:

$sQuery = "SELECT DATE(A.Inspection_datetime) AS Date, A.Line, A.Model, 
                                  A.Lot_no,A.Range_sampling,COUNT(A.Serial_number) AS Error,B.name AS PIC
                           FROM inspection_report A
                           LEFT JOIN Employee B
                           ON A.NIK=B.NIK
                           WHERE CHAR_LENGTH( A.Range_sampling ) < 17
                           AND MONTH(A.Inspection_datetime)=MONTH(CURRENT_DATE)" .$sWhere.$sGroupBy.$sOrder.$sLimit;

Whether CHAR_LENGTH is the root cause? exactly this problem only occurs on the database a server for a local computer everything goes well.why?

Answer 1

I had the same issue. In the fnServerData handler, you can read aoData[0].value to get the 'sEcho' value. This values needs to be assigned to the sEcho property of the json object you pass to your datatable.

The expected type for sEcho is also a string and you are converting to an integer.

$sOutput .= '"sEcho": '.intval($_POST['sEcho']).','; 

try just

$sOutput .= '"sEcho": "'. $_POST['sEcho'] .'" ,';