PHP Item Library User Guide
Introduction
PHP Item Library is an easy to use Library System for
storing Students, Items and Loans.
Features
- Entirely Web Based for access to the system with any device
with an internet connection and web browser
- Login system to secure the library
- Setup script that will get the database up and running in less
than 30 seconds
- Item, Student and Loan entry forms for making, editing and
deleting
- Student information such as a map of the students address and
the current students age
- Search system to find items students and loans
- Sorting system to easily display Items, Students and Loans in
an order such as name A-Z or grouping students tutors together
- Barcode generation and printing for quick and easy access to
items and students when making a loan
- Overdue system to display student(s) that should have handed
back an item with any fines and the total amount of days that the item is
overdue
- Overdue Email System to email out a reminder that the students
has overdue items; listing what the item(s) are and went the due in date
was
- Mass Email System to send out news about the library e.g.
special events or return your items before the college/school holidays
- System to delete students that have left the college/school
- Admin Accounts so that more than one username and password can
be used to login to the system. For multiple user accounts
- Database stats including item count, total item costs, total
students, number of items currently being borrowed, loans made in total,
current overdue items and total admin accounts
Installation
Minimum Web Server Specification
- A web
server running Apache 1.3.24 or equivalent/higher
- PHP:
Hypertext Pre-processor 4.06 Apache module compiled and integrated into
Apache
- GL
Imaging (that comes preinstalled with PHP) for barcode generation
- MySQL
3.23.49 server with connection to PHP
PHP Item Library Setup
- Extract
the PHP Item Library zip file with all folders intact
- Upload
or copy the files on to the web server (shown below)
- Make
sure that the folder that the folder e.g. library is CHMOD to 777
- CHMOD
the library.config.inc.php file to 777
- Go to http://www.your-web-site.com/library
(replacing www.your-web-site.com
with the correct domain)
- Follow
the setup instructions and click Ok
- Go to http://www.your-web-site.com/library
(replacing www.your-web-site.com
with the correct domain) and enter the username and password you gave in
the setup file
How to upload the Library
Using
a FTP (File Transfer Protocol) Program such as SmartFTP (http://www.smartftp.com) connect to your
web site
Once connected drag and
drop the library folder on to the main file window in the folder formation that
they are in
And
when it has finished copying files on to the server go to step 3 on the setup
guide, if you are unsure how to CHMOD a file/folder please look in the FTP
programs help files.
Library System Usage
Login Screen
Click Login > once you have finished
|
|
Username and Password Entry
|
|








Home Screen
Items – this lists all the items
|
|
Database stats including item count, total item
costs, total students, number of items currently being borrowed, loans made
in total, current overdue items and total admin accounts
|
|
Send an email to all the students in the database
|
|
Admin Accounts – modify admin’s accounts
|
|
Loans – this lists all the current loans
|
|
Overdue - this lists all the overdue loans
|
|
Your full name and your username and the date
|
|





Logout – Logs you out of the system
|
|
Students – this lists all the students
|
|





Mass Mail Screen
Subject of the email and the message
|
|
Once Ok has been pressed, the system will email this
message to every student on the system, as this can take some time with a
large databases it will display the progress
|
|




Item Screen
Items is highlighted to show you what page you are
on
|
|
Which member of staff last edited it and when
|
|
Search form and search for in Name, Barcode etc
|
|
Items name, condition, price, status and last
borrowed by
|
|
Sort form to show the data in a specific way
|
|
Click the arrow to loan this item, if it is a cross
then it is already out
|
|
Pops up a new window with a barcode and the item
name etc and asks if you want to print it
|
|















Shows form to make a new item
|
|


Edit Item Screen
This form is self-explanatory but there are a few
things to be aware of such as input masks like price must be a number and
the status can only be 1 of the 2 options. Description and Notes fields
have no limit in size so you can keep on typing in there
|
|






Students Screen
Click the arrow make a loan with this student
(Note: an item must have already been selected for a loan)
|
|
Pops up a new window with a barcode and the student
name, DOB, Tutor etc and asks if you want to print it
|
|
Search form and search for in Name, Barcode etc
|
|
Sort form to show the data in a specific way
|
|
Automatically finds students that have left he
college/school and deletes them (as set by the Last Year field)
|
|

Shows form to make a new student
|
|
Students name, email, course, tutor
|
|


Which member of staff last edited it and when
|
|












Add Student Screen
Back to the Students Screen
|
|
Post code is entered in two stages
|
|
Last Year is used to delete out of date students that
have left the college/school
|
|
This form is self-explanatory but there are a few
things to be aware of such as input masks like DD MM YYYY this is referring
to day month and year and then length of the input e.g. YYYY is a 4 digit
number
|
|
The only difference between the edit and new form
is that the edit form is filled in with the students info and in edit mode
it gives a link to a map of the students address and works out how old the
student is
|
|







Loans Screen
Loan Number, Student and Items (items will change
in to numbers if they have more than 3 items), In and out date and it
current state
|
|
This can show you all the items that are out or in
or both at the moment it displaying Out Items only
|
|
Make a new loan (only use this if you have a
barcode scanner)
|
|
View details of the loan and change the status of
the loan
|
|






Add Loan Screen
Scan in student barcode here or go to the students
tab and click the loan button next to the student
|
|
Displaying what items you have already added (by
scanning in a barcode or clicking on it in the Items listing)
|
|
Set the due in date here and add any notes in the
box below
|
|
Allows you to scan in an item barcode
|
|







Overdue Items Screen
Automatically sends out an email to all the
students that have overdue items (with the item they have and when it was
supposed to be back)
|
|
Extra information like days overdue and a fine (if
one has been setup)
|
|

This is the same sort for display as the loans
screen, but with the difference that it is only displaying overdue items
|
|


Admin Accounts Screen
This displays all the people that have access to
the library system
|
|
For security reasons the first account cannot be
deleted or edited by someone else other than the owner
|
|


Edit or Delete admin account
|
|


Possible Messages and Error Messages
|
Message
|
Description
|
|

|
This message will only be displayed if you have got your
username or password wrong on the login screen, make sure that you have
entered your username and password correctly or contact the library
administrator
|
|

|
This is tell you that you have missed a field that is needed
e.g. user name on the logon screen or the Students name in add student
|
|

|
This is telling you that your mass email or mass overdue
email reminder has been sent. It also gives you the number of students it has
been sent to and if you look behind the message all the students email
address are displayed
|
|

|
This is checking that you have entered a number for
numerical fields such as the price of an item or the telephone number of a
student
|
|

|
This is telling that the item or student has been saved
|
|

|
This is a question dialog asking if you want to delete the
item, student or admin in hand
|
Step by step guide of Library System
Let’s say for example you want to add a new item to the
system and then loan it out to a student here are the step you would take:
Access the Library
- Go to
the Library system in a web browser
- Login
with your user name and password
Add the Item
- Click
on Items in the menu
- Click
Add Item
- Type
in the name of the item like: Sony Camera and add a description and any
other details
- Click
Ok
- Press
Ok to the “Item Saved” message or press Ok to “Please fill out the
required fields” and fill in anything you have missed out and press Ok
again
- Now
click the blue arrow next to the new item to add the item to the loans
basket
Select Student
- Click
Students from the menu
- Lets
say we want to loan this new item (Sony Camera) to a student called “Kevin
Murray” you can either click Loans in the menu and click new loan and then
scan Kevin Murray’s barcode or just click the blue arrow next to his name
on the Students screen
Make Loan
- Now
that you are in the on the new loans screen (Items from the menu and Make
new loan) enter a date you want the item back into the library by and
click Ok
- Now
the item can be given to the student and just tell them the due in date
- The
library will tell you if they go overdue and can send the student an email
as well