Connecting Tech Pros Worldwide Help | Site Map

create a database record that categorizes audio files in html

Newbie
 
Join Date: Sep 2008
Posts: 2
#1: Sep 11 '08
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's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,642
#2: Sep 11 '08

re: create a database record that categorizes audio files in html


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
Newbie
 
Join Date: Sep 2008
Posts: 2
#3: Sep 12 '08

re: create a database record that categorizes audio files in html


Quote:

Originally Posted by 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

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's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,642
#4: Sep 13 '08

re: create a database record that categorizes audio files in html


Quote:

Originally Posted by reformedman

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
Reply