For someone with strong PHP/MySQL skills, this should be a very easy project. I need a form that will submit data ( to a MySQL database, email the form contents to a specified email address, and create a new folder in an uploads folder based upon a unique ID given to the submission. Once the data has been entered successfully into the database, the user should be directed to a file upload page that holds the unique ID generated by form submission and allows users to upload files (only accept .doc and .pdf) to the created folder. The page will also need to contain a link that will allow the user to return to the page at a later time to upload more files.
## Deliverables
The workflow is as follows for this project:
User clicks link to form
PHP form with the folllowing fields loads (MySQL export)
CREATE TABLE `summerfest_reg` (
`first` varchar(50) NOT NULL default '',
`last` varchar(50) NOT NULL default '',
`address` varchar(80) NOT NULL default '',
`city` varchar(30) NOT NULL default '',
`state` varchar(5) NOT NULL default '',
`zip` varchar(12) NOT NULL default '',
`highschool` varchar(50) NOT NULL default '',
`part` varchar(15) NOT NULL default '',
`teacher` varchar(75) NOT NULL default '',
`year` varchar(15) NOT NULL default '',
`phone` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`paid` tinyint(1) NOT NULL default '0',
`rec` tinyint(1) NOT NULL default '0',
`app_id` smallint(4) NOT NULL auto_increment,
PRIMARY KEY (`app_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
User clicks submit
Form data is emailed to address I will give you
Form data is entered into database
New folder is created in folder "uploads" named with "last_app_id" from the database submission
User is directed to a success page that allows them to upload ONLY .doc and .pdf files to the created folder - page contains a link for them to return
I don't care about layout - I'll handle that myself - just need the functionality built.
Source code must be commented!!!
Acceptance of all deliverables will be based on UAT that includes exactly the steps listed above.