Databases
StackOverflow2013
Postsdbo
POjQuery dataTables with Codeigniter - serverside data
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjQuery dataTables with Codeigniter - serverside data
    text
    copied!<p>I am using datatables with Codeigniter library (<a href="https://datatables.net/reference/option/columns.searchable" rel="nofollow">https://github[dot]com/IgnitedDatatables</a>) and I have several problems.</p> <p>Problem @firebug:</p> <blockquote> <p>"NetworkError: 500 Internal Server Error - <a href="http://www[dot]rodocomp[dot]si/shopmanager/server/datatables?callback=jQuery152008148431712533122_1302880482637">http://www[dot]rodocomp[dot]si/shopmanager/server/datatables?callback=jQuery152008148431712533122_1302880482637</a>"</p> </blockquote> <p>I assume that error is because of <code>?callback=jQuery152008148431712533122_1302880482637</code>, right?</p> <p>Another error @firebug:</p> <blockquote> <p>POST <a href="http://www[dot]rodocomp[dot]si/shopmanager/server/datata...llback=jQuery152008148431712533122_1302880482637">http://www[dot]rodocomp[dot]si/shopmanager/server/datata...llback=jQuery152008148431712533122_1302880482637</a> POST <a href="http://www.rodocomp.si/shopmanager/server/datatables?callback=jQuery152008148431712533122_1302880482637" rel="nofollow">http://www.rodocomp.si/shopmanager/server/datatables?callback=jQuery152008148431712533122_1302880482637</a> 500 Internal Server Error 252ms</p> </blockquote> <p>Answer:</p> <blockquote> <p>An Error Was Encountered Unable to load the requested file: ajax.php</p> </blockquote> <p>What is ajax.php file ??</p> <p>This is my JavaScript code:</p> <pre><code>$('#example').dataTable({ 'bProcessing' : true, 'bServerSide' : true, 'sAjaxSource' : '&lt;?php echo base_url(); ?&gt;server/datatables', 'sPaginationType': 'full_numbers', 'bAutoWidth' : false, 'aoColumns' : [ { 'sName': 'edit', 'bSortable': false }, { 'sName': 'delete', 'bSortable': false }, { 'sName': 'products.products_id', 'bVisible': false }, { 'sName': 'products.products_price' } ], 'fnServerData' : function(sSource, aoData, fnCallback) { $.ajax({ 'dataType': 'json', 'type' : 'POST', 'url' : sSource, 'data' : aoData, 'success' : fnCallback }); }, }); </code></pre> <p>What am I doing wrong?</p> <p>Regards, Mario</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload