《PHP+MYsql图书管理系统》.doc

摘要 虽然目前很多大型的图书馆已经有一整套比较完善的管理系统，但是在一些中小型的图书馆中，大部分工作仍需由手工完成，工作起来效率比较低，管理员不能及时了解图书馆内各类图书的借阅情况，读者需要的图书难以在短时间内找到，不便于动态及时地调整图书结构为了更好地适应当前读者的借阅需求，解决手工管理中存在的许多弊端，越来越多的中小型图书馆正在逐步向计算机信息化管理转变。 本系统设计实现了基于web的图书管理系统,该系统采用现今比较流行的PHP语言,结合MYsql数据库,实现了图书信息的存储查询等功能。系统不仅维护方便,节省了图书馆的资源,方便图书馆进行管理图书,本系统主要为图书管理者而设计,为学校和学生提供提供科学化图书管理数据的平台。 系统主要功能包括:用户的管理，图书的增删，图书的检索等。 关键词: 数据库；PHP；MySQL；数据库技术；图书管理 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 cant 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 its 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 目录 1 绪论 6 1.1 研究背景 6 1.2 研究现状 6 1.3 研究意义 7 2相关技术综述 8 2.1 PHP技术 8 2.2 MYSQL数据库 9 2.3 Apache 10 2.4 WampServer 10 2.5 数据库简介 11 2.6 网页制作工具 12 2.7 B/S模式 12 3 需求分析 16 3.1 系统需求 16 3.2 需求分析 16 3.2.1 功能分析 16 3.2.2 功能描述 16 3.2.3可行性分析 17 4 总体设计 18 4.1 系统流程图 18 4.2 数据库设计 18 4.2.1 数据库概念设计 18 4.2.2 创建数据库及数据表 20 5 设计思想与实