make column data as hyperlink (dataTable JQUERY)

Use columns.render API method to dynamically produce content for a cell. $(‘#example’).dataTable({ “data”: responseObj, “columns”: [ { “data”: “information” }, { “data”: “weblink”, “render”: function(data, type, row, meta){ if(type === ‘display’){ data=”<a href=”” + data + ‘”>’ + data + ‘</a>’; } return data; } } ] }); See this example for code and demonstration.

Datatable styling so bootstrap button appears on same row as other elements

SOLUTION #1 This is the most confusing part with using Bootstrap style for jQuery DataTables and it’s undocumented so far. Bootstrap extension overrides default dom which can be confirmed by viewing its source code. You have to use specially crafted dom option similar to shown below: dom: “<‘row'<‘col-sm-3’l><‘col-sm-6 text-center’B><‘col-sm-3’f>>” + “<‘row'<‘col-sm-12’tr>>” + “<‘row'<‘col-sm-5’i><‘col-sm-7’p>>”, You can … Read more

Disable initial automatic ajax call – DataTable server side paging

You could use the deferLoading parameter and set it to 0. This will delay the loading of data until a filter, sorting action or draw/reload Ajax happens programmatically. function initTestTable(){ myTable = $(‘#testTable’).dataTable({ “processing”: true, “serverSide”: true, “deferLoading”: 0, // here “ajax”: { “url”: “testTableData.html”, “type”: “GET”, }, “columns”: [ { “data”: “code” }, { … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)