在PHP中,可以使用mysqli或PDO扩展来连接MySQL数据库。
使用mysqli扩展连接MySQL数据库需要以下步骤:
<?php
$host = 'localhost';
$user = 'root';
$password = 'password';
$database = 'mydatabase';
$mysqli = new mysqli($host, $user, $password, $database);
if ($mysqli->connect_error) {
die('Connect Error (' . $mysqli->connect_errno . ') '
. $mysqli->connect_error);
}
echo 'Connected successfully.';
$mysqli->close();
?>
使用PDO扩展连接MySQL数据库需要以下步骤:
<?php
$dsn = 'mysql:host=localhost;dbname=mydatabase';
$user = 'root';
$password = 'password';
try {
$pdo = new PDO($dsn, $user, $password);
echo 'Connected successfully.';
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
$pdo = null;
?>