php - How to Insert/Update/Delete in one Ajax POST

one text

Solution:

Just spitballing, here: I think this is a solid case for an architecture which makes use to two way bindings (Angular springs to mind) to keep the DB in sync with the UI.

However, if you're determined to run this via AJAX calls, you could fairly easily wrap all the CRUD requests into a single data object, and then parse it (after retrieving it from $_POST) from there, being sure to escape your values and insert them into parameterized queries to ameliorate SQL injection based attack vectors.

A data structure like

{data=
    {
        create={
            /*some data in whatever format*/
        },
        update={
            /*some data in whatever format*/
        },
        delete={
            /*some data in whatever format*/
        }
    }
}

would be an option, for example.