Is it possible to restrict front end editing of mysql table to "update" only, without option for "insert" or "delete"?
I have removed the insert privilege on the table, which kind of works, but produces a red warning and is confusing for users.
The best solution would be to have a switch for insert, update and delete under editing settings in the table settings - and accordingly to those settings the options for front end user would be enabled or disabled.
The best solution for this case would be to use CSS to hide New and Delete button
To hide New or Delete button you can add this CSS on Custom CSS field on wpDataTables settings page (which will be applied to all of the table) or directly on the page between <style></style> tags:( in this case this will be applied just for the table that is on the page)
We have our FAQ page where you can find some useful informations, also searching tickets may help. We are working to improve our FAQ page and add some more examples so if you have any questions or ideas let me know.
Hi,
Is it possible to restrict front end editing of mysql table to "update" only, without option for "insert" or "delete"?
I have removed the insert privilege on the table, which kind of works, but produces a red warning and is confusing for users.
The best solution would be to have a switch for insert, update and delete under editing settings in the table settings - and accordingly to those settings the options for front end user would be enabled or disabled.
Thanks
HI Kris,
Thank you for your purchase.
The best solution for this case would be to use CSS to hide New and Delete button
To hide New or Delete button you can add this CSS on Custom CSS field on wpDataTables settings page (which will be applied to all of the table) or directly on the page between <style></style> tags:( in this case this will be applied just for the table that is on the page)
.DTTT_button_new { display: none !important;
}
.DTTT_button_delete { display: none !important;
}
Best regards.Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Perfect,
Thank you!
Is there a resource available to understand what other options we can change through custom css?
Thanks
HI Kris,
We have our FAQ page where you can find some useful informations, also searching tickets may help.
We are working to improve our FAQ page and add some more examples so if you have any questions or ideas let me know.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables