adam291086 Posted December 19, 2007 Share Posted December 19, 2007 I am look at my final year project for university. I am wanting to create a website with database interaction. I am wanting to make a system that will sort out swimming lessons. This involves storing the number of lesson for each level. Storing the maximum number of pupils per lesson. Storing which lesson are on which day. And storing the swimmers information. Once all this information is submitted i want the system to automatically assign pupils into a new lesson depending on what level they are at and their prefered day. If that particular lesson is full then move to second choice. If there is no second choice and the lesson is full then they go in that lessons reserve list. Then the system will print out the registers. Is this possible. Any thoughts are appreciated. Quote Link to comment Share on other sites More sharing options...
redarrow Posted December 19, 2007 Share Posted December 19, 2007 your need to use a database and your need php, This sounds like a exam to me..... Quote Link to comment Share on other sites More sharing options...
adam291086 Posted December 19, 2007 Author Share Posted December 19, 2007 It's not an exam. I am currently on a placement year working. I am looking into a final project now. I was woundering if what i purposed was doable in php and mysql. If so then great because i can already code at an alright level Would you say i should have tempory tables to store all the lesson info but have a permenant simmers info table. This is because the lesson info will change every couple of months? Quote Link to comment Share on other sites More sharing options...
chigley Posted December 19, 2007 Share Posted December 19, 2007 Of course it's doable! Just do some thinking on pen/paper before you start coding. Quote Link to comment Share on other sites More sharing options...
adam291086 Posted December 19, 2007 Author Share Posted December 19, 2007 Yeah i know its going to get complex i think. Just wanted to make sure before i start the adventure. Quote Link to comment Share on other sites More sharing options...
redarrow Posted December 19, 2007 Share Posted December 19, 2007 well your need to provide the date/time and day for the swimming event or the teacher will have to cheek every day and he be well upset..... this is very basic and you say you no php and mysql should be very easy... Quote Link to comment Share on other sites More sharing options...
adam291086 Posted December 19, 2007 Author Share Posted December 19, 2007 ok, you say its basic. Any ideas how i could make it more advanced to show off a little. I need something that makes people go WOW and therefore employers will employ me. Quote Link to comment Share on other sites More sharing options...
redarrow Posted December 19, 2007 Share Posted December 19, 2007 Firstly your idear is grate and i am sure your inpress your new boss, just do what you have posted and then work on it......... if you dont fell that you no mysql database or php to do the project then i sugest study my son....... dont forget you also need to use css and also use seo(web friendly pages) good luck mate no need for us to exsplode your brain..... Quote Link to comment Share on other sites More sharing options...
revraz Posted December 19, 2007 Share Posted December 19, 2007 I think it's a good idea and sounds close to what my current project is doing with my Online booking system. It also accounts for number of slots available and taken and well as displaying these items on a calendar. Sounds like fun. Quote Link to comment Share on other sites More sharing options...
adam291086 Posted December 19, 2007 Author Share Posted December 19, 2007 yeah just wanting to make sure i can do it in php and that it's enough for a uni project. I plan to make it now before i start my final year. Quote Link to comment 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.