一、MySQLi – 面向对象
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | <?php $servername = "localhost"; $username = "username"; $password = "password"; // 创建连接 $conn = new mysqli($servername, $username, $password); // 检测连接 if ($conn->connect_error) { die("连接失败: " . $conn->connect_error); } echo "连接成功"; ?> |
*注:连接在脚本执行完后会自动关闭,也可如下代码
1 | $conn->close(); |
二、MySQLi – 面向过程
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | <?php $servername = "localhost"; $username = "username"; $password = "password"; // 创建连接 $conn = mysqli_connect($servername, $username, $password); // 检测连接 if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "连接成功"; ?> |
*注:连接在脚本执行完后会自动关闭,也可如下代码
1 | mysqli_close($conn); |
三、PDO
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | <?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(); } ?> |
*注:连接在脚本执行完后会自动关闭,也可如下代码
1 | $conn = null; |