Need someone to design a simple web form and a MySQL database backend. The form is used to collect information on people with certain skills and understand certain technologies. Forms and tables should be able for me to easily adjust stylesheet.
Please let me know if you can do this job and how long it will take you. Please be sure to read all information and ask questions.
OPTIONAL: forms should use Ajax for submitting and loading data.
There are 4 main pages:
- Form for entering information. Form should allow user to upload a word document or pdf file, store the file in a folder (prepend the timestamp to the file name to ensure uniqueness), and save the file name in the table.
- View for listing summary of submitted information (first name, last name, email, city, current location)
Should be able to sort on any column. Need to filter on skills and technology fields
- Read only view of form (view details)
- Edit view of form
Database will probably have at least 3 tables and 1 view
- table1: profile
- table2: skills
- table3: tools
- view: list all profiles
TABLE1 fields / form fields
- First name (first_name, varchar 50)
- Last name (last_name, varchar 50)
- Address (address, varchar 100)
- City (city, varchar 50)
- State (state, varchar 20)
- Zip (zip, varchar 10)
- Mobile phone number (phone1, varchar 15)
- Additional phone number (phone2, varchar 15)
- Email address (email, varchar 50)
- Highest level of education completed (choose one: High school, 2-year college, 4-year college, grad school, post grad)
(education, varchar 20)
- Current location (choose one: LocationA, LocationB, LocationC, LocationD)
(current_location, varchar 20)
- Willing to relocate to: (choose one: LocationA, LocationB, LocationC)
(will_relocate_to, varchar 20)
- If you are not currently in state, have you previously resided in the state: YES or NO
(previous_resident, tinyint 1)
- Resume (resume, text) - Paste text version of resume
- Resume (resume_filename, varchar 100) - name of file uploaded … PDF, DOC, DOCX, or RTF
- Skills (join on table 2. form should present user with checkboxes to select one or more options)
- Technology (join on table 3. form should present user with checkboxes to select one or more options)
TABLE2 fields
Web development
Graphic design
User experience design / Information architecture
Usability testing
Network engineer (hardware implementation)
Network administrator (software administration)
Software development
Database administration
Helpdesk support
Systems administration
Technical project management
IT security
App development - iPhone
App development - Android
App development - Windows mobile
App development - Blackberry
Windows application development
Mac application development
Linux application development
Cloud computing
Software sales
Learning and Development
Testing
Quality Assurance
3D animation
TABLE3 fields:
Tools/technologies: (check one or more)
Photoshop
Illustrator
InDesign
Flash
Flex
Silverlight
Omnigraffle
Visio
PHP
Javascript
jQuery
DOJO
Ajax
HTML5
CSS
Java
J2EE
.Net
ColdFusion
Objective-C
C
C#
C++
Perl
MySQL
SQL Server
Oracle
Python
Visual Basic
Ruby On Rails
Wordpress
Joomla
Drupal
eCommerce
Hi!! I have worked on several projects like this and am working currently on changing an access database to a web based mysql version. This will be ok for me to work with.
Thanks and awaiting a reply.
I've been working as a web developer for more than 3years now ,and i've Proficiency in working with AJAX,
PHP,MySQL,Javascript,HTML,CSS,CSV,Json .Please check PM for more info.
How flexible are you the database design? There are a few things that could be done to make the overall structure a little cleaner and more easily modifiable than you have laid out.