基于PHP和MySQL的網(wǎng)站設(shè)計外文資料

1、Design and Implementation of the Website Based onPHP & MYSQLAbstractPHP 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

2、 .KeywordsPHP; MYSQL; Development and. Implementation1. INTRODUCTIONWith 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

3、 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 and. Net commercial software. Because PHP and MYSQL is free, open source and so on, they are noted

4、for IT professionals. From the perspective of website traffic, more than 70% 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. Section 1 analyzes developm

5、ent environment. In Section 2, we proposed the development model based on PHP. Then case study in Section 4. we make conclusion In Section 5.2. DEVELOPMENT ENVIRONMENT ANALYSISA. The Choice of Development LanguageASP.NET, PHP & JSP are three mainstream languages of the website development, which

6、 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 ASP.NET and JSP. Strong supp

7、orting. 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 ser

8、ver 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 op

9、en, PHP will continue todevelop rapidly.B. Build Development EnvironmentAt 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 re

10、lated 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

11、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 rem

12、ote 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 EnvironmentThose who are unfamilia

13、r 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

14、the server. Now PHP mainly has two editions (PHP4 and 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. I

15、f 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 w

16、elcomed 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 t

17、he 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 PHPPHP becomes the main development language in the small and medium-sized enterprise website for it is free, open source, etc.

18、 The development step is as follows: A.Demand analysisThere 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 succes

19、sor 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:

20、 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 designThe demand report will be organized as some modules according to the principles of high cohesion and l

21、ow coupling and related experience by the website developers.C. Database design and implementationIt 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 attentio

22、n 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

23、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 dif

24、ferent 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 us

25、er 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 Apac

26、he, 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 connected8.D. The Functional Mod

27、ule ImplementationA 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 STUDYThe authors developed the consult website (ZhuoQi, domain name address is

28、 ) 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 modul

29、es.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 i

30、s 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 predeterm