Question, what is a good way to handle large CRUD web pages?
My current process is this:
- I make/edit the SQL table with IDs
- I get another set of IDs in the HTML form, which is sent to a PHP page
- In the PHP page, I put all the SQL IDs in a mysqli prepare statement
- Then, I put all the HTML IDs in the bind_params
This process works. However, I have nearly a dozen pages like this, each with ~8 variables. Repeating these keys 4 times is getting ridiculous, because that's 12 * 8 * 4 = 384 chances for me to flub the spelling/ordering, for the "create" part alone.
Not only is this a pain to implement, I need to do a massive amount of testing to make sure I haven't crossed any wires, to say nothing about business logic.
Thoughts? We're in a big refactoring process, so solutions out of a LAMP stack are perfectly welcome. I'm comfortable in PHP and (non-tomcat) Java, but willing to learn anything.