基于PHP和MySQL的网站设计外文资料

Design and Implementation of the Website Based on

PHP&MYSQL

Abstract

PHP and MYSQL has been the main web development tool for it is free and open source.The authors have discussed the environmental issues in development process based on PHP and MYSQL and the implementation process of the website. Keywords

PHP;MYSQL;Development and.Implementation

1.INTRODUCTION

With the development of Web technology,it is inevitable choice for all kind of corporate growth to combine traditional marketing with network marketing.The effective method of network marketing is to establish the website which is suitable for their company.At present the website development's mainstream platform includes: LAMP(Linux operating system,Apache network server,MYSQL database,PHP programming language),J2EE https://www.wendangku.net/doc/d46269202.html, commercial software.Because PHP and MYSQL is free,open source and so on,they are noted for IT professionals.From the perspective of website traffic,more than70%of website traffic is provided with LAMP,which is most popular platform for developing the website.

In this paper,we designed a website based on PHP and MYSQL.The paper is organized as follows.Section1analyzes development environment.In Section2, we proposed the development model based on PHP.Then case study in Section4.we make conclusion In Section5.

2.DEVELOPMENT ENVIRONMENT ANALYSIS

A.The Choice of Development Language

https://www.wendangku.net/doc/d46269202.html,,PHP&JSP are three mainstream languages of the website development,which have their advantages and disadvantages respectively,the comparison between them is shown in Table1.

The project takes PHP as the development language,the reason is as follows:

?Free.The project is small,which is no need to use the payment development platform such as https://www.wendangku.net/doc/d46269202.html, and JSP.

?Strong supporting.Middle and small scale websites,even some large-scale websites such as baidu,Sina in China take PHP as the development language,which can contribute to solve the problem during the programming.

?Good portability.Although it is designed to use in the environment of Linux and Apache Web server system at first,now PHP is already transplanted any operating system and compatible standard Web server software.

?Simple grammar.PHP has many similarities with the C programming language, so it is easy to program using PHP for the C programmers.

?Rapid development.Because the source code is open,PHP will continue to

develop rapidly.

B.Build Development Environment

At present there are many development platform based on PHP.Generally most developers like the development environment LAMP.Those who have certain development experience can set up their development platform by choosing the related server,DBMS,and operating system.There are some PHP IDE(integrated development environment)such as AMPSERV,WAMP,XMAPP,APPSERV, PHPSTUDY in the market for the developers develop the website by using PHP.

At present the main PHP IDE is Zend Studio,which has included developing components for PHP.It reduces the development time and simplifies the complex application plan during edition,debugging,analysis and optimization.The Zend Studio not only has code for high measurement,grammar shrinking automatically and bookmark,but also its embedded debugger which fits for local and remote debugging patterns.It is many high debugging functions such as variable tracking,Single-step operation,breakpoint,function calling,and so on.Moreover,it is also very stable in supporting Chinese for the latest version.

C.Notes in Building the Development Environment

Those who are unfamiliar with the development environment do not set it up by himself for it may cause a conflict between various edition,moreover it is very difficult to solve the complex configuration problem.

?PHP language version.Before development,you must ensure consistence of the edition between PHP language and the server.Now PHP mainly has two editions (PHP4and PHP5).The different versions have the difference with SESSION, exception handling,the variable range,the data type and so on.

?Server problem.The program which is edited with PHP in the windows platform will be arranged on the apache server.If it is arranged on IIS it leads to some incompatible problems and some update by manual such as writable rights is set up before uploading the document.There are not these problems if it is arranged on the apache server.

?Database problem.DBMS using with PHP has MYSQL,ORACLE and so on. MYSQL is welcomed by most of the developers for it is open source,free,and efficient.MYSQL is perfect database server software for medium and small application system.Besides standard ANSI SQL,it also supports many platforms. On the Unix/Linux system,MYSQL also supports the multi-thread.MYSQL becomes the first choice of middle and small level PHP website for it is open source and it provides a series of supports such as read-write access.

3.THE DEVELOPMENT MODEL BASED ON PHP

PHP becomes the main development language in the small and medium-sized enterprise website for it is free,open source,etc.The development step is as follows: A.Demand analysis

There are various demands for a website project.Those demands often stem from or company oneself needs,most of which is the actual needs of customers.What extent the project leaders understand the user's needs has decided whether is success

or failure in developing the website.Therefore user's needs in the form of document can clearly be transformed into all project development members,which is the main problem during the project development.

Besides basic user's needs,there are some problems as follows are needed to notice:

?The demand should be confirmed by way of the document.

?The feasibility and price of their demands are informed to the demand side after effective analysis and discussion.

B.Functional module design

The demand report will be organized as some modules according to the principles of high cohesion and low coupling and related experience by the website developers.

C.Database design and implementation

It contains the demand analysis,the concept design,the logical design,the physical design,the system implementation,the operation and the maintenance.The following problems should be paid attention to during the database design and implementation:

Database security[5]:The database is the core of website,in which the data security is very important.The damage and lose or illegal duplication of data can cause a lot of trouble,moreover the mistake is very difficult to restore.MYSQL security measures are as follows:

?Account security:Each account of MYSQL is composed of user name, password as well as the position,which includes reasonable rights and security check.The reasonable rights demand that there are different rights for the different account and as identical user there are different rights for different database or data sheet.There are three different security checks in the MYSQL:register confirmation, authorization,access control.

?Stored data encryption[6]:for the massive information in application program, you only want to encrypt a very small part of it,such as user password.These passwords should not store in the form of plaintext but encryption in the database.In general,the sensitive data is encrypted by Hash algorithm in most DBMS including MYSQL.

The database character set and coding[7]:The default code used in web server software installed,like Apache,is not UTF-8.The webpage is normally browsed when we input data into table coded in UTF-8,but Chinese in phpMyAdmin turns into messy code.The solution is that the default code in MYSQL turned into UTF-8 or the data code(UTF-8)is assigned when the database is connected[8].

D.The Functional Module Implementation

A few codes,detailed annotation and standardized writing are demanded during functional module implementation.The goal is high reusability,high reliability,efficiency,high security and so on.

4.CASE STUDY

The authors developed the consult website(ZhuoQi,domain name address is

https://www.wendangku.net/doc/d46269202.html,/)based on PHP.ZhuoQi mainly includes nine modules, such as the retrieval module,the expert consult module,the issue maintenance module, the member interaction module,the problem discussion module,the documents browsing module,the registration module,the help module and other auxiliary modules.

Each module consists of a large number of functional modules,for example, retrieval module in the website ZhuoQi mainly consists of the front module,input check module,matching search module,and display return module,etc.The front code in implementing retrieval module.

The specific process is that the user input the related retrieval information into the search box,then the information will be sent to the end processing page after the button“retrieval”is pressed.The information inputted is checked by calling the end code.If which is valid,the results matched successfully will be displayed in the predetermined format after matching between the information inputted and the information in the database.

5.CONCLUSION

PHP and MYSQL has been the main web development tool for it is free,open source,high reliability,portability.

REFERENCES

[1]LAMP.https://www.wendangku.net/doc/d46269202.html,/view/365086.htm?fr=ala0_1_1.4(In Chinese).

[2]Guo Liang,Gao Hui.The research on comparison between ASP,and JSP Heilongjiang Science and Technology Information.2007,(17):80(In Chinese).

[3]Zhang https://www.wendangku.net/doc/d46269202.html,parative Analysis between https://www.wendangku.net/doc/d46269202.html,,PHP and JSP. Friend of Science Amateurs.2008,(33):132-133(In Chinese).

[4]Zend Studio 5.5.1Integrated Development Environment Series. https://www.wendangku.net/doc/d46269202.html,/zend-studio-tutorial/.2010-5-4(In Chinese)

[5]Xu Baomin.Programming Fundamentals and Applications Examples on PHP. Beijing:Posts and Telecom Press,2001(In Chinese).

[6]Leon Atkinson.PHP Core Programming.Beijing:Tsinghua university press, 2000(In Chinese).

[7]Ashish Daniel Wilfred.PHP professional development project examples.Beijing: China WaterPower Press,2003.(In Chinese).

[8]UTF8Chinese Messy Code in the phpMyAdmin.

https://www.wendangku.net/doc/d46269202.html,/?p=289.2010-5-4.(In Chinese).