Setting Data to read from DOM
Setting Data to read from DOM
razzbossontheshow
Posts: 6Questions: 0Answers: 0
I have been trying to set my DataTable() to read data from the table DOM. The Data on the Table DOM was processed using the ssp.class SSP::Simple().
Now, i am trying to set the Data on the DataTable so that it can be passed to the Editor, and also to be deleted. Please, can anyone help me with this?
(Here is my code)
$('#table_id').DataTable( {
"processing": true,
"serverSide": true,
"ajax": {"url": "inc.config.php", "type":"GET"}, // SSP::Simple() processed Data to the Table DOM.
"aoColumns": [
{ "mData": "id" },
{ "mData": "catchers" },
{ "mData": "catch_code" },
{ "mData": "user_type" },
{ "mData": "logs" }
]
});
Replies
Not sure I follow what you are saying. But the code snippet looks like it should work. You are using legacy naming convention for
aoColumnsandmData. They are nowcolumnsanddata. See thecolumnsandcolumns.datadocs. However the legacy options are still supported.Here is an example showing server side processing with Editor.
Please provide more specifics about the issues you are having and any errors you are getting.
Kevin
@kthorngren I am getting this error.
DataTables warning: table id=table_id - Requested unknown parameter 'id' for row 0, column 0. For more information about this error, please see http://datatables.net/tn/4
When i used column and data, i get a blue loader WITHOUT the Data on the Table showing. When i use type POST, i only get the blue loader without the page showing but no error thrown.
When i use the type:"GET", then i get the error which i showed to you above.
I have an SSP.CLASS file which was included into my inc.config.php (here, my datatbase connection resides. My Data on the table was automatically loaded using the code below.
And, it was working fine. I wanted to add the columns data to this DataTabke initialization so that it can enable me to delete from the table using DataTable Editor.
I already have Editor, but i am having a difficul time initializing the columns. I always get that error about unknown parameter. I have searched , and the response aren't helping.
@kthorngren And also, the link you shared about the examples on server processing. I went there, copied it, edited to look exactly as it should, but i didn't get any warnings, no blue loader, just NOTHING. No Data. It silently failed.
If your setup works
columns.datadefined then you have array structured data. I'm not familiar with PHP but you will need to change your server script to object structured data. See the ajax docss for more details.Kevin
If you have Editor, forget the SSP class. The Editor PHP libraries fully support server-side processing.
Allan
@allan , I implemented the Editor PHP Library to fetch Data from my Datatbase but i get an invalid json response. I tried to include the application/json as a contentType request, but i get a silent failure. The whole thing is becoming exhausting to me. Spent more than a week now on DatatTables. Damn!
Did you follow the troubleshooting steps at the link in the Invalid JSON response error?
https://datatables.net/manual/tech-notes/1
What did you find in the response?
Kevin
@kthorngren Honestly, i don't want to go anymore further on Editor. I just want to be able to delete a row. That is all. I need you to help me with that.
Here is my code
The "id" seems to be undefined here. Please, can you check my code and make adjustment where necessary? . Thank you
Seems like you are trying to create your own custom editing code with the
DeleteBtn()function. The Editor has all that built-in. Take a look at the example I posted and try deleting a row. The Editor handles this for you. Are you trying to use the Editor library or create your own?This example shows how to use edit and delete buttons in each row. In this case you would create some event handlers but the example shows how.
Kevin
If you don't want to use Editor, and you do what you delete a row in a DataTable, use the
row().remove()method. Obviously you'd need to do the Ajax call and have a server-side script that does the actual delete in the dataase.Allan
@allan , I have tried to use this since yesterday, but it doesn't even remove it from the DOM. And also, if for instance, it removes it, how do i get the "id" which will be used for the deletion?
The Ajax url on my DataTables was used to load the data into the Table. Can i still use this same path for deletion of data? I feel it wouldn't work that way. But i don't know how to make this work.
I just need to get the ID which will be used to process deletion. Please, can you write a sample code for me based on my DataTable outline as i sent to you. This is really a bottleneck for me.
Do your rows (
tr) have an id? If so thentable.row('#myId').remove().draw()is all that is needed to remove it on the client-side. That doesn't do anything with the server though.If your Ajax script can do a delete sure. I don't know if it can. That's how Editor's works - it sends an
actionproperty tell the server side script what it is going to do.Editor is our supported editing solution for DataTables.
Allan