NOTE – Datatable serverside processing with MySql database

NOTE – Datatable serverside processing with MySql database

I have a table which gets data from backend and is populated in frontend using a loop and then make a datatable for it , but i have issue that in datatable search box the row can be searched with id too which is for development purpose only and we want it should not be used to search , i made a column for id at index 0 and give its visible to false. I paste this code in datatable code

I’m using the DataTables SSP class. According to my research on the internet, it should be sufficient to add SSP::simple to the end in order to write a where condition. However, I’ve tried it and it still fetches all the data, the condition doesn’t seem to work.
My code is below:

I want to add (data-row-num=”1″,data-row-num=”2″,data-row-num=”3″) for my HTML table row.
Can someone please help me to do it like ?

I have this html table: