Introduction to the catalogue

This catalogue of books is sample application written using PHP and a MySQL database.

Data stored in the catalogue

Books

Each Book has a reference number, and no two books have the same reference number.

For each book the catalogue records the following information:

Publishers

Each publisher has a name, and no two publishers have the same name.

Authors

An author has a name. So far no two authors have the same name.

The persons listed as authors might have other roles, and these are reported in the listings. The other roles include:

Subjects

To be supplied.

Operations on the database

List the publishers

This operation produces a list of the names of the publishers in alphabetical order. By clicking on the name of a publisher you can get a list of books published by that publishers. The list contains the following information about each book:

List the authors

This operation produces a list of names of authors in alphabetical order. By clicking on the name of an author you can get a list of books with which that person is associated. The list contains the following information about each book:

List the subjects

This operation produces a list of subjects in alphabetical order. By clicking on a subject you can get a list of books about that subject. The list contains the following information about each book:

To be continued.


Last updated on 1 April 2008.