[RESOLVED] Need Advice. Adding fields dynamically

[DBHostS]

Hello everyone.

I have been coding a project with my business partner and we are coding a resume builder website. Here is the basic concept of the site: Users sign up for the site. they then are able to create a resume. there will be 6 steps in creating the whole resume. There will be two membership options. Subscribed and Lifetime. - the subbed users will only get one resume for a certain price and be able to download their resume for 90days. lifetime users get to make unlimited resumes and get unlimited downloads.
Steps
Resume Start - User creates a name for the resume. (an id is automatically created)
Contact Info - Users contact info.
Profile Info
Work Experience
Education
Custom Fields.
Confirm resume - Make any changes here before paying.
Payment - Pay using pay pal.

These three bold steps the user will have an option to 'add and delete' fields to the builder.

Let me explain, in the profile step. the user will be able to add 'key strengths' in the work experience section the user will be able to add a whole new form for 'Job2' or 'Job3'. and same thing for school. If the user has more than one school there will be an option to add a new school or to delete a school. Same goes for the custom section. the user may add and delete fields (header title, and values for that certain header).

Now i know i have to use a loop to do what i want to do. But is it possible to do this with just straight PHP code? or should i use javascript with PHP?

and how will this work with the database? do i make a new database table for each school, work, and key strength ?

Any advice is greatly appreciated. Thank You in advance

here is my current database for the builder only.
wizard
resumeid
resumename
resumetemplate
users_memberid
username
userlevel
wizard_profile
profile_resumeid
profileText
keyStrength1
keyStrength2
keyStrength3
keyStrength4
wizard_contact
contact_resumeid
fname
lname
street
email
city
state
zip
phone
wizard_exp
exp_resumeid
employer1
title1
startdate1
enddate1
city1
state1
skills1
wizard_edu
edu_resumeid
school1
startdate1
enddate1
degree
major
minor
city
state
wizard_custom
custom_resumeid
header1
value1
header2
value2
header3
value3
header4
value4

[leatherback]

Hi,

Both are possible. I would make it in PhP first, and add the javascript layer later. That way you facilitate also for the 3% of the users' with js switched of.

In the table I would have the education table, with school, and a separate table linking the schools to the user, with possibly columns for start and end dates. You can then indefinitely add schools & attendance, and you'll only need one record for each school, independent of the number of users that you have that attended that school (Look in google for database normalisation and many-to-many relations)

[DBHostS]

leatherback wrote:

Hi,

Both are possible. I would make it in PhP first, and add the javascript layer later. That way you facilitate also for the 3% of the users' with js switched of.

In the table I would have the education table, with school, and a separate table linking the schools to the user, with possibly columns for start and end dates. You can then indefinitely add schools & attendance, and you'll only need one record for each school, independent of the number of users that you have that attended that school (Look in google for database normalisation and many-to-many relations)

Thanks for the reply.

so when a user adds an place of employment or a school that they attended will i have the php script make that new tables in mysql? Or should i already have the tables created?

Education:
wizard_edu1, wizard_edu2, wizard_wdu3 ...

Employment:
wizard_exp1, wizard_exp2, wizard_exp3...

[leatherback]

You'd have ONE table for a place of employment or school. You would ADD a RECORD to the existing tables, if the place of employent / school does not exist