MySQL Updates and Inserts with PHP

A

admin

Administrator
Staff member
I'm working on a web-based invoicing system right now as a learning project for myself. When I make updates to the database (or inserts) for tables that have a lot of fields (customer address and contact info, for instance), I do a normal SQL INSERT or UPDATE query, where I specify each field to update and each corresponding value. However, it seems that there must be some programmatic way to make this easier to manage, since I'd have to redo the SQL statement any time I make a change to the database or the user's form.

Any ideas?
 
You must log in or register to reply here.
Back
Top