1

After downloading and installing the Datatables , I downloaded the file that can be used to connect into a postgresql database and properly changed the following lines:

$aColumns = array( "ab", "cd");

/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "id";

/* DB table to use */
$sTable = "bacon";

/* Database connection information */
$gaSql['user']       = "user";
$gaSql['password']   = "pass";
$gaSql['db']         = "db";
$gaSql['server']     = "host";

After configuring the db link i noticed the json the following values:

{
  "sEcho": 0,
  "iTotalRecords": 2,
  "iTotalDisplayRecords": 2,
  "aaData": [
      ["bacon", "salad"],
      ["1", "2"]
  ]
}

Which I believe its OK ( since it returns data )

But when I open the main page ( code can be opened here ) the result is No matching records found

I tried to find some guidance on the solution applied here but it didn't gave me success.

What could I be missing?

Thanks in advance.

Improve this question
2
  • Note that you have and extra ' in your code near $aColumns = . Commented Jan 4, 2013 at 20:47
  • @ArnoldDaniels bad paste , thanks for pointing that, but still not the issue =( Commented Jan 6, 2013 at 22:24
Related questions
0
JSON format error even though echo matches with DataTables
0
Datatables - Json output - PostgreSQL - Returns null
15
DataTables with JSON, AJAX and PHP not displaying any data
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.