校園二手信息網(wǎng)站的設(shè)計與開發(fā)

論文字數(shù):10196,頁數(shù):31

摘  要
二手信息網(wǎng)站，為二手物品交易提供了網(wǎng)上平臺。如今，隨著電子商務(wù)的不斷發(fā)展完善，大學校園也需要一個能為學生提供二手物品交易的專用網(wǎng)站，以便發(fā)布各種商品信息。
本設(shè)計具有一般電子商務(wù)的功能，且體現(xiàn)出校園風格。該系統(tǒng)提供的功能包括注冊、查詢信息、發(fā)布信息、找回密碼等。本系統(tǒng)的特點在于應(yīng)用了PHP技術(shù)。它是一種簡單的動態(tài)腳本語言，具有開放源碼、執(zhí)行速度快的特點。該技術(shù)還支持廣泛的數(shù)據(jù)庫連接 ，具有大量的擴展庫，安全性能高，易學易用。
本文首先介紹了該系統(tǒng)的可行性和應(yīng)用工具，并就系統(tǒng)的需求性和PHP的優(yōu)勢進行了闡述；接著進行系統(tǒng)分析,并設(shè)計了本系統(tǒng)所用到的基于MY SQL數(shù)據(jù)庫的數(shù)據(jù)表結(jié)構(gòu)；然后對該系統(tǒng)各功能模塊進行了詳細設(shè)計；最后，針對系統(tǒng)在代碼優(yōu)化和加密方面的不足做出總結(jié)。

關(guān)鍵詞：二手信息；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 技術(shù)可行性 1
1.2.2 經(jīng)濟可行性 1
1.2.3 運行可行性 1
1.2.4 法律可行性 2
2 理論基礎(chǔ)知識介紹 2
2.1 PHP技術(shù) 2
2.1.1 PHP簡介 2
2.1.2 PHP安裝 3
2.2 MySQL 簡介 5
2.2.1 MySQL 簡介 5
2.2.2 數(shù)據(jù)庫引擎 7
2.3 Apache簡介 7
3 系統(tǒng)分析與數(shù)據(jù)庫設(shè)計 8
3.1 系統(tǒng)功能需求分析 8
3.2 系統(tǒng)模塊關(guān)系圖 8
3.3 系統(tǒng)E-R圖 9
3.4 數(shù)據(jù)庫設(shè)計 11
3.4.1 數(shù)據(jù)庫表之間的關(guān)系 11
3.4.2 數(shù)據(jù)表結(jié)構(gòu)的詳細設(shè)計 11
3.5 系統(tǒng)安全 14
4 系統(tǒng)的實現(xiàn) 14
4.1 系統(tǒng)的主要功能 14
4.1.1 注冊 15
4.1.2 搜索信息 17
4.1.3 發(fā)布信息 18
4.1.4 密碼找回 20
4.1.5 數(shù)據(jù)庫連接代碼 22
4.2 創(chuàng)建界面 225 系統(tǒng)測試 23
5.1 本地服務(wù)器測試 23
5.2 遠程服務(wù)器測試 24
結(jié)    論 24
參考文獻 24
致   謝 26
聲   明 27