在PHP中连接数据库通常有以下几种方法:
使用MySQLi扩展
```php
<?php
$servername = "localhost";
$username = "root";
$password = "your_password";
$dbname = "your_database";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
echo "连接成功!";
// 执行数据库操作...
// 关闭连接
$conn->close();
?>
```
使用PDO扩展
```php
<?php
$servername = "localhost";
$username = "root";
$password = "your_password";
$dbname = "your_database";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// 设置 PDO 错误模式为异常
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "连接成功!";
// 执行数据库操作...
} catch(PDOException $e) {
echo "连接失败: " . $e->getMessage();
}
// 关闭连接
$conn = null;
?>
```
连接其他数据库
SQLite:
```php
<?php
$db = new PDO('sqlite:example.db');
echo "连接成功!";
?>
```
PostgreSQL:
```php
<?php
$db = new PDO('pgsql:host=localhost;dbname=testdb', 'username', 'password');
echo "连接成功!";
?>
```
Microsoft SQL Server:
```php
<?php
$serverName = "localhost";
$connectionOptions = array(
"Database" => "your_database",
"Uid" => "your_username",
"PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);
if (!$conn) {
die(print_r(sqlsrv_errors(), true));
}
echo "连接成功!";
?>
```
请确保替换示例代码中的数据库连接信息(如主机名、用户名、密码和数据库名)为您自己的信息。