【正文】 本網(wǎng)站雖然完成了基本的研究目標(biāo)，但是由于設(shè)計(jì)者的經(jīng)驗(yàn)不足和時(shí)間限制，使得系統(tǒng)中還存在著一些不足之處，有待在以后的研究和維護(hù)過(guò)程中改進(jìn)。 圖 DNA 錄入 成功顯示 （ 2）進(jìn)入 phpMyAdmin，查看后臺(tái)數(shù)據(jù)庫(kù)，確認(rèn)是否成功錄入數(shù)據(jù)庫(kù)。 } 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 功能實(shí)現(xiàn)的核心代碼： ? //鏈接數(shù)據(jù)庫(kù)變量 $mysql_server_name =localhost。,39。, 39。界面的左上側(cè)上該基因信息管理系統(tǒng)的介紹；左下側(cè)是相關(guān)網(wǎng)站的鏈接，可以方便的 鏈接到 其他國(guó)內(nèi)外的生物數(shù)據(jù)庫(kù) 。 （ 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)可以進(jìn)行 DNA,RNA，蛋白質(zhì)序列的錄入，查詢，查看相關(guān)注釋?zhuān)徊⑶揖哂行蛄懈袷睫D(zhuǎn)換功能，轉(zhuǎn)化為標(biāo) 準(zhǔn)的 FAST 格式。 系統(tǒng)的設(shè)計(jì)的目的主要是為了有效地存儲(chǔ)和管理基因信息的數(shù)據(jù)庫(kù)。但是，應(yīng)用服務(wù)器運(yùn)行數(shù)據(jù)負(fù)荷較重，一旦發(fā)生服務(wù)器 ―崩潰 ‖等問(wèn)題，后果不堪設(shè)想。 客戶機(jī)上只要安裝一個(gè)瀏覽器（ Browser），如 Netscape Navigator 或 Inter Explorer，服務(wù)器安裝 Oracle、 Sybase、 Informix 或 SQL Server 等數(shù)據(jù)庫(kù)。 AppServ 是 PHP 網(wǎng)頁(yè)架站工具組合包，可以將網(wǎng)絡(luò)上免費(fèi)的架站資源重新包裝成單 一的安裝程序。面向?qū)ο缶幊痰?PHP 提供了類(lèi)和對(duì)象。 3 第一章 開(kāi)發(fā)環(huán)境介紹 語(yǔ)言簡(jiǎn)介 PHP，一個(gè) 嵌套 的縮寫(xiě)名稱(chēng)，是英文 超級(jí)文本 預(yù)處理語(yǔ)言（ PHP:Hypertext Preprocessor）的縮寫(xiě) [1]。 本系統(tǒng)實(shí)現(xiàn)了 高效、簡(jiǎn)單、快速的 PHP 操作平臺(tái) 管理 基因數(shù)據(jù)庫(kù)的功能 ， 后臺(tái) MySQL 數(shù)據(jù)庫(kù) 靈活 易于維護(hù)，更加 穩(wěn)定 、 安全。 【關(guān)鍵詞】 基因數(shù)據(jù)庫(kù)管理系統(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 第一章 開(kāi)發(fā)環(huán)境介紹 ........................................................................................................................ 3 語(yǔ)言簡(jiǎn)介 ........................................................................................................................... 3 PHP 運(yùn)行環(huán)境 .................................................................................................................. 4 數(shù)據(jù)庫(kù)簡(jiǎn)介 .................................................................................................................. 5 第二章 系統(tǒng)結(jié)構(gòu)與需求分析 ............................................................................................................ 7 B/S 結(jié)構(gòu)的簡(jiǎn)介 ................................................................................................................ 7 1 .B/S 結(jié)構(gòu)的概念 ................................................................................................................. 7 ................................................................................................................. 8 ........................................................................................................................ 9 .......................................................................................................................... 10 第三章 系統(tǒng)概要設(shè)計(jì) ...................................................................................................................... 11 .............................................................................................................................. 11 .......................................................................................................................... 11 3. 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) ............................................................................................................ 12 第四章 系統(tǒng)詳細(xì)設(shè)計(jì) ...................................................................................................................... 15 一．系統(tǒng)設(shè)計(jì)方案 ..................................................................................................................... 15 二．創(chuàng)建數(shù)據(jù)表 ......................................................................................................................... 15 信息表的創(chuàng)建： .......................................................................