校园二手信息网站的设计与开发

包括论文,设计,论文字数:10196,页数:31

摘  要
二手信息网站，为二手物品交易提供了网上平台。如今，随着电子商务的不断发展完善，大学校园也需要一个能为学生提供二手物品交易的专用网站，以便发布各种商品信息。
本设计具有一般电子商务的功能，且体现出校园风格。该系统提供的功能包括注册、查询信息、发布信息、找回密码等。本系统的特点在于应用了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

目  录

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 创建界面 225 系统测试 23
5.1 本地服务器测试 23
5.2 远程服务器测试 24
结    论 24
参考文献 24
致   谢 26
声   明 27

相关论文