展开全部
php连接62616964757a686964616fe78988e69d8331333361326236mysql 分为面向过程和面向对象的。
以下三种方式都可以连接
一 MySQLi - 面向对象<?php
$servername = "localhost";
$username = "username";
$password = "password";
// 创建连接$conn = new mysqli($servername, $username, $password);
// 检测连接if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);} echo "连接成功";
?>
二 MySQLi - 面向过程<?php
$servername = "localhost";
$username = "username";
$password = "password";
// 创建连接$conn = mysqli_connect($servername, $username, $password);
// 检测连接if (!$conn) {
die("Connection failed: " . mysqli_connect_error());}echo "连接成功";
?>
三 PDO方式<?php
$servername = "localhost";
$username = "username";
$password = "password";
try {
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
echo "连接成功";
}catch(PDOException $e){
echo $e->getMessage();
}
?>
连接在脚本执行完后会自动关闭。你也可以使用以下代码来关闭连接:
MySQLi - 面向对象
$conn->close();
MySQLi - 面向过程
mysqli_close($conn);
PDO
$conn = null;