0 members and 123 guests
No Members online
Most users ever online was 695, 02-16-2011 at 08:01 AM.
» Site Navigation
» Domains For Sale
Help getting started.
I have never made a database before and am hoping I can do the following:
I want to create a form that will be filled out by my students. It is important that each student will only submit data once. I want to know if I can create a database that contains their student ID numbers and once the form is submitted it registers with the id so that information cannot be submitted twice.
Can anyone point me to some resources that would help me get started?
If I wasn't clear enough, I will outline exactly what I plan to have the students do:
A student will go to a webpage. On that webpage they will vote for senior superlatives (class clown, etc.) that will go into our year book. They will also enter a short biography that will also go into the yearbook.
I want the database to check to make sure this is only done once so that students cannot vote multiple times and/or submit more than one bio.
Now that I think about it, it would be best if the database would also keep track of the tally.
It will depend
First of all I am not a database programmer, although I have made several databases. A majority of getting this started will be finding out what the host will support, ie access, MySQL ect. I am guessing you want this to be done off the school website. So you will need to find out from them what database programs you can use and tie into the shcool host server. All the things you want to do can be done and pretty simply. But what program to use and what the school server allows and needs will be the toughest part. I would talk to the school network Admin if you have one and want to use the school server. If you are wanting to do this personally on a site not hosted by the school, you will need to do the same thing also. usually all servers have MySQL and access extensions which will allow you to create the database in either one of those programs and tie it in pretty easily. But I think that should be your first step, to find out what you can and cant do with the server you are trying to use. Hope this helps, and reply with any new information you have.
I once had a dog named Fred,
He layed on my bed,
Scratching his head.
Now that Fred is dead,
And all is said,
I just realized I should have kept him fed.
It turns out a friend of mine has some experience with this and is helping me find my way. To give you a bit more background, I will be using MySQL, and I do have access to the school server.
The DB has been created and currently I am working on a form to populate (is that the right term?) it.
A good resource that my friend suggested is http://www.tizag.com in case anyone else is interested in this sort of thing.
I will post again as I make more progress. Thanks for the reply.
Well The page is up and running. IT still needs few tweaks here and there, but all things considered, it turned out well. It turns out creating a database is very simple. Writing the code to interact with it, now that's a little more complicated.
By anguslad in forum Miscellaneous
Last Post: 07-19-2007, 03:37 PM
Last Post: 03-10-2007, 08:48 AM
By MRRM in forum HTML / XHTML / XML
Last Post: 04-02-2003, 02:56 PM
By Jessica in forum Miscellaneous
Last Post: 03-06-2003, 02:40 PM
By RICH2001 in forum HTML / XHTML / XML
Last Post: 07-08-2001, 08:04 AM