Error
Undefined index: HTTP_ACCEPT_LANGUAGE
Library Master

Library Master



Library master is the major master table which displays all the information regarding the book which you can see in the grid. And its interlinked with transaction i any one makes any changes then it reflects to the library master.

This is the master details and this is called as a menu from the menu sheet only it will redirect to the respected pages.

Library Master List:

Library Master is a major one which displays the id , title , author, subject, language,category etc.it gives the total information about the book weather it is availabe or not what kind of book it is and it is available or not.

when we click on the first menu called libmaster it will take to the following page which displays all the records. It gives the complete information like how many books are available and how many or on rent.

Add New Library Record:

Its a libmaster which has a details form with all the necessary requirements where the user has to fill the form to get register himself/herself.

It has a forms fields like id , title of the book, which subject, who is the author, what is the language ,by whom it is published, publication date ,to which category it belongs to , type of book , number of pages.

If we click on add new it will redirect to the form where we can give the required information and register himself/herself.

ID :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

ISBN :

Field Type : VARCHAR

SQL Type : Text

Field size in DataBase : 20

EAN :

Field Type : VARCHAR

SQL Type : Text

Field size in DataBase : 20

Title :

Field Type : VARCHAR

SQL Type : Text

Field size in DataBase : 50

Author Id :

Field Type : VARCHAR

SQL Type : Select

Field size in DataBase : 20

Subject :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

Language :

Field Type : INT

SQL Type : Select

Field size in DataBase : 11

Publisher ID:

Field Type : VARCHAR

SQL Type : Select

Field size in DataBase : 20

Category :

Field Type : VARCHAR

SQL Type : Select

Field size in DataBase : 20

Type :

Field Type : VARCHAR

SQL Type : Select

Field size in DataBase : 10

Pages :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

Size Code :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

On Hand :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

On Loan :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

Reserved :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

Available :

Field Type : INT

SQL Type : Text

Field size in DataBase : 11

  • playstore