Jump to content

Needing some PHP & MySQL guidance.


SlyOne

Recommended Posts

Hi,

 

New to these forums, so apologise in advance if this has been posted somewhere else...i doubt it though.

 

Anyway, moving on. I am currently in my last year of university and have a computing project to do. I've chosen to do a website that will be host a prospective student application that will help them or guide them to their choice of subject and university.

 

I will be doing this by asking questions and then providing check boxes for the user to answer by. There will be a yes, no and maybe option for each question. Once the user had lets say answered 10 out of the 10 questions on the first page, they will be taken to another page with another set of questions that are more specific to their interests and then to another. After lets say 3 stages of these questions, the prospective student will be given a tabulated selection of courses that match their interests and personality.

 

I thought of doing this via booleans. So if the user answered one question and it was true, then the "id" of that question would be matched to another "id" of the next set of questions. So if the user answered 5 true out of the 10 questions. Then the next set of questions that match those questions will be shown on the next page. Until it comes down to the last set that are matched to the specific course subjects. Sounds right in my head...so sorry if this is confusing.

 

Anyway...after all that waffle, I am needing a bit of guidance how to do this. Any sites you can suggest or tutorials that will help me to build such an application?

 

For an example of what i want to do kind of do, the stamford test on the UCAS site is very similar. Will see if i can post a screenshot of it.

 

Any tips and help will be most welcome, have about 2 months to do this.

 

cheers

Link to comment
https://forums.phpfreaks.com/topic/143955-needing-some-php-mysql-guidance/
Share on other sites

Sounds like a fun project.

 

To start off, any user going to your site looking to get college guidance are not going to want to fill out 3 long pages of questions, you have to keep that in mind, you don't have much time to capture their attention and interest.

 

Do you have any experience with AJAX?  You could use this so as the user is answering each individual question, a new question appears based on their answer from the database.  So in other words one question would appear and then another based off their answer.

 

I am quite familiar with the whole college placement seen as how that's about 40% of what I do at my job here, I code forms that give users guides to which college would suit them best based off their answers.

Thanks for the reply grim.

Good point about the 3 long pages of questions... although I think I was planning on keeping the questions short and sweet and only like 10 questions per page or less for the 2nd and 3rd sections.

Liking the idea of a question appearing after answering a question before, sadly however I have little or no experience in AJAX :(

 

Was hoping I could do this via php and mysql and then embedding this application onto a site that I will design (and need to do so soon).

here is an image of what it might be like.

Answer one question as a yes or "true" in boolean terms and with grim's idea, another question will appear underneath it which they have to answer. If they say no or "false" to a question, then no related question will appear and the user moves on to the next. Once they have completed the form, they click submit and somehow, i needed it to decide which subjects suit that particular user and print them out in a tabulated form or something.

 

Anyway, any help or guidance or pointing me in the right direction would be brilliant, thanks

 

hope this screenie is visible here...

 

 

imagine_questionnaire_layout_01copy.jpg

SImple and friendly enough, are you needing help on how to pass variables from one page to another?  Validate entries?  Or what??  If so I would start off googling what the very first thing is you want, start typing out code and then when you run into issues or problems, post them to this thread and we can help, that's what I do when i get a project I am not sure how to do.

I'll be honest, i'm not sure even where to start. I've put this part off for a week now and concentrated on designing my site and other simple dynamics but i've now returned to the real problem and seems i am stuck in some quicksand.

I know my question and what i want to do is very broad, but can someone shove me somewhere so at least i'm going in the right direction instead of going around in circles.

 

cheers

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.