datatables + how to combine server side processing code with File export code -

-

this datatables example of adding buttons export data csv, pdf, excel.... fiddle here

https://datatables.net/extensions/buttons/examples/initialisation/export.html

$(document).ready(function() {     $('#example').datatable( {         dom: 'bfrtip',         buttons: [             'copy', 'csv', 'excel', 'pdf', 'print'         ]     } ); } );

this datatables example of server-side processing

https://datatables.net/examples/server_side/simple.html

$(document).ready(function() {     $('#example').datatable( {         "processing": true,         "serverside": true,         "ajax": "scripts/server_processing.php"     } ); } );

now how combine above code one, have data tables server side processing , attempt, not sure wrong, or if indeed close. 

$(document).ready(function() {     $('#example').datatable( {         "processing": true,         "serverside": true,         "ajax": "scripts/server_processing.php",         "dom": 'bfrtip',         buttons: [             'copy', 'csv', 'excel', 'pdf', 'print'         ]            } ); } );

i have tried various permutations still getting error in console uncaught syntaxerror: unexpected string can advise?

this real example working 

    $(document).ready(function() {         var datatable = $('#employee-grid').datatable( {             "processing": true,             "serverside": true,             "ajax":{                 url :"employee-grid-data2.php", // json datasource                 type: "post",  // method  , default                 error: function(){  // error handling                     $(".employee-grid-error").html("");                     $("#employee-grid").append('<tbody class="employee-grid-error"><tr><th colspan="3">no data found in server -- startagain1-index2.php </th></tr></tbody>');                     $("#employee-grid_processing").css("display","none");                  }             },             "dom:" 'bfrtip',             "buttons": [                 'copy', 'csv', 'excel', 'pdf', 'print'             ]         } );     } );

you have sintax error, change code in line:

incorrect:

"dom:" 'bfrtip',

correct:

"dom" : 'bfrtip',

result: jsfiddle


Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more