【正文】 17 Apache 概要說(shuō)明 ............................................................................... 17 后臺(tái)數(shù)據(jù)庫(kù) —— MySql ............................................................................... 18 MySql 快速安裝 ................................................................................ 18 MySql 概要說(shuō)明 ................................................................................ 18 編程語(yǔ)言 —— PHP4 .................................................................................... 19 PHP4 快速安裝 .................................................................................. 19 PHP4 概要說(shuō)明 .................................................................................. 19 第四章 系統(tǒng)的需求分析和設(shè)計(jì)特點(diǎn) ........................................................................ 21 畢業(yè)設(shè)計(jì)的基本要求 .................................................................................. 21 網(wǎng)站的前臺(tái)網(wǎng)頁(yè)框架 .................................................................................. 21 網(wǎng)站主頁(yè)的框架 ................................................................................ 21 網(wǎng)站主頁(yè)的框架草圖 ................................................................ 21 實(shí)際的設(shè)計(jì)主頁(yè)框架圖案 ......................................................... 22 網(wǎng)站二級(jí)網(wǎng)頁(yè)的框架 ......................................................................... 22 網(wǎng)站二級(jí)網(wǎng)頁(yè)的框架草圖 ......................................................... 22 實(shí)際的設(shè)計(jì)二級(jí)網(wǎng)頁(yè)框架圖案 .................................................. 23 網(wǎng)站的主體內(nèi)容 ......................................................................................... 23 基于 PHP/MYSQL 技術(shù)的學(xué)校網(wǎng)站建設(shè) 3 網(wǎng)頁(yè)的色調(diào) ...................................................................................... 23 網(wǎng)頁(yè)的標(biāo)題欄 ................................................................................... 23 網(wǎng)頁(yè)的導(dǎo)航條 ................................................................................... 24 主頁(yè)的導(dǎo)航條 ......................................................................... 24 二級(jí)網(wǎng)頁(yè)的導(dǎo)航條 .................................................................. 24 主頁(yè)的新聞欄 .................................................................................... 25 主頁(yè)的通告欄 .................................................................................... 25 用戶服務(wù)的快速登陸 ........................................................................ 25 后臺(tái)管理界面的框架 .................................................................................. 25 管理員界面的框架 ............................................................................ 25 管理員界面的框架草圖 ........................................................... 25 實(shí)際設(shè)計(jì)的管理員界面的框架 ................................................. 26 普通用戶管理界面的框架 ................................................................. 27 普通用戶管理界面的框架草圖 ................................................. 27 實(shí)際設(shè)計(jì)的普通用戶管理界面的框架 ...................................... 27 功能模塊 ................................................................................................... 28 頁(yè)面的新聞顯示模塊和消息顯示模塊 ................................................. 29 用戶登陸認(rèn)證模塊 ............................................................................ 29 普通用戶模塊 ................................................................................... 29 個(gè)人管理模塊 .......................................................................... 29 新聞管理模塊 .......................................................................... 30 管 理員模塊 ...................................................................................... 30 用戶管理模塊 .......................................................................... 30 新聞管理模塊 .......................................................................... 30 通告管理模塊 .......................................................................... 31 用戶退出登陸模塊 ............................................................................ 31 數(shù)據(jù)庫(kù)的表的設(shè)計(jì) ..................................................................................... 31 用戶信息表 —— user 表的建立 ............................................................ 31 新聞信息表 —— news 表的建立 .......................................................... 31 通告信息表 —— informations 的建立 ................................................... 32 第五章 系統(tǒng)的實(shí)現(xiàn) ................................................................................................. 33 MySQL 數(shù)據(jù)庫(kù)訪問(wèn)權(quán)限設(shè)定 ....................................................................... 33 PHP 與 MySQL 訪問(wèn)操作 ............................................................................ 34 PHP 與 MySQL 訪問(wèn)操作步驟 ............................................................ 34 在本系統(tǒng)中 PHP 與 MySQL 訪問(wèn)的實(shí)現(xiàn) ............................................ 35 用戶認(rèn)證模塊 ............................................................................................ 36 用戶驗(yàn)證的基本原理 ........................................................................ 36 本系統(tǒng)的用戶認(rèn)證實(shí)現(xiàn) ..................................................................... 38 個(gè)人管理模塊的實(shí)現(xiàn) .................................................................................. 40 個(gè)人基本信息的顯示 ........................................................................ 40 個(gè)人密碼的修改 ................................................................................ 41 個(gè)人上傳新聞和通告的管理 ............................................................... 43 其他用戶管理模塊 ..................................................................................... 43 顯示其他用戶的基本資料 .................................................................. 43 基于 PHP/MYSQL 技術(shù)的學(xué)校網(wǎng)站建設(shè) 4 用戶帳號(hào)管理 ................................................................................... 44 修改密碼 ................................................................................ 44 增加新用戶帳號(hào) ...................................................................... 44 刪除用戶帳號(hào) ....................................................