【正文】 本網(wǎng)站雖然完成了基本的研究目標，但是由于設(shè)計者的經(jīng)驗不足和時間限制，使得系統(tǒng)中還存在著一些不足之處，有待在以后的研究和維護過程中改進。 圖 DNA 錄入 成功顯示 （ 2）進入 phpMyAdmin，查看后臺數(shù)據(jù)庫，確認是否成功錄入數(shù)據(jù)庫。 } mysql_free_result($result)。 while($row=mysql_fetch_row($result)) { //print_r($row)。 所得到的結(jié)果顯示在下面的文本框中。float:left。 mysql_close($conn)。,39。 ( 39。,39。, 39。 圖 RNA 錄入功能 22 功能實現(xiàn)的核心代碼： ? //鏈接數(shù)據(jù)庫變量 $mysql_server_name =localhost。,39。, 39。界面的左上側(cè)上該基因信息管理系統(tǒng)的介紹；左下側(cè)是相關(guān)網(wǎng)站的鏈接，可以方便的 鏈接到 其他國內(nèi)外的生物數(shù)據(jù)庫 。 （ 2） .MySQL 表的建立如圖所示： 17 圖 RNA 信息表 信息表的創(chuàng)建： （ 1）相關(guān)代碼： CREATE TABLE `protein` ( `P_ID` `GENE_ID` TINYINT( 100 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT39。 ) ENGINE = MYISAM 。本系統(tǒng)可以進行 DNA,RNA，蛋白質(zhì)序列的錄入，查詢，查看相關(guān)注釋；并且具有序列格式轉(zhuǎn)換功能，轉(zhuǎn)化為標 準的 FAST 格式。 系統(tǒng)的設(shè)計的目的主要是為了有效地存儲和管理基因信息的數(shù)據(jù)庫。但是，應(yīng)用服務(wù)器運行數(shù)據(jù)負荷較重，一旦發(fā)生服務(wù)器 ―崩潰 ‖等問題，后果不堪設(shè)想。 客戶機上只要安裝一個瀏覽器（ Browser），如 Netscape Navigator 或 Inter Explorer，服務(wù)器安裝 Oracle、 Sybase、 Informix 或 SQL Server 等數(shù)據(jù)庫。 AppServ 是 PHP 網(wǎng)頁架站工具組合包，可以將網(wǎng)絡(luò)上免費的架站資源重新包裝成單 一的安裝程序。面向?qū)ο缶幊痰?PHP 提供了類和對象。 3 第一章 開發(fā)環(huán)境介紹 語言簡介 PHP，一個 嵌套 的縮寫名稱，是英文 超級文本 預(yù)處理語言（ PHP:Hypertext Preprocessor）的縮寫 [1]。 本系統(tǒng)實現(xiàn)了 高效、簡單、快速的 PHP 操作平臺 管理 基因數(shù)據(jù)庫的功能 ， 后臺 MySQL 數(shù)據(jù)庫 靈活 易于維護，更加 穩(wěn)定 、 安全。 【關(guān)鍵詞】 基因數(shù)據(jù)庫管理系統(tǒng) PHP MySQL Apache II ABSTRACT Biological informatics is one of the most important and advanced scientific frontiers now. It has been widely applied in many aspects such as the analysis, management of the gene sequence data and proved it‘s key role in the research of molecular biology and the pace of updating biological database, is growing speedily, the amount of gene data is exponentially growing, the frequency of database using is increasing faster, how to effectively storage data and manage biological sequences data is one of the important problems need to solve for bioinformatics. Geic database prehensive management system is very important resource management in biological information field. Based on the above background, developing an easytouse database prehensive management system is very necessary .We using B/S structure, namely the Browser/Server (browsers) structure, designing a prehensive management system for database of genes based PHP and MySQL . The system can realize the load of geic information, query, notes, etc. The design of database is aimed to effectively storage and management problems of the genome sequences that are generated largely and ready to be analysed. So this system can record the information of DNA, RNA, protein sequences, and related annotation to query, also the conversion function can format sequence into standard FASTA format. The graduation design is constructed geic database management system website with the framework for the Dreamweave. Geic information database system constructs with MySQL as backend database, with Apache for server, using PHP language. This system is simple, quick and efficient geic database management platform operated of the PHP,The backend MySQL database, more flexible and easy to maintain stability and security. 【 Key words】 geic database management system PHP MySQL Apache III 目 錄 前 言 .................................................................................................................................................. 1 1．課題提出背景 ......................................................................................................................... 1 2．本研究的目的與意義 ............................................................................................................. 1 第一章 開發(fā)環(huán)境介紹 ........................................................................................................................ 3 語言簡介 ........................................................................................................................... 3 PHP 運行環(huán)境 .................................................................................................................. 4 數(shù)據(jù)庫簡介 .................................................................................................................. 5 第二章 系統(tǒng)結(jié)構(gòu)與需求分析 ............................................................................................................ 7 B/S 結(jié)構(gòu)的簡介 ................................................................................................................ 7 1 .B/S 結(jié)構(gòu)的概念 ................................................................................................................. 7 ................................................................................................................. 8 ........................................................................................................................ 9 .......................................................................................................................... 10 第三章 系統(tǒng)概要設(shè)計 ...................................................................................................................... 11 .............................................................................................................................. 11 .......................................................................................................................... 11 3. 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 ............................................................................................................ 12 第四章 系統(tǒng)詳細設(shè)計 ...................................................................................................................... 15 一．系統(tǒng)設(shè)計方案 ..................................................................................................................... 15 二．創(chuàng)建數(shù)據(jù)表 ......................................................................................................................... 15 信息表的創(chuàng)建： .......................................................................