在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 "连接成功!";

?>

```

请确保替换示例代码中的数据库连接信息(如主机名、用户名、密码和数据库名)为您自己的信息。

点赞(0) 打赏

微信小程序

微信扫一扫体验

微信公众账号

微信扫一扫加关注

发表
评论
返回
顶部