connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully to MySQL database: " . $database; // 查詢測試 $sql = "SHOW TABLES"; $result = $conn->query($sql); if ($result) { echo "
Tables in database:"; while ($row = $result->fetch_array()) { echo "
- " . $row[0]; } } else { echo "
Error retrieving tables: " . $conn->error; } // 關閉連接 $conn->close(); // echo phpinfo(); echo $_SERVER['REMOTE_ADDR']; die(); if ($_SERVER['REMOTE_ADDR']!=='61.222.27.93'){ die(); // echo $password; } $servername = "mysql"; // Docker Compose 中 MySQL 容器的名稱 $username = 'root'; $password = 'Voc]!!J.~2o%DM,i3M#>u'; // 使用環境變數，默認為 'password' $database = 'aiacademy_tw'; // 使用環境變數，默認為 'my_database' if ($_SERVER['REMOTE_ADDR']=='61.222.27.93'){ // echo $password; } echo $username ."
"; // 建立連接 // $conn = new mysqli($servername, $username, $password, $database); $conn = new mysqli($servername, $username, $password, $database); // 檢查連接是否成功 if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully to MySQL database: " . $database; // 查詢測試 $sql = "SHOW TABLES"; $result = $conn->query($sql); if ($result) { echo "
Tables in database:"; while ($row = $result->fetch_array()) { echo "
- " . $row[0]; } } else { echo "
Error retrieving tables: " . $conn->error; } // 關閉連接 $conn->close(); // echo phpinfo(); // echo $_SERVER['REMOTE_ADDR']; ?>