PHP+MYsql图书管理系统

摘要

虽然目前很多大型的图书馆已经有一整套比较完善的管理系统，但是在一些中小型的图书馆中，大部分工作仍需由手工完成，工作起来效率比较低，管理员不能及时了解图书馆内各类图书的借阅情况，读者需要的图书难以在短时间内找到，不便于动态及时地调整图书结构为了更好地适应当前读者的借阅需求，解决手工管理中存在的许多弊端，越来越多的中小型图书馆正在逐步向计算机信息化管理转变。

本系统设计实现了基于web的图书管理系统,该系统采用现今比较流行的PHP语言,结合MYsql数据库,实现了图书信息的存储查询等功能。系统不仅维护方便,节省了图书馆的资源,方便图书馆进行管理图书,本系统主要为图书管理者而设计,为学校和学生提供提供科学化图书管理数据的平台。

系统主要功能包括:用户的管理，图书的增删，图书的检索等。 关键词: 数据库；PHP；MySQL；数据库技术；图书管理

1

Abstract

Although many large library has a set of perfect management system, but in some small and medium-sized libraries, most of the work remains to be done by hand, work efficiency is relatively low, the administrator can't understand all kinds of books to borrow library books, readers need to found in a short period of time, not easy dynamic and timely adjust the structure of books in order to better adapt to the readers of the loan demand, solve the manual management exists many disadvantages, more and more small and medium-sized libraries are gradually to the computer information management.

It’s main functions include: the administration of users , by which administrators can add, delete or revise the information through different settings ; the function of borrowing books , by which administrators can choose to borrow books or not according to the retrieval ; checking information , by which administrators can check the history of borrowing and returning books and records of those books which are overdue ; checking the detailed information of books , by which users can find the details and whether it's available or not in library .

The system features include: user management, additions and deletions of books, book search

Key words：Database；PHP；MySQL；Database Technology；Library Management

2

目录

1 绪论............................................................................................................................................... 5

1.1 研究背景 .............................................................................................. 5

1.2 研究现状 .............................................................................................. 5 1.3 研究意义 .............................................................................................. 6

2相关技术综述 ................................................................................................................................ 7

2.1 PHP技术 .............................................................................................. 7 2.2 MYSQL数据库 .................................................................................... 8 2.3 Apache ................................................................................................... 9 2.4 WampServer .......................................................................................... 9 2.5 数据库简介 ........................................................................................ 10 2.6 网页制作工具 .................................................................................... 11 2.7 B/S模式 .............................................................................................. 11

3 需求分析 ..................................................................................................................................... 15

3.1 系统需求 ............................................................................................ 15 3.2 需求分析 ............................................................................................ 15

3.2.1 功能分析 ................................................................................. 15 3.2.2 功能描述 ................................................................................. 15 3.2.3可行性分析 .............................................................................. 16

4 总体设计 ..................................................................................................................................... 17

4.1 系统流程图 ........................................................................................ 17

4.2 数据库设计 ........................................................................................ 17

4.2.1 数据库概念设计 ..................................................................... 17 4.2.2 创建数据库及数据表 ............................................................. 19

5 设计思想与实现 ......................................................................................................................... 30

5.1 首页设计 ............................................................................................ 30

5.1.1首页概述 .................................................................................. 30 5.1.2 首页实现过程 ......................................................................... 32 5.2 管理模块设计 .................................................................................... 33

5.2.1 管理员模块概述 ..................................................................... 33 5.2.2 管理员模块技术分析 ............................................................. 33 5.2.3系统登录的实现过程 .............................................................. 34

3

5.2.4查看管理员的实现过程 .......................................................... 37 5.2.5 添加管理员的实现过程 ......................................................... 39 5.2.6设置管理员权限的实现过程 .................................................. 40 5.2.7删除管理员的实现过程 .......................................................... 41 5.3图书档案管理模块设计 ..................................................................... 42

5.3.1图书档案管理模块概述 .......................................................... 42 5.3.2图书档案管理模块技术分析 .................................................. 43 5.3.3查看图书信息列表的实现过程 .............................................. 43 5.3.4添加图书信息的实现过程 ...................................................... 45 5.3.5 修改图书信息的实现过程 ................................................... 46 5.3.6 删除图书信息的实现过程 ................................................... 47 5.4.1 图书借还模块概述 ............................................................... 48 5.4.2 图书借还模块技术分析 ....................................................... 48 5.4.3图书借阅的实现过程 .............................................................. 49 5.3.4 图书续借的实现过程 ........................................................... 53 5.4.5图书归还的实现过程 .............................................................. 55 5.4.6 图书借阅查询的实现过程 ................................................... 56

6.系统测试 ...................................................................................................................................... 62

6.1 软件测试概念与方法 ........................................................................ 62

6.2 测试内容 ............................................................................................ 63 6.3测试结果 ............................................................................................. 63

6.3.1 登陆测试 ................................................................................. 64 6.3.2添加会员页面 .......................................................................... 64 6.3.3借还书测试 .............................................................................. 65

7.总结.............................................................................................................................................. 67 8.参考文献 ..................................................................................................................................... 68

4