MySQL連接 ``` <?php $dbhost = 'localhost'; // mysql服務器主機地址 $dbuser = 'root'; // mysql用戶名 $dbpass = '123456'; // mysql用戶名密碼 $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysqli_error()); } echo '數據庫連接成功！'; mysqli_close($conn); ``` 訪問指定數據庫： ``` <?php $dbhost = '127.0.0.1'; ? ? ?// mysql server ip $dbuser = 'root'; // mysql username $dbpass = '123456'; // mysql password $database = 'test'; // mysql database $port = 3306; // mysql port $conn = mysqli_connect($dbhost, $dbuser, $dbpass, $database, $port); if (!$conn) { die('Failed to connect to MySQL: ' . mysqli\_error($conn)); } echo 'Successfully connected to MySQL'; $db = mysqli_select_db($conn, $database); if (!$db) { die('Failed to access the database: ' . mysqli\_error($conn)); } mysqli\_close($conn); echo 'Successfully accessed the database'; ```