x x 论 文
校园二手信息网站的设计与开发
论文作者姓名：
申请学位专业：
申请学位类别：
指导教师姓名（职称）：
论文提交日期：
校园二手信息网站的设计与开发
摘 要
二手信息网站，为二手物品交易提供了网上平台。如今，随着电子商务的不
断发展完善，大学校园也需要一个能为学生提供二手物品交易的专用网站，以便
发布各种商品信息。
本设计具有一般电子商务的功能，且体现出校园风格。该系统提供的功能包
括注册、查询信息、发布信息、找回密码等。本系统的特点在于应用了 PHP 技
术。它是一种简单的动态脚本语言，具有开放源码、执行速度快的特点。该技术
还支持广泛的数据库连接 ，具有大量的扩展库，安全性能高，易学易用。
本文首先介绍了该系统的可行性和应用工具，并就系统的需求性和 PHP 的
优势进行了阐述；接着进行系统分析,并设计了本系统所用到的基于 MY SQL 数
据库的数据表结构；然后对该系统各功能模块进行了详细设计；最后，针对系统
在代码优化和加密方面的不足做出总结。
关键词：二手信息；PHP；MySQL；APACHE；MD5；SESSION
Design and Development of Campus Second-hand
Information Website
Abstract
Second-hand information website provides a second-hand goods transactions
online platform. Now, with the continuous development of e-commerce perfect,
University campus also needs an able to provide our students with the second-hand
goods transactions dedicated web site, in order to disseminate information of various
commodities.
E-commerce’s general function can find in this design, and reflects the style of
the campus. Functions include user registration, information inquiry, disseminate
information and retrieve passwords in the system. The system has a major
characteristic of PHP applications which is a simple dynamic scripting language that
is open source, faster implementation characteristics. And it supports a wide range of
database connections, with a lot of extensions, security is also very high performance,
easy to learn and use.
This paper introduces the feasibility of the system and application tools,
described the needs of the system and the advantages of PHP, then the systems
analysis, design and MY SQL-based database system used in the data table structure,
Then the function of the system modules and the detailed design and code is a major
achievement. Description and testing of the system encountered a character coding
using the database errors; by setting MYSQL and linking coding solve this error.
Finally, summarize the system of encryption and code optimization for the shortage.
Key words: Second-Hand Information; PHP; MySQL; APACHE; MD5;
SESSION
目 录
论文总页数：27 页
1 引 言........................................................................................................................................1
1.1 课题的背景 ......................................................................................................................1
1.2 可行性分析 ......................................................................................................................1
1.2.1 技术可行性 ............................................................................................................1
1.2.2 经济可行性 ............................................................................................................1
1.2.3 运行可行性 ............................................................................................................1
1.2.4 法律可行性 ............................................................................................................2
2 理论基础知识介绍....................................................................................................................2
2.1 PHP 技术 ..........................................................................................................................2
2.1.1 PHP 简介................................................................................................................2
2.1.2 PHP 安装................................................................................................................3
2.2 MySQL 简介 ...................................................................................................................5
2.2.1 MySQL 简介 .........................................................................................................5
2.2.2 数据库引擎 ............................................................................................................7
2.3 Apache 简介 .....................................................................................................................7
3 系统分析与数据库设计............................................................................................................8
3.1 系统功能需求分析 ..........................................................................................................8
3.2 系统模块关系图 ..............................................................................................................8
3.3 系统 E-R 图......................................................................................................................9
3.4 数据库设计 ....................................................................................................................11
3.4.1 数据库表之间的关系 ..........................................................................................11
3.4.2 数据表结构的详细设计 ......................................................................................11
3.5 系统安全 ........................................................................................................................14
4 系统的实现..............................................................................................................................14
4.1 系统的主要功能 ............................................................................................................14
4.1.1 注册 ......................................................................................................................15
4.1.2 搜索信息 ..............................................................................................................17
4.1.3 发布信息 ..............................................................................................................18
4.1.4 密码找回 ..............................................................................................................20
4.1.5 数据库连接代码 ..................................................................................................22
4.2 创建界面 ........................................................................................................................22
5 系统测试..................................................................................................................................23
5.1 本地服务器测试 ............................................................................................................23
5.2 远程服务器测试 ............................................................................................................24
结 论..........................................................................................................................................24
参考文献..........................................................................................................................................24
致 谢............................................................................................................................................26
声 明............................................................................................................................................27
