I sell several different digital items on my website.
The current way we have set up is each product has it's own database table.
Everytime we add new product (even though it is same concept) we add a new table to our database.
I would like to change that so one database table for all of our products.
All products are same information in each table.
What I was thinking of was to have one table in the database to tell the different type of product to the other table. This table would need to have a web interface to allow new products to be added to it.
Next I would need a file uploader / database entry system built. Based on which product I tell it I am uploading it will take the file, read it and enter the information from the text file and input into the database. Currently I am doing this by hand and only changing the dates
Then? I need to encrypt the two database tables some how.
Finally if I refund a payment I need a button to reset the product. So it can be sold again if the product has not been released to the former buyer. I would also need a button that allows me to view the product sold and a delete button for that product. if for some reason someone views their product and is not happy with it or requests a refund I need to view it so I can reset it then I need to delete it from the database.
Currently I am going into the database by hand, doing a search and resetting it and or deleting it.
There are a few other little things I would like to add into another project later on.? For now this is the meat of the project that I need done right away.
## Deliverables
This project is not for the beginner or the programmer with only a year in the business. I want a true programmer with real experience. Please make sure you have two to three years of mySQL and PHP programming.