Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [gotze] JSON: Edit Log

Here is the list of edits for this post
Re: [gotze] JSON
   

Dear Andy

actually it can do a bit more than sorting in client side.
it will also reduce the server load and save a lot of bandwidth

some grid has zebra stripe, totalality counting , single or mutiple line select
,Pagination ,sorting, fixed table head, cell data modification....


here is the perl sample code from the offcical site.
http://www.datatables.net/...rver-side/perl_mysql


it's output looks like this

blah blah

Code:

my %sOutput = (
sEcho => int($q->param('sEcho')),
iTotalRecords => int($iTotal),
iTotalDisplayRecords => int($iFilteredTotal),
aaData => \@aaData,
);
return $self->to_json(\%sOutput);
} # /table_data



so basiclly i need to have sEcho iTotalRecords iTotalDisplayRecords aaData ready.

so i mimic its jason pattern to use following simple scripts to produce a jason response from perl.

Code:

#!c:/perl/bin/perl.exe
## modules json test,
use CGI;
use strict;
use warnings;

# read the CGI params
my $cgi = CGI->new;
my $sEcho = $cgi->param("sEcho");
my $username = "myname";
# create a JSON string according to the database result

$sEcho = int( $sEcho );
my $json =qq{{ "sEcho": $sEcho, "iTotalRecords": 5, "iTotalDisplayRecords": 5, "aaData": [ ["Trident","Internet Explorer 4.0","Win 95+","4","X"],["Trident","Internet Explorer 5.0","Win 95+","5","C"],["Trident","Internet Explorer 5.5","Win 95+","5.5","A"],["Trident","Internet Explorer 6","Win 98+","6","A"],["Trident","Internet Explorer 7","Win XP SP2+","7","A"]] }};
#"sEcho": 0,
#my $json = qq{{"error" : "username or password is wrong"}};
# print $cgi->header(-type => "application/json", -charset => "utf-8");
print $cgi->header( 'application/json' );
print $json;



but it seems something wrong. i can get table rendered. but it seems something wrong with it. i cant get do sorting or any other embeded datatables function.


Maybe i missed some facts , the author says
Quote:
The Perl script requires an extra parameter to be sent to it (rm), for which we can use fnServerData:
....blah
"sAjaxSource": "/cgi-bin/test/datatables/run.cgi",
"fnServerData": function ( sSource, aoData, fnCallback ) {
/* Add some extra data to the sender */
....blah




i am losted. because i do not understand its real meaning.


That is all i have . but it is just a unsucessful testing .

Last edited by:

courierb: Nov 20, 2011, 5:55 PM

Edit Log: