This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.
The Web-based library management system has many features. It can simplify loan procedures, standardize library management process, easily manage personnel management and Borrowers can check the book and know the characteristics of borrowing books. This article discuss the use of Linux + Apache + PHP + MySQL build Web-based library management system, analysis and design this system function. This article also introduction the functions of each module; describes the system encountered major problems and solutions, and provide some solutions of system problem.
Library is an important part of many schools. It can support teacher and student to get knowledge and research information. As a result of it need deal with a large number of books, so it uses the computer management books. This will not only convenient for borrowers, but also for librarians facilitated. With the development of network technology, the overall level of computer applications to enhance, I think that this system allows readers to check book information, loan operations, and better management of other information. This can use the advantage of internet to help admin to service for borrower. The Linux+Apache+PHP+MySQL are not only popular, useful, but also it is safe and efficient.
"PHP is currently very popular and useful Web server scripting language, MySQL is one of the very popular online databases, we can combine them to build powerful Web site." PHP can also be used in HTML statement, using data in the database to create web pages.PHP language and MySQL database can create almost all Web applications, and there are easily used by developer.
Because economic and scientific progress made the rapid development of computer technology, information systems play an important role in people's lives. The other hand, People's quality of life and working environment are increasingly high requirements. Books have become increasingly important in society, and a large number of books in people's lives.
At the same time, in order to manage a large number of books, books are also a lot of their warehouse; the warehouse management becomes an important problem.
According to this problem,
The library management system has requirement from two sides. One is borrower, the other is administrator. The requirement of borrower is research the book information in library, the personal loan situation and Personal information change. And the administrator need manage borrower and book information. It also requires maintenance of the system information and status. The borrower can directly view the library book information, and if the borrower use the library card ID and password, the borrowers can also check the situation and maintain personal information. If some people want to check his personal information, they need his password. Those protect the borrower privacy. The administrator feature has a lot of information, needs a high data security and confidentiality. It can browse, search, add, delete, and modify book information and borrower information. But it can't add, delete and modify lending Information.
According to this information, I think a simple library management system need this features:
The management of library resources that will make administrator to know about the book.
Readers can easily search the library books.
Record user registration information in the library.
Easy to add new books to the library and allow users to retrieve.
Development Platform Design: Linux+Apache+PHP+MySQL
"PHP language can work in UNIX, Linux, Win9x/2000/NT and other operating system" (BaoMing Xu). I chose the LINUX as the operating platform, and then use the Apache Web server WEB as the services, the background using the MYSQL database.
PHP Language Features
PHP is a server-side HTML scripting description language, which is similar to ASP. It is a programming language for the internet, which can use in different platform and web server. PHP uses the C, Java and Perl syntax, and add their own features, making it more rapid implementation of dynamic pages. It is a very popular server scripting language. PHP language features are very powerful. It has the following features:
Support many databases
According to the PHP language database function, we can easily access data from Oracle, Sybase, MS SQL, MySQL, Unixdbm, and any other can support ODBC-compliant database. That is will make database easily connect Website.
Besides, because PHP has rich function library, I have reason to believe that the future development PHP library will be getting better and better.
Support many Network Communication Protocol
It includes: IMAP protocol and POP3 protocol, SNMP protocol, NNTP protocol, NIS protocol, HTTP protocol, Apache server and the LDAP protocol.
The application development with PHP language does not require much modification can be used in other operating systems
Open and Expansibility
All PHP source code can be free to copy, compile, and print. Any user can write their own PHP program, that they do not pay any money for copyright. People can communicate with each other on the PHP program and code. This can quickly develop.
PHP as part of apache server that it runs the code without calling an external program and the server has no burden to explain the script language. Therefore, the program runs very fast and efficient.
String processing and document processing ability
PHP language provides a lot of functions for math, time, file system, and the string processing functions.
PHP language has best flexibility.
PHP Working Mechanism
Systems Analysis and Design
System File Design
Before I design this system, I create four files in the library file. That is "conn", "css", "data", "Images", and "JS". It can help me to design this website.
Conn¼šDatabases connect File.
Css: CSS File.
Data: Database File.
Images: Picture Source File.
Database Requirement Analysis
Database Logical Design
Main Page Describe
According to system login module, the manager can login to library management system main page. The main page includes three parts: Borrow Top 10 List, Navigation bar, And Copy right.
The Navigation bar will show the features for different user. The system manager can use all features. That is the main page:
The Main Page Analysis
This library system is a lager website. I must consider this website security. So this system has different permission. Just only manager can setting other user. The main page judges the user permission and then gives their module feature. This is the code for this module:
Manager Module Design
4.2.1 Manager Module Describe
This Module have six features, it include: manager login, check manager list, add manager information, manager permission setting, delete manager and Change manager password. Following this `:
4.2.2 Manger Module analysis
In this module, we need use table-() and table-() in database. The manger name and password will store in (Manager Table). The (purview) will store different manager permission information. They have relationship between their ID fields. Before I complete system login, I need add manager information in MySQL client. This is the sentence:
However, that is not enough to protect the system security. Some people can use the main page website address to enter it. I need check this user login or not. I use the session to achieve this feature. This is the code for check login feature:
The system will judge session have admin_name or not. If not exist, then it will turn back login page.
Now, let me introduction the system login processing.
This is the form element:
Manager login form
Values="Submit" onclick="return check(form1)"
Values="close" onclick="windows. close()";
I also use the Class to judge the user and password is correct or not. If the username and password are correct, then enter in main page. If that is wrong, then have information tell you.
4.2.3 Check Manager Module
When you enter the main page, you chose the system setting-> manager setting. This page will show you all manager information and permission. You can add or delete manager information and set up the manager permission.
At first, I use the "left joinâ€¦.on" sentence research table () and (), it will find the correct data, and then the result will return the browser.
4.2.4 Add Manager Module
The page can add new manager. But if you want to add permission to new manager, you need go to manager permission setting page.
This is the form element:
4.2.5 Design Manager Permission
This is the form element
4.2.6 Delete Manager
Book Management Module Design
4.3.1 Book Management Module Describe
Book Management Module include Book list, add book information, amend book information, delete book information, and check book detail information.
4.3.2 Book Management Module Analysis
In book file management module, it uses four tables: book information table, book case table, book type and publishing.
4.3.3 Check Book Information
After manager login system, and then enter the check book list page. It also provide add, delete, amend features.
4.3.4 Achieve Check Book information