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?
Bibliography application
Moderator: General Moderators
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
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
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...
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...
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
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