StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to pass data manually to datatables
primarykey
Id
10009976
data
AcceptedAnswerId
10010016
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-04-04T11:14:28.733
FavoriteCount
0
LastActivityDate
2012-04-04T11:17:38.047
LastEditDate
LastEditorUserId
0
OwnerUserId
877942
ParentId
0
PostTypeId
1
Score
0
ViewCount
2792
LastEditorDisplayName
text
Body
<p>I am trying datatables. I successfully tried on ajax call. But now I am looking for loading my data grid, using datatables of course, on page load.</p> <p>I need to pass arguments to my processing page via querystring. Page does the operation and then a template file shows the datagrid. This all was being done in smarty using manual foreach and other loops. Now I want to convert it all to datatables. </p> <p>But how that initial data is going be passed to datatables? Therefore I need to pass initial data to datatables, but how? I referred to datatables api and other references but did not any such thing. Please help</p> <p>I wish to do something like this</p> <pre><code><?php //get params from $_GET $dbRet = someDbOps($someGetParams); //db processing include_once('grid.tpl'); ?> </code></pre> <p>on grid.tpl</p> <pre><code><html> <head> <script src="jq.js"></script> <script src="datatables.js"></script> </head> <body> <script> var data = '<?php echo $dbRet?>'; //now i got data here $('#one-column-emphasis').dataTable({ "bProcessing" : true, "bServerSide" : true, "sAjaxSource" : "changeLog.php", "bPaginate" : true, "aoColumns" : [ "Topic", "Details", "Date" ], "aaSorting" : [[1,"desc"]] }); // how to pass $dbRet to this handler???? </script> <table id="one-column-emphasis"> <tr> <td></td> <td></td> <td></td> </tr> </table> </body> </html> </code></pre>
Tags
<php><jquery><datatables>
Title
How to pass data manually to datatables
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USShades88
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COAre you using smarty functions to access the database (as someDbOps($someGetParams); sugests, or php functions, IE, mysql_query();
  singulars
  PostPostId
  POHow to pass data manually to datatables
  UserUserId
  USBradmage
2. COthat is just a sample code snippet kind of thing I wrote there. That is a php function.
  singulars
  PostPostId
  POHow to pass data manually to datatables
  UserUserId
  USShades88

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.