如何将我的统一项目连接到EC2实例上的mysql服务器

Z时代
2024-01-10
分类：问答

我想从我的MySQL服务器获取数据到我的Unity项目。我试图让像这样的数据：如何将我的统一项目连接到EC2实例上的mysql服务器

public string awsurl = "ec2-174-129-82-141.compute-1.amazonaws.com/connect_to_server.php"; 
IEnumerator GetScores() 
{ 
     print("get scores start"); 
     WWW aws_get = new WWW(awsurl); 
     yield return aws_get; 
     print("getscore here"); 
     if (aws_get.error != null) 
     { 
      print("There was an error getting aws: " + aws_get.error); 
     } 
     else 
     { 
      print(aws_get.text); // this is a GUIText that will display the scores in game. 
     } 
}

我有一个PHP脚本我的服务器来处理，因为我使用的的MySqlConnection库我合一项目有麻烦的互动上。这里是我的PHP脚本：

$address = "localhost" 
$dbusername = "root"; 
$dbpassword = "root"; 
$db_name = "watshoes"; 
$db_conn = new mysqli($address, $dbusername, $dbpassword, $db_name); 
    if(isset($_POST['username'])) $username = $_POST['username']; 
    if(isset($_POST['user_id'])) $user_id = $_POST['user_id']; 
    if(isset($password)) $password =$_POST['password']; 
    $stmt = $db_conn->prepare("SELECT image FROM ImageText"); 
    // "s" means the database expects a string 
    $stmt->bind_param("s", $user_id); 
    if($stmt->execute()) 
    { 
     /* bind result variables */ 
     $stmt->bind_result($image); 
     /* fetch value */ 
     $stmt->fetch(); 
     echo $image; 
    } 
    else 
    { 
     echo "query failed"; 
    } 
    $stmt->close(); 
    $db_conn->close();