《最新php毕业设计外文翻译.doc》由会员分享，可在线阅读，更多相关《最新php毕业设计外文翻译.doc（60页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、Four short words sum up what has lifted most successful individuals above the crowd: a little bit more.-author-datephp毕业设计外文翻译php毕业设计外文翻译原文：Getting PHP to Talk to MySQlNow that youre comfortable using the MySQL client tools to manipulate data in the database, you can begin using PHP to display and m
2、odify data from the database. PHP has standard functions for working with the database.First, were going to discuss PHPs built-in database functions. Well also show you how to use the The PHP Extension and Application Repository (PEAR) databasefunctions that provide the ability to use the same funct
3、ions 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 byremoving any nonessential parts of the interaction, allowing you to concentrate on the important parts. PEARs D
4、B 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 w
5、ith generic ones that know how to talk to many databases. For example, the MySQL-specific connect function is:mysql_connect($db_host, $db_username, $db_password);versus PEARs DB connect function:$connection = DB:connect(mysql:/$db_username:$db_password$db_host/$db_database);The same basic informatio
6、n 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 other supported databases. Well discuss both connection methods in detail.In this chapter, youll learn how to connect to a MySQL server fromPHP, how to use PHP t
7、o access and retrieve stored data, and how to correctly display information to the user.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.
8、Display the results.Well walk through each of these steps for both plain PHP and PEAR functions.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 connecti
9、on. The other resource is the results resource. It contains all information required to retrieve results from an active database querys result set. Youll be creating and assigning both resources in this chapter.Querying the Database with PHP FunctionsIn this section, we introduce how to connect to a
10、 MySQL database with PHP. Its quite simple, and well 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 connectingto the database for you
11、, and it allows you to start performing queries and gathering data immediately.As in Chapter 8, well 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 yo
12、ur database using the MySQL command-line client.Figure 9-1 shows how the steps of the database interaction relate to the two types of resources. Building the SELECT statement happens before the third function call, but it is not shown. Its done with plain PHP code, not a MySQL-specific PHP function.
13、Figure 9-1. The interaction between functions and resources when using the databaseIncluding Database Login DetailsYoure 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
14、 only one place that you need to change it, regardless of how manyPHP files you have that access the database.You dont 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.T
15、roubleshooting connection errorsOne error you may get is:Fatal error: Call to undefined function mysql_connect( ) in C:Program FilesApacheSoftware FoundationApache2.2htdocsdb_test.php on line 4This error occurs because PHP 5.x for Windows was downloaded, and MySQL support was not included by default
16、. 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:WINDOWSphp.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
17、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 editor to check whether the lines are already there and just need to be uncommented, or whether they need to be added completely.Youll need to rest
18、art Apache, and then MySQL support will be enabled.Selecting the DatabaseNow that youre 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 dont specify the database
19、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: . mysql_error( );Again, its good practice to check for an error and display it every time you access the database.No
20、w that youve got a good database connection, youre ready to execute your SQL query.Building the SQL SELECT QueryBuilding a SQL query is as easy as setting a variable to the string that is your SQL query. Of course, youll need to use a valid SQL query, or MySQL returns with an error when you execute
21、the query. The variable name $query is used since the name reflects its purpose, but you can choose anything youd like for a variable name. The SQL query in this example is SELECT * FROM books.You can build up your query in parts using the string concatenate (.) operator:Executing the QueryTo have t
22、he database execute the query, use the mysql_query function. It takes two parametersthe query and, optionally, the database linkand 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 mak
23、e 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.
24、To display them, you process each row, one at a time.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 q
25、uery 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_row2 accesses the second attr
26、ibute (as defined in the querys column order or the column order of the table if SELECT * is used) in the result row.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 t
27、he 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 arr
28、ay with both types. The mysql_fetch_assoc is an alternative to supplying the MYSQL_ASSOC argument.Closing the ConnectionAs a rule of thumb, you always want to close a connection to a database when youredone using it. Closing a database with mysql_close will tell PHP and MySQL that you no longer will
29、 be using the connection, and will free any resources and memory allocated to it:mysql_close($connection)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 youre running
30、 PHP 4.3.0 or newer, its already installed. If yourerunning PHP 5.0, PEAR has been split out into a separate package. The DB package that youre interested in is optional but installed by default with the Package Manager. So if you have the Package Manager, youre all set.UnixYou can install the Packa
31、ge Manager on a Unix systemby executing the followingfrom the shell (command-line) prompt:lynx -source http:/go-pear.org/ | phpThis takes the output of the go-pear.org site (which is actually the source PHP code) to install PEAR and passes it along to the php command for execution.WindowsThe PHP 5 i
32、nstallation includes the PEAR installation script as C:phpgo-pear.bat. In case you didnt install all the files in Chapter 2, go ahead and extract all the PHP files to C:/php from the command prompt, and execute the .bat file.Creating a connect instanceThe DB.php file defines a class of type DB. Refe
33、r to Chapter 5 for more information on working with classes and objects. Well principally be calling the methods in the class. The DB class has a connect method, which well use instead of our old connect function, mysql_connect. The double colons (:) indicate that were calling that function from the
34、 class in line 4:$connection = DB:connect(mysql:/$db_username:$db_password$db_host/$db_database);When you call the connect function, it creates a new database connection that is stored in the variable $connection. The connect function attempts to connect to the database based on the connect string y
35、ou passed to it.Connect stringThe connect string uses this new format to represent the login information that you already supplied in separate fields:dbtype:/username:passwordhost/databaseThis format may look familiar to you, as its very similar to the connect string for a Windows file share. The fi
36、rst part of the string is what really sets the PEAR functions apart fromthe plain PHP. The phptype field specifies the type of database to connect. Supported databases include ibase, msql, mssql, mysql, oci8, odbc, pgsql, and sybase. All thats required for your PHP page to work with a different type
37、 of database is changing the phptype!The username, password, host, and database should be familiar from the basic PHP connect. Only the type of connection is required. However, youll usually want to specify all fields.After the values from db_login.php are included, the connect string looks like the
38、 following:mysql:/test:testlocalhost/testIf the connect method on line 6 was successful, a DB object is created. It contains the methods to access the database as well as all of the information about the state of that database connection.QueryingOne of the methods it contains is called query. The qu
39、ery method works just like PHPs query function in that it takes a SQL statement. The difference is that the arrow syntax (-) is used to call it fromthe object. It also returns the results as another object instead of a result set:$query = SELECT * FROM books$result = $connection-query($query);Based
40、on the SQL query, this code calls the query function fromthe connectionobject and returns a result object named $result.FetchingLine 22 uses the result object to call the fetchRow method. It returns the rows one at a time, similar to mysql_fetch_row:while ($result_row = $result-fetchRow( ) echo Titl
41、e: .$result_row1 . ;echo Author: .$result_row4 . ;echo Pages: .$result_row2 . ;Use another while loop to go through each row from fetchRow until it returns FALSE. The code in the loop hasnt changed from the non-PEAR example.ClosingYoure finished with the database connection, so close it using the ob
42、ject method disconnect:$connection-disconnect( );PEAR error reportingThe function DB:isError will check to see whether the result thats been returned to you is an error. If it is an error, you can use DB:errorMessage to return a text description of the error that was generated. You need to pass DB:e
43、rrorMessage, the return value from your function, as an argument.Here you rewrite the PEAR code to use error checking:query( $sql)echo DB:errorMessage($demoResult); elsewhile ($demoRow = $demoResult-fetchRow( )echo $demoRow2 . ;?Theres also a new version of the PEAR database interface called PEAR:MD
44、B2. The same results display, but there are more functions available in this version of the PEAR database abstraction layer.Now that you have a good handle on connecting to the database and the various functions of PEAR。译文：通过PHP访问MySQL现在你已经可以熟练地使用MySQL客户端软件来操作数据库里的数据，我们也可以开始学习如何使用PHP来显示和修改数据库里的数据了。P
45、HP有标准的函数用来操作数据库。我们首先学习PHP内建的数据库函数，然后会学习PHP扩展和应用程序库（PEAR，PHP Extension and Application Repository ）中的数据库函数，我们可以使用这些函数操作所有支持的数据库。这种灵活性源自于抽象。对于编程接口而言，抽象简化了复杂的交互过程。它将交互过程中无关紧要的部分屏蔽起来，让你关注于重要的部分。PEAR的DB类就是这样一种数据库接口的抽象。你登录一个数据库所需要提供的信息被减少到最少。这种标准的格式可以通过同一个函数来访问MySQL以及其他的数据库。同样，一些MySQL特定的函数被更一般的、可以用在很多数据库上
46、的函数所替代。比如，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或者其他支持的数据库。我们会详细讨论这两种连接方式。本章中，我们会学习如何从PHP连接到MySQL的服务器，如何使用PHP访问数据库中存储的数据，以
47、及如何正确的向用户显示信息。步骤无论是通过MySQL命令行工具，还是通过PHP，执行一个查询的基本步骤都是一样的： 连接到数据库 选择要使用的数据库 创建SELECT语句 执行查询 显示结果我们将逐一介绍如何用PHP和PEAR的函数完成上面的每一步。资源当连接到MySQL数据库的时候，你会使用到两个新的资源。第一个是连接的标识符，它记录了一个活动连接用来连接到数据库所必需的所有信息。另外一个资源是结果资源，它包含了用来从一个有效的数据库查询结果中取出结果所需要的所有信息。本章中我们会创建并使用这两种资源。使用PHP函数查询数据库本节我们会介绍如何使用PHP连接MySQL数据库。这非常简单，我们会用一些例子说明。但是之前我们应该稍微了解一下幕后发生的事情。当你试图连接一个MySQL数据库的时候，MySQL服务器会根据你的用户名和密码进行身份认证。PHP为你建立数据库的连接，你可以立即开始查询并得到结果。我们需要同样的信息来连接数据库： 数据库服务器的IP地址 数据库的名字 用户名 密码在开始之前，首先使用MySQL的命令行客户端确认你登录到数据库。图9-1显