Web-Based Library Management System with PHP and MySQL
TURKU UNIVERSITY OF APPLIED SCIENCES
Bachelor’s Thesis
March 2011
Jin Jiawei
ABSTRACT
Web-Based Library Management System with PHP and MySQL
The objective of this Bachelor’s thesis was to develop a web-based library management system based on PHP and MySQL in order to reduce the cost of management and make it convenient for the user. The web-based library management system includes the most popular components a common library management system has, administration, book seeker, leasing and E-mail. Besides, it has more humanistic functions such as second-hand online book shop and top 10 ranking. The website was tested on some of the most popular browsers.
The basic functions of Internet Information Services 7.5 and detail features of PHP and MySQL were selected for the purpose of this project. The structure of Library Management System which included a website interacting with a database was determined. The system and development tools were chosen based on their specific features that benefit the system. Furthermore, all necessary components in the library management system were integrated and tested.
The first result of this study was an understanding of the advantages of PHP and how MySQL benefited a large project. The second result was building practical PHP and MySQL projects based on a web server on Windows 7 ultimate.
The understanding of the development tools directly affected the quality of the website. The website which was built in this project offered a high performance, secure, stable and an easy-to-maintain environment. In addition, the website improved the management of a university library. The site was built for testing purposes only.