【正文】 計(jì)算機(jī)的普及和網(wǎng)絡(luò)的發(fā)展，人們的生活越來越依賴于電腦，也越來越習(xí)慣于在網(wǎng)上聽音樂、看電影。目前，互聯(lián)網(wǎng)上供人們聽音樂、看影視的網(wǎng)站已經(jīng)很多，其發(fā)展也日趨成熟，電影愛好者有其鮮明的特性，他們喜歡、關(guān)注的影音信息也有其共同特點(diǎn)。 目前，在互聯(lián)網(wǎng)上有很多供網(wǎng)友收聽音樂、下載音樂、在線點(diǎn)歌，觀看影視、下載視頻、的網(wǎng)站。 在線影視播放網(wǎng)站一般采用目前 Inter 上較流行的網(wǎng)站構(gòu)架方式LAMP(Linux+Apache+MySQL+PHP),由于所使用的四種軟件都是遵循 GPL 的開放源碼軟件，因此使用這種構(gòu)架方式 只需要較低的開發(fā)成本就能建立起一個(gè)穩(wěn)定、免費(fèi)的網(wǎng)站系統(tǒng)。 網(wǎng)絡(luò)上影音資源紛亂繁雜，人們想要找到適合自己并且樂于關(guān)注的影音資源往往費(fèi)時(shí)費(fèi)力。 它由多個(gè)功能模塊組成，前臺(tái)頁面包括：在線視聽頁面，上傳頁面，下載頁面，影音信息查看頁面，信息查詢頁面，會(huì)員操作頁面等；后臺(tái)頁面包括：登錄日志管理頁 面，管理員對(duì)數(shù)據(jù)的管理頁面，管理員對(duì)會(huì)員的管理頁面以及目錄管理頁面。本 系統(tǒng)主要提供在線視聽、影視音樂資源交流分享等功能，同時(shí)，提供會(huì)員注冊(cè)，用戶可以注冊(cè)并登錄管理自己的個(gè)人信息，可以搜索視聽影音信息，會(huì)員登錄以后可以上傳或下載影音資源，并且可以在線點(diǎn)歌等功能。該系統(tǒng)具有以下的特點(diǎn)：（ 1）基于 PHP 的相關(guān) 技術(shù)設(shè)計(jì)本系統(tǒng)；（ 2）采用多媒體引用技術(shù)播放影音文件；（ 3）采用文件上傳和下載技術(shù)實(shí)現(xiàn)圖像、音頻、視頻文件的客戶端的上傳和下載；（ 4）信息搜索靈活、方便。PHP。APACHE 吉林省自學(xué)考試計(jì)算機(jī)應(yīng)用軟件專業(yè) 本科生畢業(yè)論文 視頻播客系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 第 II 頁 共 32 頁 Abstract With the popularity of puter and the development of the work, the life of people rely more and more on puters, also more and more used to listen to music on the Inter, movies. At present, There has been a lot of web site for people to listen to music, watching development has bee more and more mature, the film lovers have a distinct characteristics, Video information they like and attention also has its mon ,Special needle such groups design and implement a online audiovisual, share and exchange information platform for them is important. At present, In the Inter has many web sites for friend to listen and downloadwatch the movie and TV, download website is with the development of Inter,emerging in recent years, they has popular on work, It not only enrich people entertainment, also provid convenient video information resource exchange for people. Film and television play online website general use the present more popular web site on the Inter architecture way LAMP (Linux + Apache + MySQL + PHP), due to the use of four kinds of software are follow GPL and open source software, so use this framework only need lower way development costs can set up a stable, free web system. Video podcast system mainly USES the multimedia quoted technology play video files, the website used the file upload and download technology to realize image, audio and video files client upload and download. The work video resources chaos multifarious, people want to find suitable for their attention and willing to video resources often timeconsuming. A good video podcast system for the exchange of information and share video, special design of the system can save time and provide useful consists of multiple function modules, front desk page includes: online audiovisual page, upload page, download page, video and audio information view pages, information query page, member pages of operation。The background is mainly used for administrator for film and television music data information and login log system provide online audiovisual,film and TV music sharing and other functions,At the same time,It also provides the register,the user can register and login to manage his own personal information,and search audiovisual video information,members can upload or download after login video resources,be online set up a system administrator account,may to the member login,film data information and login log management The system has following characteristics:(1)based on the relevant technology of the PHP designed system。(3)file upload and download technology realizes image, audio and video files client upload and download。 PHP。APACHE 吉林省自學(xué)考試計(jì)算機(jī)應(yīng)用軟件專業(yè) 本科生畢業(yè)論文 視頻播客系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 第 III 頁 共 32 頁 目 錄摘 要 ......................................................... I ABSTRACT ................................................................................................................... II 第 1 章 緒論 .................................................... 1 課題背景 ..................................................... 2 在線影視網(wǎng)站開發(fā)前景及相關(guān)技術(shù) ............................... 2 基于 PHP 的在線影視網(wǎng)站開發(fā)前景 .......................... 2 LAMP 及 WAMP 項(xiàng)目概述 .................................... 3 第 2 章 基于 PHP 開發(fā) 本系統(tǒng)的技術(shù)介紹 .............................. 7 PHP 介紹 ...................................................... 7 什么是 PHP 語言 .......................................... 7 PHP 語言的特點(diǎn) .......................................... 8 MySQL 及其相關(guān)技術(shù)介紹 ........................................ 8 什么是 MySQL ............................................ 8 MySQL 的特性 ............................................ 9 MySQL 的相關(guān)技術(shù) ........................................ 9 Apache 及其相關(guān)技術(shù)介紹 ...................................... 10 什么是 Apache .......................................... 10 Apache 的相關(guān)技術(shù)特點(diǎn) .................................. 10 本章小結(jié) .................................................... 11 第 3 章 系統(tǒng)分析與設(shè)計(jì) .......................................... 12 系統(tǒng)簡(jiǎn)述 .................................................... 12 需求分析 .................................................... 12 系統(tǒng)概要設(shè)計(jì) ................................................ 12 系統(tǒng)目標(biāo) ............................................... 12 系統(tǒng)功能結(jié)構(gòu) ........................................... 13 文件夾組織結(jié)構(gòu) ......................................... 15 本章小結(jié) .................................................... 16 第 4 章 系統(tǒng)實(shí)現(xiàn)及測(cè)試 .......................................... 17 系統(tǒng)詳細(xì)設(shè)計(jì) ................................................ 17 系統(tǒng)數(shù)據(jù)庫設(shè)計(jì) .............................................. 17 數(shù)據(jù)庫概念設(shè)計(jì) ......................................... 17 數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計(jì) ..................................... 18 吉林省自學(xué)考試計(jì)算機(jī)應(yīng)用軟件專業(yè) 本科生畢業(yè)論文 視頻播客系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 第 1 頁 共 32 頁 系統(tǒng)模塊設(shè)計(jì) ................................................ 20 前臺(tái)首頁模塊設(shè)計(jì) ....................................... 20 視頻（音頻）模塊設(shè)計(jì) ..................................