Search

Please go to the link and fuse it (the idea) with your dataTables' http://www.fusioncharts.com/dev/usage-guide/using-with-javascript-libraries/jquery/rendering-charts-from-html-tables.html

9th May 2015Table is blank, what am I doing wrong?

I am new to datatables and I am having trouble getting a simple webpage with a grid to work. Below is the webpage code: <!DOCTYPE html> <html> <head> <title></title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0">  <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/plug-ins/1.10.7/integration/jqueryui/dataTables.jqueryui.css"> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/plug-ins/1.10.7/integration/jqueryui/dataTables.jqueryui.js"> <script type="text/javascript" charset="utf-8" src="./jquery.js"></script> <script type="text/javascript" charset="utf-8" src="./jquery.dataTables.js"></script> </head> <body> <script type="text/javascript"> $(document).ready(function() { $('#example').dataTable( { "processing": true, "serverSide": true, "ajax": "incidents.php" } ); } ); </script> <table id="example" class="display" cellspacing="0" width="100%"> <thead> <tr> <th>ID</th> <th>Incident Number</th> <th>Incident Date</th> <th>incident time</th> <th>Location Type</th> <th>Random Number</th> </tr> </thead> <tbody> <tr></tr> </tbody> </table> </body> </html> This is the code in incidents.php: <?php $db = mysql_connect("127.0.0.1", "root", "") or die("Could not connect to server"); mysql_select_db('ajax', $db); $sql = "SELECT pid AS id, incident_number, incident_date, incident_time, location_type, random_number FROM incidents"; $data = mysql_query($sql, $db); if($data == true) { // echo 'query worked'; // echo '</bf>'; $d = mysql_fetch_assoc($data); } else { die("Querying Failed"); exit(); } echo json_encode($d); This is the output of incidents.php if you just run incident.php: {"id":"1","incident_number":"1005","incident_date":"0000-00-00","incident_time":"08:20:00","location_type":"here","random_number":"123"}``` I realize that I need to right code to load all of the rows of data in $data to $d but for now this should work ... I must be missing something. Thanks, TD

8th May 2015get table headers vertically

we can see headers list as horizontally like Fist_name Last_name Position office start_date Salary how ever what can be done if we want to display headers vertically like "First_name" "Last_name" "Position" "Office" "Start_Date" "Salary"

24th Apr 2015Table Tools settings won't apply

Hi guys, I'm trying to add some settings to my datatables/tabletools init but for some reason no matter what settings I change for tabletools the default options still show. When I click the buttons they function so I know it's finding my SWF. I am using the latest version of tabletools and datatables. I've tried both the old hungarian notation: "oTableTools": { "aButtons": [ {"sExtends": "copy", "sButtonText": "Copy to Clipboard", "mColumns": [1,2,3,4,5]}, {"sExtends": "print"}, {"sExtends": "csv", "columns": [1,2,3,4,5]}, {"sExtends": "pdf", "columns": [1,2,3,4,5]}, {"sExtends": "xls", "columns": [1,2,3,4,5]} ] } as well as "tableTools": { "buttons": [ {"extends": "copy", "buttonText": "Copy to Clipboard", "columns": [1,2,3,4,5]}, {"extends": "print"}, {"extends": "csv", "columns": [1,2,3,4,5]}, {"extends": "pdf", "columns": [1,2,3,4,5]}, {"extends": "xls", "columns": [1,2,3,4,5]} ] } Am I doing something wrong? Thanks

22nd Apr 2015Partial text display from a wide column of keywords on a server_side table

20th Apr 2015cant get the table tools buttons diaplayed..please help

dom: 'T<"clear">lfrtip', "tableTools": { "aButtons": ["copy", "csv", "xls", "pdf", {"type": "print", "buttonText": "Print me!"}], "sSwfPath": "http://ilex-dev1.contingent.local/swf/copy_csv_xls_pdf.swf" // "sSwfPath": "http://ilex-dev1.contingent.local/swf/ZeroClipboard.swf" },

20th Apr 2015Cant change width of table using React Datatable

Am using react-data-components component and not able to change width of the Datatable , width attribute doesn't work

17th Apr 2015How to Sort elements of different type in single column in jquery data table

I have a scenario to sort a column having multiple type of elements, drop-down list and string(HTML) type. I want to sort that particular column containing drop-down list and HTML type of data. This is what I Have tried using "orderDataType": "dom-select" and "sType": 'html' $.fn.dataTable.ext.order['dom-select'] = function (settings, col) { return this.api().column(col, { order: 'index' }).nodes().map(function (td, i) { return $('select', td).val(); }); } But only the string is sorting. The drop down list is not sorting. Please give me suggestions

Search

44090 results 7261-7270

Forum