How to map upload.php and my table information

[eluser]obiron2[/eluser]
I am having similar issues with creating forms and posting data back to the database.
I don't want the form field names to be the same as the database field names for security purposes.
The data types from the form may not match the datatypes in the database (e.g. checkbox is stored as tinyint - mySQL doesn't do booleans..)
I am in the process of designing a form model that holds all the data for building the form (input type, class, default values etc) where to get seed data from, the validation rules to be applied and where to post the data back to after validation has passed and how to transform it if it is not in the right data type.

It is sort of a combination of advanced forms object, data mapping and active record. I should have it all figured out after Xmas and will post it for critique then.

Obiron