php - 如何在 Android Studio 中连接或链接到本地​​主机服务器地址

Question

我正在按照 youtube 中的 tonakami TV 为 android 进行登录注册的教程，我遇到了 android 应用程序无法通过 LOCALHOST XAMPP 更新或连接到数据库的问题。一个星期以来，我一直在寻找所有可能的解决方案，但一无所获。也许你们可以帮我解决我的 PHP 文件(register.php 和 fetchuserdata.php)的问题，我也发现我的 php 也有这个错误文件:mysqli_connect():(HY000/1044):用户“my_user”@“localhost”对数据库“my_db”的访问被拒绝。我授予所有权限但仍然无法连接，我不知道问题是否来自 PHP 文件、android studio 中的服务器链接或 XAMPP localhost phpmyadmin。谢谢!

Screenshot of Android Studio: highlighted link

注册.php

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");

$name = $_POST["name"];
$age = $_POST["age"];
$username = $_POST["username"];
$password = $_POST["password"];   
$statement = mysqli_prepare($con, "INSERT INTO User (name, age, username, password) VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($statement, "siss", $name, $age, $username, $password);
mysqli_stmt_execute($statement);
mysqli_stmt_close($statement);
mysqli_close($con);
?>

获取用户数据.php

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");

$username = $_POST["username"];
$password = $_POST["password"];

$statement = mysqli_prepare($con, "SELECT * FROM User WHERE username = ? AND password = ?");
mysqli_stmt_bind_param($statement, "ss", $username, $password);
mysqli_stmt_execute($statement);

mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement, $userID, $name, $age, $username,     $password);

$user = array();

while(mysqli_stmt_fetch($statement)){
    $user["name"] = $name;
    $user["age"] = $age;
    $user["username"] = $username;
    $user["password"] = $password;
}

echo json_encode($user);
mysqli_close($con);
?>

Answer 1

使用这个代替本地主机:http://10.0.2.2 Reference