下载文档原格式
摘要 (1)前言 (2)第一章软件介绍 (2)1.1 PHP与MySQL简述 (3)1.2 服务器选择 (7)第二章系统安装与配置 (7)2.1 软件下载 (7)2.2 在Windows上安装Apache和PHP (10)2.3 在Windows上安装并配置MySQL (11)第三章 PHP动态网页设计 (13)3.1 网页要实现的功能 (13)3.2系统的设计和实施方案 (13)第四章 MYSQL数据库设计 (20)4.1 MySQL的SQL命令 (20)4.2 创建一个数据库表 (23)第五章 PHP与MYSQL动态连接 (24)5.1 连接和关闭数据库 (24)5.2 操作MySQL数据库 (25)5.3 PHP对数据表的操作 (28)5.4 PHP对数据表记录的操作 (29)5.5 实现主页和数据库的连接 (30)第六章结论 (31)摘要随着Web 技术的发展，越来越多的网站提供个性化和动态内容，传统的静态网页逐渐被交互式、开放式、甚至并行分布式的基于数据库的动态网页取代，以便增加更多的交互，满足用户更高的需求。
动态网页是指用户将HTTP 请求发送到一个可执行应用程序而不是一个静态的HTML 文件。
服务器将运行该程序以对用户响应，并将处理结果返回客户端，或者对数据记录进行更新。
目前，动态网页开发技术主要有ASP、、PHP和JSP，为用户开发动态网页，发布实时和交互式信息提供有力的支持。
本文涉及了PHP、MySQL 与Apache的下载，安装和配置。
并用其技术设计了一个监测网页，实现对一个点的电压、电流及功率的监测。
关键字：静态网页数据库动态网页服务器 PHP MySQL ApacheAbstractWith the development of Web technology, more and more sites provide personalized and dynamic content. The traditional static Web pages are replaced by interactive, open, and even distributed parallel dynamic web pages based database gradually in order to increase more interactive to meet the higher needs of the user. Dynamic Web pages means that the HTTP is requested to sent to an executable application instead of a static HTML file. The server would either run the program as response and return the results,or update the data records. Currently, the key development technologies of dynamic web include ASP, , PHP andJSP,strongly support users to develop dynamic Web pages, publish real-time and interactive information. This article deals with the download, install and configure of PHP, MySQL and Apache. And use its technology to design a monitoring web page to achieve the monitoring the voltage, current and power of a point.Key words: static web pages database dynamic web pages server PHP MySQL Apache前言PHP语法简单非常易学易用，很利于快速开发各种功能不同的定制网站。
基于PHP+MySQL 的网站开发2009年第31卷第6期总第180期物流工程与管理LOGISTICS ENGINEERING AND MANAGEMENT□肖维明（广州市信息工程职业学校，广东广州510610）【摘要】PHP 是一种跨平台的开放源代码的服务器端嵌入式脚本语言，利用PHP ，我们可以轻松地进行Web 开发，轻松地制作动态网站、新闻系统等；轻松地实现对文件及文件夹的操作；轻松地进行电子商务网站的开发、数据的加密；与数据库相关联等等。
文中将介绍常见的建立PHP+MySQL 运行环境的方法以及如何在PHP 中调用MySQL 存储过程和函数，并结合实例，谈谈基于PHP+MySQL 的网站开发。
【关键词】PHP ；MySQL ；网站开发【中图分类号】TP393【文献标识码】B【文章编号】1674-4993(2009)06-0090-03Website Development Based on PHP+MySQL□XIAO Wei-ming（GuangZhou Information Engineering Vocation School Guangzhou 510610，China ）【Abstract 】PHP is an open source cross-platform server-side embedded scripting language,we can easily implement Web development and make dynamic sitenews systems with it,besids that,PHP can be easily used in the operation of document and folder,the development of e-commerce and data encryption as well as associated with the database,and so on.This article intro －duces the establishment of common running MySQL +PHP environment and how to call php in the MySQL stored procedures and functions,combined with examples like the PHP +MySQL-based web site development.【Key words 】PHP;MySQL;website development 【收稿日期】2009-05-17【作者简介】肖维明（1964－），男，汉族，广东梅县人，大学本科，广州市信息工程职业学校计算机讲师，研究方向：计算机专业课程教学方法，计算机网络管理技术、方法和实施。
1引言在信息时代，用户通过互联网可以在短时间内获取更多的资源，并且获取过程较为简单快速。
用户在互联网获取信息的过程，全部是在网站中进行，提高网站搜索信息以及向用户提供信息服务的能力，需要在网站设计中应用PHP技术和MySQL技术，既能使网站运行更加稳定，还能降低网站运行成本。
2网站设计现阶段网站设计会广泛使用PHP技术，PHP技术具有开源校本语言的特点，一方面可以融合多种计算机运行语言，包括C语言、Java语言等，使计算机运行具有多元化特点，另一方面使Web应用系统在网站中保持运动变化状态，根据用户需求在网站快速进行操作。
由于互联网中网站数量不断增加，网站可以具备多种功能，在全球经济背景下，网络成为各个国家合作与经济发展的主要途径，在我国电子商务发展不断成熟，为用户提供相应的需求。
许多企业以网站为出发点，积极参与到电子商务发展中，其中Web应用系统的建立，用户通过Web应用系统可以获取更多的信息，同时借助Web应用系统与更多的用户建立关系，实现不同地区用户在虚拟的环境开展交流与合作。
在Web应用系统运行过程中，提高应用系统的交互能力，需要在网站中加入具备交互能力的文本，同时交互能力的文本可以在网站上提供分页信息，使用户获取信息的过程更加便利。
使用PHP技术设计网站时，要求设计人员应按照流程进行操作，并且确定网站设计的目标，使网站体现出鲜明的使用功能，如销售功能、阅读功能以及服务功能等。
设计人员应根据用户需求，合理应用PHP技术开展设计工作。
进入设计环节，设计人员应在网页进行排版，排版内容需要与网站具备的功能相匹配，要求排版过程中将文字、颜色以及内容等建立协调的关系，使用户在网站中借助导航即可查询相应的信息。
PHP技术作为一种公开源代码，设计人员应用PHP技术，可以将HTML文件加载至网站中，然后根据网站要求，在网站建立的系统中设置多个接口，使相应的编程连接至网站中，提高网站的服务能力，增强用户与网站的互动性，让用户在网站中可以快速找到相应的信息。
php毕业设计外文翻译--通过PHP访问MySQLGetting PHP to Talk to MySQLOnce you are familiar with using MySQL client tools to manipulate data in the database。
you can start using PHP to display and modify data from the database。
PHP has standard ns for working with databases。
In this article。
we will discuss PHP's built-in database ns and how to use the PHP n and n Repository (PEAR) database.PHP'XXXPHP has several built-in XXX are easy to use and allow you to connect to a database。
execute queries。
and retrieve data。
Some of the most commonly used XXX:mysqli_connect() - This n is used to connect to a MySQL database.mysqli_query() - This n is used to execute a query on the database.mysqli_fetch_array() - This n is used to retrieve data from a query result.Using PEAR DatabasePEAR is a repository of PHP ns and ns。
It includes a database package that provides a set of classes for working with databases。
原文：Getting PHP to Talk to MySQlNow that you’re comfortable using the MySQL client tools to manipulate data in the database, you can begin using PHP to display and modify data from the database. PHP has standard functions for working with the databas e.First, we’re going to discuss PHP’s built-in database functions. We’ll also show you how to use the The PHP Extension and Application Repository (PEAR) databasefunctions that provide the ability to use the same functions to access any supported database. This type of flexibility comes from a process called abstraction. In programming interfaces, abstraction simplifies a complex interaction. It works by removing any nonessential parts of the interaction, allowing you to concentrate on the important pa rts. PEAR’s DB classes are one such database interface abstraction. The information you need to log into a database is reduced to the bare minimum. This standard format allows you to interact with MySQL, as well as other databases using the same functions. Similarly, other MySQL-specific functions are replaced with generic ones that know how to talk to many databases. For example, theMySQL-specific connect function is:mysql_connect($db_host, $db_username, $db_password);versus PEAR’s DB connect function:$connection =DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");The same basic information is present in both commands, but the PEAR function also specifies the type of databases to which to connect. You can connect to MySQL or o ther supported databases. We’ll discuss both connection methods in detail.In this chapter, you’ll learn how to connect to a MySQL server fromPHP, how to use PHP to access and retrieve stored data, and how to correctly display information to the user.1 The ProcessThe basic steps of performing a query, whether using the mysql command-line tool or PHP, are the same:• Connect to the database.• Select the database to use.• Build a SELECT statement.• Perform the query.• Display the results.We’l l walk through each of these steps for both plain PHP and PEAR functions.2 ResourcesWhen connecting to a MySQL database, you will use two new resources. The first is the link identifier that holds all of the information necessary to connect to the database for an active connection. The other resource is the results resource. It contains all information required to retrieve results from an active database query’s result set. You’ll be creating and assigning both resources in this chapter.3 Querying the Database with PHP FunctionsIn this section, we introduce how to connect to a MySQL database with PHP. It’s quite simple, and we’ll begin shortly with examples, but we should talk briefly about what actually happens. When you try connecting to a MySQL database, the MySQL server authenticates you based on your username and password. PHP handles connecting to the database for you, and it allows you to start performing queries and gathering data immediately.As in Chapter 8, we’ll need the same pieces of information to connect to the database: • The IP address of the database server• The name of the database• The username• The passwordBefore moving on, make sure you can log into your database using the MySQL command-line client.4 Including Database Login DetailsYou’re going to create a file to hold the information for logging into MySQL. Storing this information in a file you include is recommended. If you change the database password, there is only one place that you need to change it, regardless of how many PHP files you have that access the database.You don’t have to worry about anyone directly viewing the file and getting your database login details. The file, if requested by itself, is processed as a PHP file and returns a blank page.5 Troubleshooting connection errorsOne error you may get is:Fatal error: Call to undefined functionmysql_connect( ) in C:\Program Files\ApacheSoftware Foundation\Apache2.2\htdocs\db_test.php on line 4This error occurs because PHP 5.x for Windows was downloaded, and MySQL support was not included by default. To fix this error, copy the php_mysql.dll file from the ext/ directory of the PHP ZIP file to C:\php, and then C:\WINDOWS\php.ini.Make sure there are two lines that are not commented out by a semicolon (;) at the beginning of the line like these:extension_dir = "c:/PHP/ext/"extension=php_mysql.dllThis will change the extension to include the directory to C:/php and include the MySQL extension, respectively. You can use the Search function of your text editorto check whether the lines are already there and just need to be uncommented, or whether they need to be added completely.You’ll need to restart Apache, and then MySQL support will be enabled.6 Selecting the DatabaseNow th at you’re connected, the next step is to select which database to use with the mysql_select_db command. It takes two parameters: the database name and,optionally, the database connection. If you don’t specify the database connection, the default is the connection from the last mysql_connect:// Select the database$db_select=mysql_select_db($db_database);if (!$db_select){die ("Could not select the database: <br />". mysql_error( ));}Again, it’s good practice to check for an error and display it every time you access the database.Now that you’ve got a good database connection, you’re ready to execute your SQL query.7 Building the SQL SELECT QueryBuilding a SQL query is as easy as setting a variable to the string that is your SQL query. Of co urse, you’ll need to use a valid SQL query, or MySQL returns with an error when you execute the query. The variable name $query is used since the name reflects its purpose, but you can choose anything you’d like for a variable name. The SQL query in this example is SELECT * FROM books.8 Executing the QueryTo have the database execute the query, use the mysql_query function. It takes two parameters—the query and, optionally, the database link—and returns the result. Save a link to the results in a variable called, you guessed it, $result! This is also a good place to check the return code from mysql_query to make sure that there were no errors in the query string or the database connection by verifying that $result is not FALSE:When the database executes the query, all of the results forma result set. These results correspond to the rows that you saw upon doing a query using the mysql command-line client. To display them, you process each row, one at a time.9 Fetching and DisplayingUse mysql_fetch_row to get the rows from the result set. Its syntax is:array mysql_fetch_row ( resource $result);It takes the result you stored in $result fromthe query as a parameter. It returns one row at a time from the query until there are no more rows, and then it returns FALSE. Therefore, you do a loop on the result of mysql_fetch_row and define some code to display each row:The columns of the result row are stored in the array and can be accessed one at a time. The variable $result_row accesses the second attribute (as defined in the query’s column order or the column order of the table if SELECT * is used) in the result row.10 Fetch typesThis is not the only way to fetch the results. Using mysql_fetch_array, PHP can place the results into an array in one step. It takes a result as its first parameter, and the way to bind the results as an optional second parameter. If MYSQL_ASSOC is specified, the results are indexed in an array based on their column names in the query. If MYSQL_NUM is specified, then the number starting at zero accesses the results. The default value, MYSQL_BOTH, returns a result array with both types. Themysql_fetch_assoc is an alternative to supplying the MYSQL_ASSOC argument.11 Closing the ConnectionAs a rule of thumb, you always want to close a connection to a database when you’redone using it. Closing a database with mysql_close will tell PHP and MySQL that you no longer will be using the connection, and will free any resources and memory allocated to it:mysql_close($connection)12 InstallingPEAR uses a Package Manager that oversees which PEAR features you install.Whether you need to install the Package Manager depends on which version of PHP you installed. If you’re running PHP 4.3.0 or newer, it’s already installed. If you’rerunning PHP 5.0, PEAR has been split out into a separate package. The DBpackage that you’re interested in is optional but installed by default with the Package Manager. So if you have the Package Manager, you’re all set.译文：通过PHP访问MySQL现在你已经可以熟练地使用MySQL客户端软件来操作数据库里的数据，我们也可以开始学习如何使用PHP来显示和修改数据库里的数据了。
基于PHPMySQL的网站开发在开始基于PHPMySQL的网站开发之前，首先需要准备一个支持PHP 和MySQL的环境。
可以通过安装本地开发环境或使用云服务器来满足这些要求。
在Windows、Mac和Linux系统上都有相应的PHP和MySQL 安装包可供选择。
在基于PHPMySQL的网站开发中，数据库是至关重要的一部分。
根据网站的需求，设计合理的数据库表结构，并创建相应的表。
例如，如果开发一个博客网站，可能需要创建“文章”、“评论”、“用户”等表。
使用MySQL的SQL语言来定义这些表，包括定义字段、数据类型、约束等。
在PHP中，可以使用MySQL扩展或者PDO（PHP数据对象）来连接MySQL 数据库。
通过提供数据库的主机名、用户名、密码和数据库名称，可以建立与MySQL数据库的连接。
连接成功后，可以使用返回的数据库连接对象来执行SQL查询和操作数据库。
使用SQL语句查询数据库是常见的操作之一。
通过使用SELECT语句，可以获取数据库表中的数据。
例如，以下是一个使用PHP连接到MySQL 并执行SELECT查询的示例代码：$servername = "localhost";$username = "your_username";$password = "your_password";$dbname = "your_database";$conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) {die("连接失败: ". $conn->connect_error);$sql = "SELECT * FROM your_table";$result = $conn->query($sql);if ($result->num_rows > 0) {while($row = $result->fetch_assoc()) {echo "字段1：". $row["column1"]. " -字段2：". $row["column2"]. "<br>";除了查询数据之外，插入和更新数据也是基于PHPMySQL的网站开发中的常见操作。
基于PHP和MySQL技术的高校网站的设计与实现李子龙发布时间：2021-08-23T06:10:41.768Z 来源：《现代电信科技》2021年第8期作者：李子龙李爽[导读] 随着互联网进入2.0时代，网站做为网络信息的主要载体，越来越多的出现在网络环境中。
本文以本文以PHP和MySQL两种技术作为立足点，论述在高校网站中的应用进行设计与实现，并提出意见。
（长春财经学院吉林长春 130122）摘要：随着互联网进入2.0时代，网站做为网络信息的主要载体，越来越多的出现在网络环境中。
本文以本文以PHP和MySQL两种技术作为立足点，论述在高校网站中的应用进行设计与实现，并提出意见。
关键词：PHP；MYSQL；校园网；网站开发在当下互联网背景下，计算机网站建设在所有高校几乎都是首要任务，也是实现学校门户品牌建设和招生宣传的有效途经之一。
良好的网站规划与设计是计算机网站建设的首要保障，选用何种开发技术和数据库就是网站建设首要考虑的因素之一。
一、网站架构现行的网站规划会广泛使用HTML作为网站的前端设计语言，而后端逻辑设计则会使用PHP作为主要的开发语言。
PHP语言具有良好的开源校本语言的特点，首先，它融合了很多种计算机语言的编程风格，同时也能够使计算机运行具有更加多元化的特点。
其次，PHP支持面向对象开发，能够在网站开发过程中，融入面向对象开发技术，使用网站开发技术更加灵活。
在网站筹备之处，首先要确定网站的总体设计目标，同时要求前端设计人员参照总体规划制作前端页面，这样才能使网站具备鲜明的特点，突出主题和交互功能。
开发人员应根据用户需要与网站本应该实现的功能，制作功能页面，实现前提设计的功能和栏目规划，合理使用PHP技术进行代码开发工作。
在随后的前端设计环节，设计师应该规范网页排版风格，内容排版应该与网站具备的功能相匹配，同时要求排版风格、字体字号、色彩配色与网站内容之间形成良好的协调关系，使用户在网站浏览过程有非常舒服的用户体验。
“logo XX学院XX UNIVERSITY毕业论文（设计）外文翻译翻译题目：通过PHP访问MySQL _英文题目：Getting PHP to Talk to MySQL姓名__________________学号__________________专业班级__________________指导教师__________________提交日期__________________教务处制通过PHP访问MySQL译文：现在你已经可以熟练地使用MySQL客户端软件来操作数据库里的数据，我们也可以开始学习如何使用PHP来显示和修改数据库里的数据了。
PHP有标准的函数用来操作数据库。
我们首先学习PHP内建的数据库函数，然后会学习PHP扩展和应用程序库（PEAR，PHP Extension and Application Repository ）中的数据库函数，我们可以使用这些函数操作所有支持的数据库。
这种灵活性源自于抽象。
对于编程接口而言，抽象简化了复杂的交互过程。
它将交互过程中无关紧要的部分屏蔽起来，让你关注于重要的部分。
PEAR的DB类就是这样一种数据库接口的抽象。
你登录一个数据库所需要提供的信息被减少到最少。
这种标准的格式可以通过同一个函数来访问MySQL以及其他的数据库。
同样，一些MySQL特定的函数被更一般的、可以用在很多数据库上的函数所替代。
比如，MySQL特定的连接函数是： mysql_connect($db_host, $db_username, $db_password);而PEAR的DB提供的连接函数是：$connection =DB::connect("mysql://$db_username:$db_password@$db_host/$db_database" );两个命令都提供了同样的基本信息，但是PEAR的函数中还指定了要连接的数据库的类型。
你可以连接到MySQL或者其他支持的数据库。
外文翻译题目订单管理系统的设计与实现学生姓名申请学位门类工学学号 ************ 学院信息工程学院专业信息工程校内指导教师职称副教授信息工程学院二○一六年六月MySQL and JSP Web applicationsJSP developers encounter unique problems when building web applications that require intense database connectivity. MySQL and JSP Web Applications addresses the challenges of building data-driven applications based on the JavaServer Pages development model. MySQL and JSP Web Applications begins with an overview of the core technologies required for JSP database development--JavaServer Pages, JDBC, and the database schema. The book then outlines and presents an Internet commerce application that demonstrates concepts such as receiving and processing user input, designing and implementing business rules, and balancing the user load on the server. Through the JDBC (Java DataBase Connector), the developer can communicate with most commercial databases, such as Oracle. The solutions presented in MySQL and JSP Web Applications center on the open source tools MySQL and Tomcat, allowing the reader an affordable way to test applications and experiment with the book's examples.So What Is JSP All About?If you meet the requirements mentioned, you should already have a pretty good idea what the answer to this question is. JSP is all about doing highly object-oriented Web sites that can leverage all the best practices of modern software engineering. These practices include things such as SQL databases and UML-based design. This isn't to say that JSP is a cure-all and that using it will automatically make your Web site a paragon of engineering art. It's just as possible to design bad Web sites in JSP as with any other technology. That's why, as you go through the text, you will see how to incorporate the best practices and how to avoid the pitfalls of convenience when projects get stressful. JSP itself is an evolutionary step along the path that started with the first static Web servers, moved through CGI-enabled servers, and finally the first generation of script-enabled servers. JSP is less a Web server with a Java component than it is a Java engine that understands the Web.JSP grew out of Java servlets. Servlets allow the developer to handle the incoming Web requests using a Java program that has access to all the normal information that a Common Gateway Interface (CGI) program would. In addition, the servlet has access to session-persistentobjects. These are Java objects that are associated with a specific user session and can be used to store state between requests. Servlet programming was a major step forward in allowing developers to write well-structured modular Web applications using an object-oriented language. It also solved the problem of state persistence, allowing more information to reside on the server during a transaction and less to have to pass back and forth between the user and the server. Servlets still suffered from one major problem. Because they eventually need to spit out HTML, the HTML coding had to be embedded in the servlet code. This led to code fragments like the one shown here:Out.println("<HTML>\n<HEAD>\n<TITLE>Thank you forRegistering</TITLE></HEAD>\n");Out.println("<IMG SRC=\"thanks.jpg\" WIDTH=200 HEIGHT=100 ALIGN=\"LEFT\”>");This kind of embedding gets very old very fast when you have to code a lot of pages. In addition, having to escape all of the quotation marks can lead to a lot of confusing and hard-to-find errors if you leave out a backslash. Eventually, a still-better idea emerged. Suppose that you could combine the best of static HTML pages and with the interactive capabilities of servlets. The result was JavaServer Pages (on the Microsoft side, the result was Active Server Pages). As Figure I.1 shows, JSP is a complicated beast. In the next chapter, you'll walk through this flow in detail, but for the moment, here are the major steps:1. A request comes in from a browser using the normal HTTP request format.2. The Web server hands off the request to JSP. JSP looks at the filename and finds the appropriate JSP file.3. The .jsp file is converted into a .java file, containing Java code that will create a class whose name is derived from the .jsp filename.4. JSP then compiles the .java file using javac to produce a .class file. Note that the two previous steps are skipped if a .class file already exists and is newer than the .jsp file.5. An instance of the newly created class is instantiated and sent the _jspService message.6. The new instance looks to see if there is already an instance of the er object called user existing in the session object space for the currently connected user. If not, one is instantiated.7. As part of servicing stuff.jsp, the user instance is called with the getUserName() method.8. If the JSP processing requires access to information in a database, it uses JDBC to make theconnection and handle the SQL requests.As you can see, a tremendous amount of power is available in the JSP world. Developers are free to write Web pages that look mostly like HTML, except where callouts to Java are required. But, at the same time, they are free to develop fully fleshed-out object-oriented applications using all the features that Java can bring to bear. They also get all the benefits of servlets, including session persistence.Why Do We Need Databases?Well, one reason is so that Larry Ellison of Oracle can afford to keep himself on Prozac when he thinks about Bill Gates. A more serious answer is the same reason that drove man to first press a stick against a piece of wet mud: because it's good to write things down. Web servers are marvelous creatures, but they're a bit like idiot savants. Ask them to serve a Web page or run a piece of Java, and they perform like a champ. But start asking them to remember what they did five minutes ago, and they develop amnesia faster than a character in a soap opera.The first and most important reason that you use databases is that there's a lot in an e-commerce transaction that you need to remember and track:•A user's name, address, credit card, and other inf ormation previously entered on a registration page•hat the user might have put into a shopping cart and left from a previous transaction•What items are in stock, along with their price, description, and so on•Orders that need to be fulfilled, orders that have been shipped, and items that have been backordered .Now, you could store all this information in a flat file on the server's hard disk, but there are other important properties that you want to have for this data:•You want to be able to back o ut a transaction if part of it fails.•You want to be able to locate the data somewhere more secure than the Web server, which could be in a DMZ or outside the firewall altogether.•You want to be able to access data such as user data or products quickly, even if there are thousands or millions of them.When you add these items to the shopping list, only a relational database will really do thejob effectively.MySQLMany sites don't need the battleship strength (and price tag) of Oracle. MySQL is an open-source SQL database available for anyone to use, with many (although not all) of the features of its big brothers, such as Oracle.MySQL is available for just about any computer that has decent power—it is fairly lightweight on the processor and easy to install (10 minutes, as opposed to multiple hours for Oracle).So, perhaps you are wondering, what's the catch? What are you not getting in MySQL that makes people turn to Oracle? Well, MySQL is a neat little package, but it is missing some things that would be nice to have in a perfect world.A major feature that MySQL does not offer is database consistency checking. You can use foreign key tags in your schema, but MySQL cheerfully ignores them. A lot of DB As I know would consider this a very bad thing.A foreign key constraint prevents you from creating inconsistent data. For example, let's suppose that you had a scheme that looked like this:CREATE TABLE USER (USERID INTEGER,FIRST_NAME V ARCHAR(80),LAST_NAME V ARCHAR(80));CREATE TABLE PURCHASE (USERID FOREIGN KEY USER(USERID),ITEM INTEGER,QUANTITY INTEGER);In a database such as Oracle's, if you created an entry in the PURCHASE table with a user ID of 3, there would have to already be a user ID of 3 in the USER table or an error would occur. Similarly, you couldn't delete user 3 from USER if it was referenced in PURCHASE.The MySQL folks make a pretty impassioned argument in their documentation that depending on foreign keys for data integrity is a bad idea anyway, but convincing your DBA of this philosophyis likely to degrade into a religious debate.In addition, some other features are missing, such as subselects and select into. But probably the other major piece that you will miss is the rollback/commit functionality. MySQL does implement rollback and commit for certain types of tables, but not all of them. Again, the MySQL folks offer their own spin on why this is okay, but being able to roll back transactions is (in my opinion) important enough to make sure that you have it available.Rollback allows you to set a savepoint on the database before starting to do a series of transactions with it, and be able to either roll back to the original state or commit the changes at the end. For example, when recording a purchase, you need to record a debit against the user's account and enter a record into the shipping table so that you'll know later to ship the item. Let's say that the second part fails. You wouldn't want to charge the user but not ship the item. Thus, you'd want to roll back to the state before the transaction began.So, MySQL isn't a full-blown production database—at least, not yet. It's still good enough for probably 90% of the e-commerce sites in the world, however. And version 4.0, which is in alpha as of this writing, addresses a number of these concerns, including row-level locking and transaction control.Putting Tomcat and MySQL TogetherCombining Tomcat and MySQL provides a powerful, reliable, and free platform that you can use to learn, develop, and deploy JSP applications. And, best of all, the code that you develop using this platform will run nicely using iPlanet and Oracle or WebSphere and SQL Server.As a learning tool the two together are almost "reference implementations" of their respective protocols (JSP and SQL). As a result, you won't pick up any nasty vendor-proprietary bad habits while you're getting up to speed.In addition, you can enjoy the knowledge that you are supporting the open-source software movement. Open-source software is code that is made freely available under one of several public licenses, frequently the GNU General Public License (GPL).Why is it good to support this movement? There are two sides to this answer: one technical and one political. Technically, it's a good thing because open-source softwaretends to encourage the development of open standards such as JSP and JDBC, allowing youto choose your tools from among a larger group rather than being locked into one vendor's proprietary solution. It's a positive thing politically because it keeps the large companies honest. WebLogic and iPlanet have to stay competitive and responsive because they know that there's a free solution out there if they aren't. And when you use open-source software, you are sending a message that your overriding concerns are features and reliability, not having a large company to sue if something goes wrong.MySQL和JSP的Web应用程序JSP开发人员构建Web应用程序时遇到需要强大的数据库连接的特殊问题。
译文二：基于PHP和MYSQL的网站设计和实现摘要PHP和MYSQL因为其免费以及开放源码已经成为主要的web开发工具。
作者就基于PHP和MYSQL开发网站进行开发环境问题的讨论。
关键词PHP;MYSQL;发展和实现。
1.介绍随着网络技术的发展，不可避免的带动各种企业传统营销与网络营销的增长。
其中最有效的方法是为他们的公司建立一个网站。
目前网站开发的主流平台包括LAMP(Linux操作系统，Apache网络服务器，MYSQL数据库，PHP编程语言)，J2EE 和.NET商业软件。
因为PHP和MYSQL是免费的，开源等等，他们是为专业的IT 人士开发的。
从网站流量的角度来看，超过70%的网站流量是有LAMP提供的，这是最流行的网站开发平台。
在本文中，我们基于PHP和MYSQL设计了一个网站。
本文的组织如下。
第一节分析开发环境。
第二节中，我们提出基于PHP的开发模型。
然后，第四节是案例研究。
在第五节我们做出结论。
2.发展环境分析A.开发语言的选择，PHP&JSP是三个主流的网站开发语言，它们分别具有各自的优点和缺点，它们之间的比较见表1。
这个项目我们采用PHP作为开发语言的原因如下：免费的。
这个项目小，不需要使用支付开发平台如 and JSP。
强大的支持。
中小型网站，甚至一些大型网站如百度，新浪都把PHP作为开发语言，可以有组与解决在编程上的问题。
良好的可移植性。
尽管起初只能在Linux和Apache Web服务器环境中开发，现在已经可以移植到任何的操作系统，并兼容标准的Web服务器软件。
简单的语法。
PHP和C编程语言有许多的相似之处，所以会C的程序员很容易的就能使用PHP程序语言。
发展快速。
因为其源代码是开放的，所以PHP能迅速的发展。
B.构建开发环境目前有很多基于PHP的开发平台。
通常大多数开发人员喜欢LAMP开发环境。
那些有一定开发经验的可以通过选择相关的服务器，数据库管理系统和操作系统设置他们的开发平台。
有一些PHP IDE（集成开发环境）如AMPSERV,XMAPP,PHPSTUDY,APPSERV,市场开发人员通过PHP开发网站。
目前主要的PHP IDE是Zend Studio，它包括了PHP的开发组件，在调试，分析和优化时减少了开发时间和简化了复杂的应用程序。
Zend Studio不仅具有高测量代码，语法和书签，而且它的嵌入式调试器适合本地和远程调试模式。
它有很多高级的调试功能，如变量跟踪，单步操作，断点，功能调用等等。
此外，它也非常稳定，在中国支持其最新的版本。
C.指出构建开发环境那些自己不熟悉开发环境并不设置的，可能会引起各种版本之间的冲突，而且很难解决这个复杂的配置问题。
PHP语言版本。
在开发之前，你必须确保PHP语言和服务器版本之间的一致性。
现在主要有两个版本的PHP（PHP4和PHP5）。
不同的版本有不同的会话，异常处理，变量范围，数据类型等等。
服务器问题。
PHP在windows平台上的程序编辑将安排在apache服务器上。
如果是安排在IIS上，它会导致一些不兼容的和一些更新的问题，比如可写的权利是建立在上传文档的。
如果安排在apache服务器上则没有这些问题。
数据库问题。
PHP使用的数据库有MYSQL，ORACLE等等。
MYSQL因为其开源免费和有效率受到大多数开发人员的喜爱。
MYSQL对于中小型应用系统来说是个完美的软件。
除了ANSI SQL，它还支持多种平台。
在Unix和Linix，MYSQL也支持多线程。
MYSQL成为了中小级别PHP 网站的第一选择，因为其开源，它提供了一系列的支持如读写访问。
3.基于PHP的开发模型PHP成为中小型企业网站主要的开发语言，因为它是免费开放源码等。
开发步骤如下：A.需求分析一个网站项目有各种各样的要求。
这些要求往往源于公司自己的需求，其中大部分是客户的实际需求。
项目领导人在最大程度上理解用户的需求决定是否开发网站。
因此用户需求文档的形式可以很明显的转化为开发人员的项目。
这是项目开发的主要问题。
出了基本的用户需求，如下有一些问题需要注意：应该确认需求文档的方式。
通知需求方在可行性和价格要求方面进行有效的分析和讨论。
B.功能模块设计需求报告将根据高内聚低耦合的原则组织一些模块和相关经验的网站开发人员。
C.数据库的设计和实现它包含了需求分析，概念设计，逻辑设计，物理设计，系统实现，操作和维护。
一下问题在数据库设计和实现中应该注意：数据库安全：数据库是网站的核心，数据的安全是非常重要的。
损坏和丢失或非法复制的数据会引起很多麻烦。
而且错误很难恢复。
MYSQL安全措施如下：账号安全：每个账户的MYSQL是有用户名，密码以及位置，包括合理的权利和安全检查。
合理的权利要求有不同权利不同用户和相同用户有不同权利为不同的数据库或数据表。
在MYSQL上有三种不同的安全检查：登记，确认，授权，访问控制。
存储数据加密：对于有大量信息的应用程序，你可以加密很小的一部分，如用户密码。
这些密码不应存储在明文的加密形式，但在数据库中，一般来说，包括MYSQL是通过在大多数数据库管理系统中的敏感数据加密算法。
数据库的字符集和编码：用于web服务器的默认代码，比如apache安装的软件，不是utf-8.我们通常浏览网页输入数据表中的编码是utf-8，但是在中国phpmyadmin会变成乱码。
解决方案是在数据库链接被分配的MYSQL的默认代码转化为utf-8或数据代码（utf-8）。
D.功能模块实现代码，详细的注释和标准化的写作是实现功能模块的要求。
目标是可重用性，可靠性高，效率高，安全等等。
4.案例研究作者开发的咨询网站是基于PHP的（域名地址是http://www,）。
该网站主要包括九个模块，如检索模块、专家咨询模块、维护模块的问题,成员交互模块、问题讨论模块、文件浏览模块、注册模块、帮助模块和其他辅助模块。
每个模块包含大量的功能模块。
例如，在该网站前面的模块主要是检索模块，输入检测模块，匹配搜索模块和显示模块，等返回前面的代码在执行检索模块。
具体的过程是，用户输入相关的检索信息到搜索框。
那么信息将被发送到最终的处理页面后按检索按钮。
输入的信息是通过调用代码检查结束。
如果这是有效的，结果匹配成功，将显示匹配后的信息和数据库中的信息。
5.结论PHP和MYSQL已经成为主要的web开发工具，他是免费的，开源的，具有高可靠性和可移植性。
引用[1] LAMP. /view/365086.htm?fr=ala0_1_1. 4(In Chinese).[2] 郭亮, 高慧.APS和JSP的研究对比.黑龙江科技. 2007,(17):80(In Chinese).[3] 张志敏. , PHP 和 JSP之间的比较分析 . 科学爱好者. 2008,(33):132-133(In Chinese).[4] Zend Studio 5.5.1集成开发环境系列/zend-studio-tutorial/. 2010-5-4(In Chinese)[5] 徐保民. PHP编程基础和应用案例.北京文章电信出版社,2001(In Chinese).[6] 利昂阿特金森. PHP核心编程.北京清华大学出版社, 2000 (In Chinese).[7] Ashish丹尼尔·威尔弗雷德. PHP 专业发展项目案例.北京中国水利出版社, 2003.(In Chinese).[8] 在phpMyAdmin中utf-8乱码. /?p=289. 2010-5-4.(In Chinese).原文二：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 . 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 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 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 development 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 Language, 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 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 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 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 EnvironmentThose 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 (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. If it is arranged on IIS it leads to some incompatible problems and some update by manual such as writable rights isset 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 PHPPHP 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 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 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 designThe 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 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 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 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 / ) 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, inputcheck 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 i nputted 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.CONCLUSIONPHP and MYSQL has been the main web development tool for it is free, open source, high reliability, portability.REFERENCES[1] LAMP. /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 Zhimin. Comparative Analysis between , PHP and JSP . Friend of Science Amateurs. 2008,(33):132-133(In Chinese).[4]Zend Studio 5.5.1 Integrated Development Environment Series. /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]UTF8 Chinese Messy Code in the phpMyAdmin. /?p=289. 2010-5-4.(In Chinese).。
