Looking for a php middleware

Question

Is it possible that the data parameter submitted by the post is a piece of json? This json fully meets the requirements of mysql, that is, the node name, column name, and data type also completely match. Can I parse the json in a loop and write it to mysql in one go? In this way, development can save a lot of repetitive work and there is no need to write a lot of sql statements. Thank you very much for asking for such a php code