Search
43745 results 7241-7250
Forum
- 25th May 2015How can I left align just the label of search in the data table jqyery??Search label is after the input why?? and how can I put it before
- 23rd May 2015Tip for Adding FusionCharts "Table to Chart" in our DataTables / EditorPlease 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/1.10.7/css/jquery.dataTables.css"> --> <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 verticallywe 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 applyHi 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 tableRecord 1235 ... clothes | diapers | formula | baby toys | cribs | car seats | ....... Record 421 ...chicken | beef | chili | baby back ribs | bbq | barbeque If "baby" is the filtered search term, I'd want to see it appear in context and highlighted in e.g. < 40 chars responsive display Is this possible using column().search() method? Is there an example of this documented anywhere?
- 20th Apr 2015cant get the table tools buttons diaplayed..please helpdom: '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 DatatableAm 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 tableI 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
- 10th Apr 2015DataTables warning: table id=table_id - Requested unknown parameter '0' for row 0. For more informatHi everyone. Liked the idea of such plugin, but i can not implement it. I receive JSON data from servlet and it reads number of rows and number of rows that should be displayed but after that shows such error as noted in the title. Link to jsfiddle with data https://jsfiddle.net/reghor/4r5350ge/1/. Sorry but idk how to connect json data to datatable on jsfiddle, i wrote in raw format( how i receive it from servlet).