Page 1 of 1

Bibliography application

Posted: Tue Aug 17, 2004 11:17 am
by juls
I have searched but I cannot find a good example of a MYSQL bibliography application. I would like to learn from an existing application.

Can anyone point me in the right direction?

Posted: Tue Aug 17, 2004 1:02 pm
by Draco_03
There's others mysql exemple that may not be about bibliography but are very similar (once you know how to make one database you can more easily do a second one)

Do you want to code it yourself ?
Or just tweak one that already exist?
Is it to learn, for fun or for work ?

EDIT : if it's to learn i suggest you start making something yourself like creating a connection to database, creatinbg tables adding data retreiving data etc. Very simple but will help you a lot when dealing with bigger databases

Posted: Tue Aug 17, 2004 1:15 pm
by juls
Thanks Draco,

I'm mainly doing this for fun, but I will hopefully use it! I'm busy working on this at the moment, but I'm running into complications and I wanted to see how other solved similar problems.

For instance, if a book has multiple authors, how do I create a php/html form to deal with these? I currently have one form that collects author last_name and first_name and stores these in tbl_authors. Title, ISBN, etc are stored in tbl_books. So, if there are 2 authors, can I dynamically create another set of first_name, last_name text boxes (on the original form) to accept the second author? And if so, how do I ensure they have the same id as the first autor.

These are the kind of things I'm puzzled about...

Posted: Tue Aug 17, 2004 1:42 pm
by Draco_03
Oh i see.. In your case you would need a linking table
In other word you'll need to create a table with 2 field
author id and book id

so the authorid could be assigned more then once to a bookid
here's a pic i made for a tutorial.. but it doesn't depict well enough