## 連接 MySQL 在我們訪問 MySQL 數據庫前，我們需要先連接到數據庫服務器： ### MySQLi - 面向對象 ```php $servername = "localhost"; $username = "username"; $password = "password"; // 創建連接 $conn = new mysqli($servername, $username, $password); // 檢測連接 if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ``` ### MySQLi - 面向過程 ```php $servername = "localhost"; $username = "username"; $password = "password"; // 創建連接 $conn = mysqli_connect($servername, $username, $password); // 檢測連接 if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully"; ``` ### OOP ```php $servername = "localhost"; $username = "username"; $password = "password"; try { $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password); echo "Connected successfully"; } catch(PDOException $e){ echo $e->getMessage(); } ```