Help with some questions
Moderator: General Moderators
Help with some questions
Hi guys. well i am pretty sure some PHP gurus can advise me good on my project. here is what i am going to do for my final project. i came with a good background of OOP like Java and c++ but more into core java and webdesigning, flash and 2 months ago started learning SQL(pretty fun ). Here are the details of my final project.
***************************************************************************
I need to create an ONline testing Website where user can take Test online
*****************************************************************************
• Testers – persons who take tests
Want to take tests fairly and conveniently
Want to visit a test Web site for test information and review
Want to self-evaluate test results (e.g. test scores, correct answers vs.
tester answers)
Want to use tests as a learning tool
• Teachers – persons who give tests and evaluate test results
Want to manage tester information
Want to prepare tests easily
Want to view and search the problem database
Want to modify existing problems for a test
• Problem creators – persons who enter problems into the problem database
Want to create and enter problems into the database easily
Want to view and search the problem database
Want to validate the answers store in the problem database
Want to create new categories of problems
Now my problem is i dont know anything about PHP so i bought a book and started learning PHP. At the beginning it was fun as long i was using functions and constructor since i have a background of programming but as soon as we try to use PHP and Sql together to output the queries from the database it gets more and more complicated. i have 3 months left and i go to school with my other classes so i think it will not be a good idea of just reading book rite now since time is not very efficient for me rite now + PHP scripting with the database is really hard mysql_fetch_array and all those other libraries i will get bunch of syntax errors for sure. so all i wanted to know from you guys was:
1) How many PHP scripts do i need to use to create my ONLine testing website?
2) what do you think i need need in my database?
3) i know in MSaccess there is a form option where i can create forms so if i was using MSaccess i could have entered my problems in the form database but how can i enter the problems in mySql database?
4) what kind of PHP scripts do you think i need for this website?
5) how can i keep track of the scores? do i need a login script so people can register online and will have their own Unique username and password to log in to take the test?
You guys dont know how much i will appreciate if anyone can take his time out and can give me my answers in details.
Thanks Alot !.
***************************************************************************
I need to create an ONline testing Website where user can take Test online
*****************************************************************************
• Testers – persons who take tests
Want to take tests fairly and conveniently
Want to visit a test Web site for test information and review
Want to self-evaluate test results (e.g. test scores, correct answers vs.
tester answers)
Want to use tests as a learning tool
• Teachers – persons who give tests and evaluate test results
Want to manage tester information
Want to prepare tests easily
Want to view and search the problem database
Want to modify existing problems for a test
• Problem creators – persons who enter problems into the problem database
Want to create and enter problems into the database easily
Want to view and search the problem database
Want to validate the answers store in the problem database
Want to create new categories of problems
Now my problem is i dont know anything about PHP so i bought a book and started learning PHP. At the beginning it was fun as long i was using functions and constructor since i have a background of programming but as soon as we try to use PHP and Sql together to output the queries from the database it gets more and more complicated. i have 3 months left and i go to school with my other classes so i think it will not be a good idea of just reading book rite now since time is not very efficient for me rite now + PHP scripting with the database is really hard mysql_fetch_array and all those other libraries i will get bunch of syntax errors for sure. so all i wanted to know from you guys was:
1) How many PHP scripts do i need to use to create my ONLine testing website?
2) what do you think i need need in my database?
3) i know in MSaccess there is a form option where i can create forms so if i was using MSaccess i could have entered my problems in the form database but how can i enter the problems in mySql database?
4) what kind of PHP scripts do you think i need for this website?
5) how can i keep track of the scores? do i need a login script so people can register online and will have their own Unique username and password to log in to take the test?
You guys dont know how much i will appreciate if anyone can take his time out and can give me my answers in details.
Thanks Alot !.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Well just so you know, C++ and Java Platform are great to have when it comes to understanding syntax. I don't want to confuse you, so I'll try to give you general ideas and you can skip to those chapters in your book
Okay, testers will need either sessions/cookies or database entries (or a combination of sessions and database entries, in my opinion) to keep track of their answers. Just be sure the tables keep track of their user ids so only they can view their scores.
Teachers will need to have access to the database tables of the questions created by the problem creators, I assume, as well as access to the tables of the tester results, which is mostly good SQL planning (and you said you're familiar with SQL).
The problem creators will just need to be handled through forms and database tables.
Obviously, it'll take a bit more planning, but these are basically the techniques you'll need to utilize.
Okay, testers will need either sessions/cookies or database entries (or a combination of sessions and database entries, in my opinion) to keep track of their answers. Just be sure the tables keep track of their user ids so only they can view their scores.
Teachers will need to have access to the database tables of the questions created by the problem creators, I assume, as well as access to the tables of the tester results, which is mostly good SQL planning (and you said you're familiar with SQL).
The problem creators will just need to be handled through forms and database tables.
Obviously, it'll take a bit more planning, but these are basically the techniques you'll need to utilize.
I am assuming that i need to have a table for Testers which will have a user_id and i can have some kind of query to join the user_id with their test scores. Thankyou. i might have some questions about this when i try to create the database but for the time being it is a good information which i will keep in mind.Okay, testers will need either sessions/cookies or database entries (or a combination of sessions and database entries, in my opinion) to keep track of their answers. Just be sure the tables keep track of their user ids so only they can view their scores.
this is where all my question will arise. how can a teacher can go to my database directly through html to change the questions in the database? second question how can i differentiate betwen a teacher and a student? what i am trying to say is (what if a teacher dont have a user id so she/he needs to do the same thing request for a login id and password but how can i check to see if a teacher is really a teacher not a student ?)Teachers will need to have access to the database tables of the questions created by the problem creators, I assume, as well as access to the tables of the tester results, which is mostly good SQL planning (and you said you're familiar with SQL).
Thanks[/quote]
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
oh yes that was really very sweet. i used frontpage and i was trying to accomplish the same thing but i dont have skills for java scripting so i created layers and bunch of layers and all i can come up with was just a message like for eg i have bunch of pictures on a page with no description and if a person points his mouse to any picture( a message will appear not a pop up message just a regular text message rite below the picture describing the person in the picture). i was trying to do the same thing what you did on the website but no skills in java scripting. it looks so Sweet and nice.superdezign wrote:Thanks.Dropdowns have become particularly easy for me to program after doing it so much, but my website doesn't really have much place to have them.
Did you mouseover anything in the services section the right?That's my pride right there. A full week of javascripting, learning the ins and outs.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
well i will be definitely in touch with you. if i want your help i will email you on the website email address and will ask you how much you are going to charge Student discount ? lol. Take care.superdezign wrote:Well, it's good to know at least one server-side language and one client-side to be able to offer a good amount of interactivity. It's easy to learn one once you've learned others (except VBScript... it's too... "spoken language" for me)
i just registered my domain compzia.org. and would like to create a website which includes flash and other stuff.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm