留言本的制作（php+mysql）

1、 數(shù)據(jù)庫(kù)程序設(shè)計(jì) 實(shí)訓(xùn)報(bào)告 題 目: 留言本的制作 院 (系): 信息科學(xué)與工程學(xué)院 專業(yè)年級(jí): 計(jì)算機(jī)應(yīng)用專業(yè)2011級(jí)計(jì)應(yīng)一班 姓 名: 學(xué) 號(hào)： 指導(dǎo)教師: 2013年06月27日目錄一、項(xiàng)目簡(jiǎn)介3二、需求分析3三、流程設(shè)計(jì)3四、數(shù)據(jù)庫(kù)設(shè)計(jì)4五、創(chuàng)建數(shù)據(jù)庫(kù)5六、代碼功能簡(jiǎn)介：6七、成果展示19八、參考文獻(xiàn)及網(wǎng)址20留言本的制作開(kāi)發(fā)環(huán)境：php+mysql一、項(xiàng)目簡(jiǎn)介簡(jiǎn)介：從編程的角度講，留言本是一個(gè)比較簡(jiǎn)單但實(shí)用性比較強(qiáng)的項(xiàng)目。留言本的制作包括了很多我們需要掌握的學(xué)習(xí)內(nèi)容，例如：主頁(yè)面的制作管理，后臺(tái)數(shù)據(jù)庫(kù)的支持，管理員登陸頁(yè)面，管理留言。這個(gè)項(xiàng)目主要針對(duì)留言本進(jìn)行開(kāi)發(fā)，實(shí)現(xiàn)用戶登陸，后

2、臺(tái)管理，讀寫(xiě)數(shù)據(jù)庫(kù)等功能。項(xiàng)目試用平臺(tái)：windows7，windowxp項(xiàng)目開(kāi)發(fā)環(huán)境：php 5.3+mysql 5.1服務(wù)器：apache2.2二、需求分析（1）功能需求：用戶利用留言板可以發(fā)表自己的留言，管理員可以在后臺(tái)對(duì)留言進(jìn)行回復(fù)或刪除管理。（2）主要功能分為：前臺(tái)用戶留言展示與后臺(tái)留言管理兩個(gè)部分。三、流程設(shè)計(jì)如圖：管理員管理留言刪除留言用戶瀏覽頁(yè)面發(fā)布留言查看留言留言回復(fù)查看回復(fù)普通用戶四、數(shù)據(jù)庫(kù)設(shè)計(jì)數(shù)據(jù)庫(kù)名為：test，包含兩個(gè)表：admin和guestbook（1）表1：admin標(biāo)注字段名類(lèi)型長(zhǎng)度1uidint42usernamevarchar203userpassvarc

3、har20（2）表2：guestbook標(biāo)注字段名類(lèi)型長(zhǎng)度1idint42nicknamechar163emailvarchar604facetinyint25contenttext6createtimeint107clientipchar158replytext9replytimeint10五、創(chuàng)建數(shù)據(jù)庫(kù)1）創(chuàng)建數(shù)據(jù)庫(kù)：如圖：2）建表：表1：admin表2：guestbook六、代碼功能簡(jiǎn)介：共六個(gè)頁(yè)面：1. conn.php：數(shù)據(jù)庫(kù)連接包含文件2. config.php：統(tǒng)配置文件，用于配置每頁(yè)顯示留言條數(shù)等3. index.php：留言板主界面，用于留言讀取顯示及用戶留言表單（留言表單在

4、留言顯示下方）4. subting.php：處理留言者提交的留言信息5. login.php：管理員登錄及驗(yàn)證頁(yè)面6. admin.php：留言管理主界面，讀取留言數(shù)據(jù)，提供回復(fù)表單及刪除等操作界面7. reply.php：用于留言回復(fù)，刪除等具體操作l conn.php代碼如下：l config.php代碼如下：l index.php代碼如下：請(qǐng)您留言function InputCheck(form1) if (form1.nickname.value = ) alert(請(qǐng)輸入您的昵稱。); form1.nickname.focus(); return (false); if (form1

5、.content.value = ) alert(留言內(nèi)容不可為空。); form1.content.focus(); return (false); 留言列表img src=images/.gif / 管理員回復(fù)： 1) for($i=1;$i=$pagenum;$i+) if($i=$p) echo  ,$i,; else echo  .$i.;?發(fā)表留言 請(qǐng)您留言  查看留言   管理留言 昵      稱:(必須填寫(xiě)，不超過(guò)16個(gè)字符串)電子郵件:(非必須，不超過(guò)60個(gè)字符串)

6、頭      像: 留言內(nèi)容:(請(qǐng)自覺(jué)遵守互聯(lián)網(wǎng)相關(guān)政策法規(guī)，嚴(yán)禁發(fā)布色情、暴力、反動(dòng)言論) 運(yùn)行效果如圖：l subting.php代碼如下：16)exit(錯(cuò)誤：昵稱不得超過(guò)16個(gè)字符串 返 回 );if(strlen($nickname)60)exit(錯(cuò)誤：郵箱不得超過(guò)60個(gè)字符串 返 回 );require(conn.php);require(function.php);$createtime = time();$ip = get_client_ip();/ 數(shù)據(jù)寫(xiě)入庫(kù)表$insert_sql = INSERT INTO g

7、uestbook(nickname,email,face,content,createtime,clientip)VALUES;$insert_sql .= ($nickname,$email,$_POSTface,$content,$createtime,$ip);if(mysql_query($insert_sql)?留言成功留言成功！非常感謝您的留言。請(qǐng)稍后，頁(yè)面正在返回.?php else echo 留言失敗：,mysql_error(), 返 回 ;?l login.php代碼如下：excu($query);/跳轉(zhuǎn)到后臺(tái)管理頁(yè)header(location:./admin.php);

8、 ?留言管理登錄管理密碼: 返回留言板運(yùn)行效果如圖：l admin.php代碼如下：留言管理留言列表img src=images/.gif / ID號(hào)： 留言者IP： a href=reply.php?action=delete&id=刪除留言 注銷(xiāo)登錄回復(fù)本條留言:input name=id type=text value= / 1) for($i=1;$i=$pagenum;$i+) if($i=$p) echo  ,$i,; else echo  .$i.;?運(yùn)行效果如圖：七、成果展示項(xiàng)目整體運(yùn)行效果如圖：八、參考資料文獻(xiàn)及網(wǎng)址文獻(xiàn)：php+mysq

9、l動(dòng)態(tài)網(wǎng)站開(kāi)發(fā)與全程實(shí)例 SQL Server 2005數(shù)據(jù)庫(kù)技術(shù)與應(yīng)用SQL Server 數(shù)據(jù)庫(kù)設(shè)計(jì)與系統(tǒng)開(kāi)發(fā)教程網(wǎng)址： /p-php_guestbook.shtml視頻：韓順平php精講內(nèi)部資料，請(qǐng)勿外傳！9JWKffwvG#tYM*Jg&6a*CZ7H$dq8KqqfHVZFedswSyXTy#&QA9wkxFyeQ!djs#XuyUP2kNXpRWXmA&UE9aQGn8xp$R#͑GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8

10、!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2

11、zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmUE9aQGn8xp$R#͑GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5p

12、Dx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z8vG#tYM*Jg&6a*CZ7H$dq8KqqfHVZFedswSyXTy#&QA9wkxFyeQ!djs#XuyUP2kNXpRWXmA&UE9aQGn8xp$R#͑GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGp

13、P$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxG89AmUE9aQGn8xp$R#͑GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazad

14、Nu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z8vG#tYM*Jg&6a*CZ7H$dq8KqqfHVZFedswSyXTy#&QA9wkxFyeQ!djs#XuyUP2kNXpRWXmA&UE9aQGn8xp$R#͑GxGjqv$U

15、E9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7

16、JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmUE9aQGn8xp$R#͑GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3

17、tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9

18、wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNuGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazad

19、Nu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$U*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGp

20、P$vSTT#&ksv*3tnGK8!z89Amv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z

21、89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$U*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz84!z89Amv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z

22、89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$U*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&M

23、uWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$U*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#

24、&ksv*3tnGK8!z89AmYWpazadNuGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849Gx

25、Gjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmY

26、WpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqvadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9

27、CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$U*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89Amv$UE9w

28、EwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!zn%Mz849GxGjqv$UE9wEwZ#QcUE%&qYpEh5pDx2zVkum&gTXRm6X4NGpP$vSTT#&ksv*3tnGK8!z89AmYWv*3tnGK8!z89AmYWpazadNu#KN&MuWFA5uxY7JnD6YWRrWwcvR9CpbK!z