nclocl Posted July 21, 2011 Share Posted July 21, 2011 Hi everyone, Not sure if this is the right kind of place to ask this but here goes. I am looking to create a website that lets users log in, make a simple quiz and then lets other users log in and take them. I'm thinking HTML, PHP and mySQL would work but I have no idea where to start. I can use HTML to make websites and have experience with PLSQL and oracle databases but I need to do this with php. Does anyone have any idea if this can be quickly thrown together and what kind of data I would need to store? That is probably pretty vague as it is pretty vague in my head but I will answer any questions. Thanks in advance for the help! Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/ Share on other sites More sharing options...
nclocl Posted July 25, 2011 Author Share Posted July 25, 2011 Any ideas at all? Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1246677 Share on other sites More sharing options...
SpaceLama Posted July 25, 2011 Share Posted July 25, 2011 You could google your idea to see if there are any scripts avaidable. And what about your ideas? Dont expect to get complete answers on forums. You need to do the thinking for yourself when you run into a problem with coding then you can ask them. What kind of quiz? Trivia? questions? puzzles? There are tons of different ways to make a quiz... Just questions and yes or no? Or a.b.c.d.? What is your plan idea of this? And what do you have already on this? What do you have so far for coding? You could start with a login page?? Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1246678 Share on other sites More sharing options...
teynon Posted July 25, 2011 Share Posted July 25, 2011 If you don't know how to do that then you aren't ready to make it. You need to do other tutorials with relevant information to build up your skills. Look up tutorials in the following: PHP Basic Tutorials - If you know nothing about PHP, start from the beginning. Hello World, etc. - File management PHP & MySQL tutorials - Basic tutorials like creating a database, inserting information, selecting information, mysql transactions Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1246692 Share on other sites More sharing options...
nclocl Posted July 27, 2011 Author Share Posted July 27, 2011 here's the deal, I am a programmer but I only have experience of Java, Oracle, Ajax, PL/SQL, HTML, Javascript, XML. I need to create this application online and only have mysql at my disposal. I have created a log in page and the site itself, I just need people to be able to create a quiz when they log in. For example: a user logs in, clicks 'create quiz' then can keep pressing 'add question' and each one comes up as a multiple choice template. I can program a page with a quiz on, I'm just wondering how to go about saving the data and re-loading an old quiz. I'm pretty sure I can jump in to php(I have used it a little, like I said I got a quiz working, it's just the saving and loading of different quizzes I'm having trouble with) Hope that clears it up a bit and hasn't confused things further. Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247890 Share on other sites More sharing options...
Muddy_Funster Posted July 27, 2011 Share Posted July 27, 2011 You know, comparing your initial post to your last one: I got to ask, are you the same person? one hand doesn't know what kind of data you would need to store, and the other claims to be an oracle programer. one hand doesn't have any idea where to start, while the other is programing in javascript, HTML and Ajax... Yeah, sorry, you did confuse things further. Why not work with asking specific questions and take it from there. Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247900 Share on other sites More sharing options...
nclocl Posted July 27, 2011 Author Share Posted July 27, 2011 It was literally just an idea in the first post, I just wanted to know how to go about it. Ok I will try and be a bit more specific: With my limited knowledge of php I can create and process a quiz (displayed in html and validated with javascript). What would be the best way to have the site save quizzes and reload them? I don't need to know exactly how to do it, just a sentence about the theory of how to achieve this and then I can figure out the coding myself. Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247920 Share on other sites More sharing options...
Muddy_Funster Posted July 27, 2011 Share Posted July 27, 2011 Gotcha. And what do you see the future of these quizes being after they have been stored? If it's interactivity on the site that you want then store them in a database, otherwise you can get away with flat file storage if it's for something like "download this quiz and print it off". Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247930 Share on other sites More sharing options...
nclocl Posted July 27, 2011 Author Share Posted July 27, 2011 I want people to be able to go on and take them yeah. So would you recommend a row in a table for each quiz, then select the row and read data from it? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247943 Share on other sites More sharing options...
Muddy_Funster Posted July 27, 2011 Share Posted July 27, 2011 I would probably use a new table for each quiz, with a master index table. each quiz table having question, answer1, answer2, answer3, answer4, corect_answer where correct answer is 1,2,3,4 to refference which of the offered answers is the right one. I havn't thought it through though, you really will need to take some time over your design phase and decide how it's best to refference the data over all. Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247954 Share on other sites More sharing options...
teynon Posted July 27, 2011 Share Posted July 27, 2011 I don't know about a different table for each quiz. I don't like my web mysql user account to have table creation privileges. Here's generally how I might go about the tables: TABLE: QUIZES ID TITLE DESCRIPTION CATEGORY TABLE: QUESTIONS ID QID (Quiz ID) QUESTION TABLE: ANSWERS QID (QUESTION ID, NOT QUIZ ID) ANSWER CORRECT (0 meaning incorrect answer, 1 being correct answer) Then make a user answer table like so: TABLE: RESPONSES ID UID (USER ID) QID (QUESTION ID) AID (ANSWER ID) TABLE: RESULTS ID UID (USER ID) QID (QUIZ ID) PERCENTAGE Quote Link to comment https://forums.phpfreaks.com/topic/242548-php-quiz-maker/#findComment-1247962 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.