create a database record that categorizes audio files in html

[reformedman]

I'm sure someone has written this idea in php, and I wouldn't mind looking at it as a helper but I really would like to know how to code this idea in HTML.

In my school we have lecture hours for different subjects.
Each subject would have their respective class name,
lecture speaker,
Title of the lecture,
audio file of the 50 minute lecture in mp3,
date the lecture was given,
and the reference chapter or page numbers for that day's lecture class.

I would like to build this form for my buddies and me while we go through our 4 years for record keeping of all our classes.

Could someone please show me what the very basic core example of one class would look like in html so that I could continue it?

In the future, I'd add an admin panel form, to just fill in the blanks as the classes progress, but for now I am very very interested in getting this started.

Could someone please help, I would emphatically and greatly appreciate it!

[removed email as per site rules]

[Dormilich]

you can't create a database entry only with html. html is a markup language and as such not intended and suited for programming (which you need for database operations)

nevertheless you can make programming the 'helper' easier with a good html form that provides the input.

regards

note: a class in html is an attribute and is used for styling

[reformedman]

you can't create a database entry only with html. html is a markup language and as such not intended and suited for programming (which you need for database operations)

nevertheless you can make programming the 'helper' easier with a good html form that provides the input.

regards

note: a class in html is an attribute and is used for styling

Thanks for the quick reply.
First note: the class that I was referring to was the class in my school, the class name or course name.

Secondly, can you point me in the direction I should go to get started in this project in PHP? If it can't be done fully and wholly in html, then I will do it in php. Is there a book or website, or better yet, an already prepared script in which I could change a few things and add more to?
I'd like just the very basic crude beginnings of it so I could then fill it with whatever else is needed.

Thanks

[Dormilich]

Secondly, can you point me in the direction I should go to get started in this project in PHP? If it can't be done fully and wholly in html, then I will do it in php. Is there a book or website, or better yet, an already prepared script in which I could change a few things and add more to?
I'd like just the very basic crude beginnings of it so I could then fill it with whatever else is needed.

hm, a good start on php-mysql interactions is MySQL @ php.net especially the countless comments are worth reading. Then there are articles about MySQL in our "Howtos" section and an article about Data Abstraction Layer (using a separate class for database interactions)
something about object oriented programming is here though that's not the first thing I would start with. another source is www.w3schools.com and for reference (JS / HTML) developer.mozilla.org

and last but not least, ask any questions you have in the Bytes forums

regards