The free MySQL Database is very often used with PHP.
PHP经常与MySQL数据库搭配使用。

Connecting to a MySQL Database
连接MySQL数据库的方法

Before you can access and work with data in a database, you must create a connection to the database.
在你访问和运行数据库中的数据时，你首先必须与数据库建立一个连接。

In PHP, this is done with the mysql_connect() function.
在PHP中，我们使用mysql_connect()函数来建立连接。

Syntax
语法

mysql_connect(servername,username,password);

Note: There are more available parameters, but the ones listed above are the most important. Visit our full PHP MySQL Reference for more details.
注意：上面列举的项都是非常关键的。下面列举一些其它可使用的参数。具体请访问我们的PHP MySQL 参数。

Example
案例

In the following example we store the connection in a variable ($con) for later use in the script. The "die" part will be executed if the connection fails:
下面的案例当中，我们将数据库的连接保存在一个变量($con)中，目的是为了今后对脚本的使用；如果这个连接失败，那么将执行"die"中的内容：

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con) { die('Could not connect: ' . mysql_error()); }

// some code

?>

Closing a Connection
关闭一个连接

The connection will be closed as soon as the script ends. To close the connection before, use the mysql_close() function.
当脚本结束时，连接自动关闭。我们使用mysql_close()函数来关闭连接，具体如下：

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con) { die('Could not connect: ' . mysql_error()); }

// some code

mysql_close($con);
?>

MySQL 介绍 创建 MySQL

评论 (0) All